From: Jerry Sievers <gsievers19@comcast.net>
To: Alexey Klyukin <alexk@hintbits.com>
Cc: bricklen <bricklen@gmail.com>,
 "pgsql-admin\@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: Standby is not removing restored WAL segments
References: 
 <CAAS3tyLnXaYDZ0+zhXLPdVtOvHQOvR+jSPhp30o8kvWqQs0Tqw@mail.gmail.com>
 <CAGrpgQ9+fpaAVXVXspEis6mJt3tJ6ZtXcxLYPmUWbX3qkOpzUA@mail.gmail.com>
 <CAAS3ty+gey_FVPpa2Vq9SnJ7hn3TQv0erG6kpVA4ZF1aNMobPw@mail.gmail.com>
Date: Mon, 08 Sep 2014 12:06:45 -0500
In-Reply-To: 
 <CAAS3ty+gey_FVPpa2Vq9SnJ7hn3TQv0erG6kpVA4ZF1aNMobPw@mail.gmail.com>
 (Alexey Klyukin's message of "Mon, 8 Sep 2014 16:18:57 +0200")
Message-ID: <86y4tudot6.fsf@jerry.enova.com>
User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.4 (gnu/linux)
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

Alexey Klyukin <alexk@hintbits.com> writes:

> On Mon, Sep 8, 2014 at 3:52 AM, bricklen <bricklen@gmail.com> wrote:
>
>>
>> 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.
>>
>
> Thanks. we do take DB backups from this server, but not from this
> cluster on it, so it's not a backup interference.

Or...  Are your backups being taken using rsync or any non-pg_basebackup
method *and* you are copying unnecessary WALs to the target new standby
server, which then lay around forever as artifacts of not having been
omitted initially?

>
> -- 
> Regards,
> Alexey Klyukin

-- 
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin