On Fri, Sep 5, 2014 at 12:33 AM, Alexey Klyukin <alexk@xxxxxxxxxxxx> wrote:
We've got a 9.3.5 DB running in a standby mode for a fairly large DB
(500GB) with a busy WAL traffic (couple of GBs per hour) and it
occasionally 'forgets' to remove the segments it restored.
A complete shot in the dark, but do you take backups from that server, and if so, does the backup script "pause" replication via "pg_xlog_replay_pause()"? If so, "select pg_is_xlog_replay_paused();" should return true, and executing "select pg_xlog_replay_resume()" will un-pause replication.
Again, that's only a WAG.
