Guidance for DBAs# Ensuring security Setting up access controls Securing inter-node connections Securing client application connections Encrypting columns in PGD Comparing encryption methods Planning for encryption in a distributed cluster Encrypting columns using pgcrypto Encrypting columns using DBMS_CRYPTO Managing encryption keys securely Configuring connection pooling Prerequisites Enabling connection pooling Monitoring the pool Migrating from pgBouncer Managing geo-replication When to use geo-replication Deployment workflow 1. Choose a deployment pattern 2. Plan your node distribution and create subgroups 3. Configure routing 4. Configure commit scopes 5. Tune replication and sequences 6. Configure lag control 7. Verify the cluster and prepare for operations Using tiered storage Understanding table types Tiered storage strategies Implementing tiered tables Replicating to analytics Offloading to analytics Metadata management Setting up PGAA Implementing tiered tables Replicating to analytics Offloading to analytics Recovering from failures Handling replication apply errors Choosing an error policy Configuring the error policy Responding to a disabled subscription Monitoring for accumulated failures Recovering a failed node Assessing the cluster state Removing the failed nodes from the cluster Recovering the failed nodes Validating the recovered node Verifying cluster health Troubleshooting Post-recovery checklist
