3 ms·
I'm also self-hosting Postgres, and the project is getting to the point where a standby would be a good idea to ensure higher availability. Did you use any par
by GordonS 2y ago
I'm also self-hosting Postgres, and the project is getting to the point where a standby would be a good idea to ensure higher availability.
Did you use any particular guide for setting up replication? Also, how do you handle failover/fallback to/from standby please?
- Tostino 2y agoNot OP, but managed a ~1tb Postgres install for years. You should use something like pgbackrest or barman to help with both replication (replicas can pull WAL from your backups when catching up), backups, and failovers. At least for pgbackrest, set up a spool directory which allows async wal push / fetch.