On 11/20/2016 10:00 PM, Subhankar Chattopadhyay wrote:
Thanks for reply. In situations where slave is behind master, if I don't start over, will it catch up automatically? I am using 9.4 version.
it should stay within a few seconds under normal conditions. why is it falling behind, is your write workload too high for the speed of the connection between the hosts? or is the slave shut down for some period of time?
If the slave is intermittently offline, and if you're using replication slots (that was a new feature in 9.4), then the master will hold a queue of pending data as long as is needed until the slave catches up again.
Alternately, you can increase wal_keep_segments for a long enough interval to cover the worst case time the slave is offline, or you can implement a wal archive that the slave can recover from when resuming streaming replication.
See https://www.postgresql.org/docs/9.4/static/warm-standby.html for discussions of these various options.
-- john r pierce, recycling bits in santa cruz -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general