Re: Standby is not removing restored WAL segments - Mailing list pgsql-admin

From bricklen
Subject Re: Standby is not removing restored WAL segments
Date
Msg-id CAGrpgQ9+fpaAVXVXspEis6mJt3tJ6ZtXcxLYPmUWbX3qkOpzUA@mail.gmail.com
Whole thread Raw
In response to Standby is not removing restored WAL segments  (Alexey Klyukin <alexk@hintbits.com>)
Responses Re: Standby is not removing restored WAL segments  (Alexey Klyukin <alexk@hintbits.com>)
List pgsql-admin

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.

Again, that's only a WAG.

pgsql-admin by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Next
From: Alexey Klyukin
Date:
Subject: Re: Standby is not removing restored WAL segments