Best Practices

This chapter describes best practices for working with RDS for PostgreSQL and provides operational guidelines that you can follow when using this service.

**Table 1** RDS for PostgreSQL best practices
Reference	Description
Creating a Cross-Region DR Relationship for an RDS for PostgreSQL Instance	Describes how to create a cross-region DR relationship for an RDS for PostgreSQL instance.
RDS for PostgreSQL Publications and Subscriptions	Describes publications and subscriptions of RDS for PostgreSQL.
User-Defined Data Type Conversion	Describes how to create user-defined data type conversion functions in RDS for PostgreSQL.
Using Client Drivers to Implement Failover and Read/Write Splitting	Describes how to use client drivers to enable failover and read/write splitting.
Using pg_waldump to Parse WAL Logs of RDS for PostgreSQL	Describes how to use the open-source pg_waldump to parse WAL logs of RDS for PostgreSQL.
Best Practices for Using PoWA	Describes how to use PoWA to monitor the performance of RDS for PostgreSQL instances.
Best Practices for Using pg_dump	Describes how to use pg_dump to back up data.
Best Practices for Using PgBouncer	Describes how to install, configure, and use PgBouncer.
Creating a Read-Only User	Describes how to create read-only users for RDS for PostgreSQL instances.
RDS for PostgreSQL Table Design	Describes how to design RDS for PostgreSQL table structures to match your workloads.
RDS for PostgreSQL Permissions Management	Describes how to manage user privileges for RDS for PostgreSQL instances.
Troubleshooting WAL Accumulation	Describes how to troubleshoot WAL accumulation of RDS for PostgreSQL instances.
Updating, Deleting, or Inserting Data Records at a Time	Describes how to efficiently insert, update, and delete data records at a time for RDS for PostgreSQL instances.
Using Event Triggers to Implement the DDL Recycle Bin, Firewalls, and Incremental Synchronization	Describes how to use PostgreSQL event triggers to implement the DDL recycle bin, firewalls, and incremental synchronization.
Creating Replication Slots to Enable CDC	Describes how to enable CDC for an RDS for PostgreSQL instance.
Read/Write Splitting with Pgpool	Describes how to use pgpool to implement read/write splitting for RDS for PostgreSQL DB instances and read replicas.
User Preference Recommendation Systems	Describes how to design a user recommendation system with RDS for PostgreSQL.
Suggestions on RDS for PostgreSQL Metric Alarm Configurations	Describes how to configure RDS for PostgreSQL metric alarm rules.
Security Best Practices	Provides guidance on RDS for PostgreSQL security configurations.