Working with Amazon Aurora PostgreSQL

Amazon Aurora PostgreSQL is a fully managed, PostgreSQL-compatible, and ACID-compliant relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora PostgreSQL is a drop-in replacement for PostgreSQL and makes it simple and cost-effective to set up, operate, and scale your new and existing PostgreSQL deployments, thus freeing you to focus on your business and applications. Amazon RDS provides administration for Aurora by handling routine database tasks such as provisioning, patching, backup, recovery, failure detection, and repair. Amazon RDS also provides push-button migration tools to convert your existing Amazon RDS for PostgreSQL applications to Aurora PostgreSQL.

Aurora PostgreSQL can work with many industry standards. For example, you can use Aurora PostgreSQL databases to build HIPAA-compliant applications and to store healthcare related information, including protected health information (PHI), under a completed Business Associate Agreement (BAA) with AWS.

Aurora PostgreSQL is FedRAMP HIGH eligible. For details about AWS and compliance efforts, see AWS services in scope by compliance program.

Topics

• Security with Amazon Aurora PostgreSQL
• Updating applications to connect to Aurora PostgreSQL DB clusters using new SSL/TLS certificates
• Migrating data to Amazon Aurora with PostgreSQL compatibility
• Managing Amazon Aurora PostgreSQL
• Best practices with Amazon Aurora PostgreSQL
• Replication with Amazon Aurora PostgreSQL
• Integrating Amazon Aurora PostgreSQL with other AWS services
• Exporting data from an Aurora PostgreSQL DB cluster to Amazon S3
• Managing query execution plans for Aurora PostgreSQL
• Publishing Aurora PostgreSQL logs to Amazon CloudWatch Logs
• Using machine learning (ML) with Aurora PostgreSQL
• Fast recovery after failover with cluster cache management for Aurora PostgreSQL
• Invoking an AWS Lambda function from an Aurora PostgreSQL DB cluster
• Using the oracle_fdw extension to access foreign data in Aurora PostgreSQL
• Managing PostgreSQL partitions with the pg_partman extension
• Using Kerberos authentication with Aurora PostgreSQL
• Amazon Aurora PostgreSQL reference
• Amazon Aurora PostgreSQL updates