Guidance for DBAs# Encrypting columns in PGD Comparing encryption methods Planning for encryption in a distributed cluster Handling indexing and search on encrypted columns Accounting for CPU overhead Planning for storage and WAL growth Encrypting columns using pgcrypto Encrypting columns using DBMS_CRYPTO Managing encryption keys securely 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 a failed node Assessing the cluster state Removing the failed nodes from the cluster Minority failure (quorum maintained) Majority failure (quorum lost) Verifying the nodes have been removed from the cluster Recovering the failed nodes Stopping the database and preparing the data directory Running pgd node setup Validating the recovered node Verifying cluster health Troubleshooting Post-recovery checklist Developing applications for geo-replication When geo-replication affects your application Make your application geo-replication ready Connect through Connection Manager Choose commit scopes per operation Design your schema to minimize conflicts Configure selective replication Handle retries correctly Run DDL safely Setting up access controls Securing inter-node connections Setting up an authentication method Verifying the configuration Securing client application connections Securing client to Connection Manager connections Securing Connection Manager to node connections Handling replication apply errors Choosing an error policy Configuring the error policy Responding to a disabled subscription Resolving individual changes Handling truncated captures Monitoring for accumulated failures Configuring connection pooling Prerequisites Enabling connection pooling Monitoring the pool Migrating from pgBouncer
