I use postgresql 9.1 replication to a lot of workstations that have postgresql on hot standby mode. However sometimes these workstations go offline and disconnect from the master server. If they go offline for more than say a day they stop replicating, because the wal segments are no longer available. My question is how do I properly configure the master and the standby servers so that they can still replicate even after being disconnected from each other for several days.
PostgreSQL – WAL Saving for Offline Standby Servers
postgresqlreplication
Related Question
- Postgresql – Witnessing standby failure with repmgr
- PostgreSQL 9.1, how to restore a Hot Standby Slave w/o any Wal Files
- PostgreSQL Hotstandby – How to Configure Automatic Failover?
- PostgreSQL – Docker Incorrect Resource Manager Data Checksum in Record
- PostgreSQL Replication – Fast Shutdown Mode for Standby Server
- Postgresql – archive_cleanup_command with multiple standby servers
- PostgreSQL – Resolving 100% CPU Usage After Configuring WAL Log Shipping Hot Standby
Best Answer
Set up WAL archiving. If the master no longer retains enough WAL your replica will fall back to its
archive_command
.See the documentation and this post I wrote earlier.