Amazon RDS for PostgreSQL

Amazon RDS supports DB instances running several versions of PostgreSQL. For a list of available versions, see Available PostgreSQL database versions.

Note

Deprecation of PostgreSQL 9.6 is scheduled for April 26, 2022. For more information, see Deprecation of PostgreSQL version 9.6.

You can create DB instances and DB snapshots, point-in-time restores and backups. DB instances running PostgreSQL support Multi-AZ deployments, read replicas, Provisioned IOPS, and can be created inside a virtual private cloud (VPC). You can also use Secure Socket Layer (SSL) to connect to a DB instance running PostgreSQL.

Before creating a DB instance, make sure to complete the steps in Setting up your Amazon RDS environment.

You can use any standard SQL client application to run commands for the instance from your client computer. Such applications include pgAdmin, a popular Open Source administration and development tool for PostgreSQL, or psql, a command line utility that is part of a PostgreSQL installation. To deliver a managed service experience, Amazon RDS doesn't provide host access to DB instances. Also, it restricts access to certain system procedures and tables that require advanced privileges. Amazon RDS supports access to databases on a DB instance using any standard SQL client application. Amazon RDS doesn't allow direct host access to a DB instance by using Telnet or Secure Shell (SSH).

Amazon RDS for PostgreSQL is compliant with many industry standards. For example, you can use Amazon RDS for PostgreSQL databases to build HIPAA-compliant applications and to store healthcare-related information. This includes storage for protected health information (PHI) under a completed Business Associate Agreement (BAA) with AWS. Amazon RDS for PostgreSQL also meets Federal Risk and Authorization Management Program (FedRAMP) security requirements. Amazon RDS for PostgreSQL has received a FedRAMP Joint Authorization Board (JAB) Provisional Authority to Operate (P-ATO) at the FedRAMP HIGH Baseline within the AWS GovCloud (US) Regions. For more information on supported compliance standards, see AWS cloud compliance.

To import PostgreSQL data into a DB instance, follow the information in the Importing data into PostgreSQL on Amazon RDS section.

Topics

• Common management tasks for Amazon RDS for PostgreSQL
• Working with the Database Preview environment
• Available PostgreSQL database versions
• Supported PostgreSQL extension versions
• Working with PostgreSQL features supported by Amazon RDS for PostgreSQL
• Connecting to a DB instance running the PostgreSQL database engine
• Securing connections to RDS for PostgreSQL with SSL/TLS
• Using Kerberos authentication with Amazon RDS for PostgreSQL
• Using a custom DNS server for outbound network access
• Upgrades of the RDS for PostgreSQL DB engine
• Upgrading a PostgreSQL DB snapshot engine version
• Working with read replicas for Amazon RDS for PostgreSQL
• Improving query performance for RDS for PostgreSQL with Amazon RDS Optimized Reads
• Importing data into PostgreSQL on Amazon RDS
• Exporting data from an RDS for PostgreSQL DB instance to Amazon S3
• Invoking an AWS Lambda function from an RDS for PostgreSQL DB instance
• Common DBA tasks for Amazon RDS for PostgreSQL
• Tuning with wait events for RDS for PostgreSQL
• Tuning RDS for PostgreSQL with Amazon DevOps Guru proactive insights
• Using PostgreSQL extensions with Amazon RDS for PostgreSQL
• Working with the supported foreign data wrappers for Amazon RDS for PostgreSQL
• Working with Trusted Language Extensions for PostgreSQL