Microsoft Docs

Azure Database for PostgreSQL

Azure Database for PostgreSQL is a fully managed relational database service based on the PostgreSQL open-source database engine. It allows you to focus on application innovation rather than on infrastructure management. This service supports the PostgreSQL community edition, offering high availability, elastic scalability, and robust security features.

Key Features

• Managed Service: Automated patching, backups, high availability, and monitoring.
• Flexible Deployment: Choose between Single Server, Flexible Server, and Hyperscale (Citus) deployment options to suit your workload needs.
• High Availability: Built-in failover capabilities to ensure continuous operation.
• Scalability: Scale compute and storage resources up or down as your application demands change.
• Security: Robust security features including network isolation, SSL encryption, Azure Active Directory authentication, and advanced threat protection.
• Performance: Optimized for performance with various compute and storage tiers.

Getting Started

Learn how to create and manage your Azure Database for PostgreSQL instances. Explore tutorials, quickstarts, and how-to guides.

• Quickstart: Create an Azure Database for PostgreSQL - Single Server
• Quickstart: Create an Azure Database for PostgreSQL - Flexible Server
• Tutorial: Design a relational data model in Azure Database for PostgreSQL
• How to: Connect to Azure Database for PostgreSQL

Deployment Options

Azure Database for PostgreSQL offers different deployment options tailored to specific needs:

• Single Server: A fully managed PostgreSQL server in the cloud. Ideal for new cloud-based applications or migrating existing workloads with minimal effort.
• Flexible Server: Offers more granular control over database management, cost optimization, and increased flexibility for production workloads.
• Hyperscale (Citus): Distributes your PostgreSQL data across multiple nodes, enabling you to scale out your database for massive datasets and high transaction volumes.

Common Tasks

• Managing Azure Database for PostgreSQL server parameters
• Monitoring and tuning performance
• Configuring firewall rules
• Implementing replication and high availability
• Performing backups and restores

Reference Material

Access comprehensive API references, command-line tools (CLI), and SDKs for programmatic management of your PostgreSQL instances.

• Azure CLI reference for PostgreSQL
• Azure SDKs for PostgreSQL
• REST API reference

Community and Support

Find answers to your questions, share your knowledge, and connect with the Azure PostgreSQL community.

• Microsoft Q&A for Azure Database for PostgreSQL
• Stack Overflow

Create an Azure Database for PostgreSQL