Re: Standby is not removing restored WAL segments

Поиск
Список
Период
Сортировка
От bricklen
Тема Re: Standby is not removing restored WAL segments
Дата
Msg-id CAGrpgQ9+fpaAVXVXspEis6mJt3tJ6ZtXcxLYPmUWbX3qkOpzUA@mail.gmail.com
обсуждение исходный текст
Ответ на Standby is not removing restored WAL segments  (Alexey Klyukin <alexk@hintbits.com>)
Ответы Re: Standby is not removing restored WAL segments  (Alexey Klyukin <alexk@hintbits.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] Re: Cannot retrieve images inserted through VB and odbc, after a table reorganization.
Следующее
От: Alexey Klyukin
Дата:
Сообщение: Re: Standby is not removing restored WAL segments