Search Postgresql Archives

Re: pg_basebackup on slave running for a long time

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux