PostgreSQL replication and failover
Admin Guide
Maintenance
You can run the Knocknoc database on a pair of PostgreSQL servers. If one server fails, you switch to the other in a few minutes instead of restoring from a backup. This guide covers building the pair, backing it up, and failing over from one server to the oth...