PostgreSQL supports multiple replication strategies for high availability, read scaling, and disaster recovery. Replication Types Type Description Use Case Streaming Replication Physical byte-for-byte copy via WAL HA standby, failover Logical Replication Replicates changes at row level Selective tables, cross-version Synchronous Primary waits for standby confirmation Zero data loss Asynchronous Primary doesn't wait Better write performance Streaming Replication The most common setup. The primary streams WAL records to one or more standbys. Standbys can serve read-only queries (hot standby). Logical Replication Uses a publication/subscription model. The publisher defines which tables to replicate; subscribers consume changes. Useful for: Replicating specific tables Cross-version upgrades…