Re: Standby is not removing restored WAL segments

On Mon, Sep 8, 2014 at 3:52 AM, bricklen <bricklen(at)gmail(dot)com> wrote:
>
> On Fri, Sep 5, 2014 at 12:33 AM, Alexey Klyukin <alexk(at)hintbits(dot)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.

>
> Again, that's only a WAG.
>

Thanks. we do take DB backups from this server, but not from this
cluster on it, so it's not a backup interference.

--
Regards,
Alexey Klyukin