On 06/01/2016 06:43 PM, Jeff Beck wrote:
Hi- We have a master (pg 9.4.4 on Ubuntu 14.10) and a slave (pg 9.4.8 on Centos 7). During a period of heavy use, the slave began complaining that the “requested WAL segment xxxxxx has already been removed”. But the WAL segment was still on the master. The issue was resolved by manually copying the pg_xlog directory over to the slave.
What is your setup?: 1) Streaming 2) WAL archiving 3) Both 4) Do you have more then one standby?
I don’t see any errors on the master log file, or any other messages on the slave’s. What happened? How can this be prevented in the future? Thanks, Jeff
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
