Learn how to prevent transaction ID wraparound in PostgreSQL through some simple monitoring and prevent TXID wraparound from ever becoming a problem!
A guide to building an active-active PostgreSQL cluster to help meet high-availability requirements of keeping your PostgreSQL database always up and available
For most major upgrades using a utility such as pg_upgrade or a replication tool such as pglogical will be the best solution. However if these options are not available, pg_dumpall can be used to safely perform a major upgrade of your PostgreSQL database.
A practical guide to detecting if your PostgreSQL replicas are out-of-sync and how to restore them efficiently without a base backup.
Here is a case study for how to efficiently upgrade major versions of PostgreSQL with almost zero-downtime using pglogical