Azure > Services > Databases > Azure Database for PostgreSQL

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 offers:

High availability and disaster recovery
Scalable compute and storage
Automated backups and point-in-time restore
Security features including encryption and network isolation
Integration with other Azure services

Key Features and Capabilities

Managed Service

Azure handles all routine database maintenance, including patching, backups, and high availability, allowing you to concentrate on your applications.

Flexible Deployment Options

Choose between the Single Server deployment option for simpler workloads or the Flexible Server option for more granular control over configuration and costs, with enhanced availability features.

Performance and Scalability

Scale your database resources up or down on demand to meet your changing workload requirements. Azure Database for PostgreSQL offers various pricing tiers (General Purpose, Memory Optimized) to match your performance needs.

Security and Compliance

Protect your data with built-in security features like SSL/TLS encryption, Azure Active Directory authentication, and private endpoints for network isolation. The service adheres to numerous compliance standards.

Did you know? Azure Database for PostgreSQL supports up to 64 TB of storage and compute up to 64 vCores, making it suitable for demanding enterprise workloads.

Getting Started

Begin your journey with Azure Database for PostgreSQL by exploring the following resources:

Reference Documentation

Dive deeper into specific aspects of Azure Database for PostgreSQL:

Code Examples

Explore code samples for common operations:

                
-- Example: Creating a table using psql client
CREATE TABLE IF NOT EXISTS public.products
(
    id serial PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    price NUMERIC(10, 2) NOT NULL
);

-- Example: Inserting data
INSERT INTO public.products (name, price) VALUES
('Laptop', 1200.00),
('Keyboard', 75.50),
('Mouse', 25.00);

-- Example: Querying data
SELECT id, name, price FROM public.products WHERE price > 100.00;
                
            

For more detailed information, please consult the official Concepts and Troubleshooting guides.

Azure Documentation