HAQM RDS for PostgreSQL

Easy to manage relational databases optimized for total cost of ownership

Create an AWS Account

PostgreSQL has become the preferred open source relational database for many enterprise developers and startups, powering leading business and mobile applications. HAQM RDS makes it easier to set up, operate, and scale PostgreSQL deployments on the cloud. With HAQM RDS, you can deploy scalable PostgreSQL deployments in minutes with cost-efficient and resizable hardware capacity. HAQM RDS manages complex and time-consuming administrative tasks such as PostgreSQL software installation and upgrades, storage management, replication for high availability and read throughput, and backups for disaster recovery.

HAQM RDS for PostgreSQL gives you access to the capabilities of the familiar PostgreSQL database engine. This means that the code, applications, and tools you already use today with your existing databases can be used with HAQM RDS. HAQM RDS for PostgreSQL currently supports PostgreSQL 11, 12, 13, 14, 15,  16, and 17. With Trusted Language Extensions (TLE) for PostgreSQL, you can build high performance extensions and safely run them on HAQM RDS using popular trusted languages without needing AWS to certify code.

Benefits of RDS for PostgreSQL

It takes only a few steps in the AWS Management Console to launch and connect to a production-ready PostgreSQL database in minutes. HAQM RDS for PostgreSQL database instances are preconfigured with parameters and settings for the server type you have selected. Database parameter groups provide granular control and fine-tuning of your PostgreSQL database. When you need to make a database update, HAQM RDS
Blue/Green Deployments are designed to make them safer, simpler, and faster.

HAQM RDS provides two SSD-backed storage options for your PostgreSQL database. General Purpose storage provides cost-effective storage for small or medium-sized workloads. For high-performance OLTP applications, Provisioned IOPS delivers consistent performance of up to 40,000 IOs per second. As your storage requirements grow you can provision additional storage on the fly with zero downtime.

The automated backup feature of HAQM RDS enables recovery of your PostgreSQL database instance to any point in time within your specified retention period of up to 35 days. In addition, you can perform user-initiated backups of your DB Instance. These full database backups will be stored by HAQM RDS until you explicitly delete them.

HAQM RDS Multi-AZ deployments provide enhanced availability and durability for your PostgreSQL databases, making them a natural fit for production database workloads. HAQM RDS Read Replicas make it easier to elastically scale out beyond the capacity constraints of a single database instance for read-heavy database workloads.

As a managed service, HAQM RDS provides a high level of security for your PostgreSQL databases. These include network isolation using HAQM Virtual Private Cloud (VPC), encryption at rest using keys you create and control through AWS Key Management Service (KMS) and encryption of data in transit using SSL.