From: Jerry Sievers <gsievers19@comcast.net>
To: Alexey Klyukin <alexk@hintbits.com>
Cc: bricklen <bricklen@gmail.com>
Cc: pgsql-admin\@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Standby is not removing restored WAL segments
Date: Mon, 08 Sep 2014 12:06:45 -0500
Message-ID: <86y4tudot6.fsf@jerry.enova.com> (raw)
In-Reply-To: <CAAS3ty+gey_FVPpa2Vq9SnJ7hn3TQv0erG6kpVA4ZF1aNMobPw@mail.gmail.com>
References: <CAAS3tyLnXaYDZ0+zhXLPdVtOvHQOvR+jSPhp30o8kvWqQs0Tqw@mail.gmail.com>
<CAGrpgQ9+fpaAVXVXspEis6mJt3tJ6ZtXcxLYPmUWbX3qkOpzUA@mail.gmail.com>
<CAAS3ty+gey_FVPpa2Vq9SnJ7hn3TQv0erG6kpVA4ZF1aNMobPw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, alexk@hintbits.com, bricklen@gmail.com
Subject: Re: Standby is not removing restored WAL segments
In-Reply-To: <86y4tudot6.fsf@jerry.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox