| From: | bricklen <bricklen(at)gmail(dot)com> |
|---|---|
| To: | Alexey Klyukin <alexk(at)hintbits(dot)com> |
| Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Standby is not removing restored WAL segments |
| Date: | 2014-09-08 01:52:28 |
| Message-ID: | CAGrpgQ9+fpaAVXVXspEis6mJt3tJ6ZtXcxLYPmUWbX3qkOpzUA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexey Klyukin | 2014-09-08 14:18:57 | Re: Standby is not removing restored WAL segments |
| Previous Message | Adrian Klaver | 2014-09-05 22:09:04 | Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization. |