On Fri, Sep 5, 2014 at 12:33 AM, Alexey Klyukin <alexk@hintbits.com> 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.