Comment on page
PostgreSQL on Amazon RDS
- Note Huge pages aren't supported for db.m1, db.m2, and db.m3 DB instance classes.
- Note In addition to the native PostgreSQL logical replication feature introduced in PostgreSQL 10, RDS for PostgreSQL also supports the
pglogicalextension. For more information, see Using pglogical to synchronize data across instances.
- Note A connection attempt with
--no-passwordfails when the server requires password authentication and a password is not available from other sources. For more information, see the psql documentation.
- Note If you don't set up a custom DNS server and
rds.custom_dns_resolutionis set to 1, hosts are resolved using an Amazon Route 53 private zone. For more information, see Working with private hosted zones.
- Note Amazon RDS takes DB snapshots during the upgrade process only if you have set the backup retention period for your DB instance to a number greater than 0. To change your backup retention period, see Modifying an Amazon RDS DB instance.
- Note For information about updating the PostGIS extension, see Managing spatial data with the PostGIS extension (Step 6: Upgrade the PostGIS extension). To update the
pg_repackextension, drop the extension and then create the new version in the upgraded DB instance. For more information, see pg_repack installation in the
- Note You can't upgrade automated DB snapshots that are created during the automated backup process.
- Note For cascading read replicas, RDS for PostgreSQL supports 15 read replicas for each source DB instance at first level of replication, and 5 read replicas for each source DB instance at the second and third level of replication.
- Note The PostgreSQL command
pg_dumpallrequires super_user permissions that are not granted when you create a DB instance, so it cannot be used for importing data.
- Note Cross-account export to Amazon S3 isn't supported.
- Note Invoking an AWS Lambda function is supported in these RDS for PostgreSQL versions: All PostgreSQL 15 versions PostgreSQL 14.1 and higher minor versions PostgreSQL 13.2 and higher minor versions PostgreSQL 12.6 and higher minor versions
- Note As of RDS for PostgreSQL 14.5, RDS for PostgreSQL supports Trusted Language Extensions for PostgreSQL. This feature is implemented as the extension
pg_tle, which you can add to your RDS for PostgreSQL DB instance. By using this extension, developers can create their own PostgreSQL extensions in a safe environment that simplifies the setup and configuration requirements. For more information, see Working with Trusted Language Extensions for PostgreSQL.
- Note RDS for PostgreSQL doesn't support the
utl_filepackage that is part of the orafce extension. This is because the
utl_fileschema functions provide read and write operations on operating-system text files, which requires superuser access to the underlying host. As a managed service, RDS for PostgreSQL doesn't provide host access.
- Note Parameter settings at the session level take precedence over the settings in the custom DB parameter group for the RDS for PostgreSQL DB instance. If you don't want database users to bypass your audit logging configuration settings, be sure to change their permissions.
- Note You need to have the privileges of the
pgtle_adminrole to follow this procedure.