Re: hot standby, how to disable WAL archiving ?

Поиск
Список
Период
Сортировка
От John Scalia
Тема Re: hot standby, how to disable WAL archiving ?
Дата
Msg-id CABzCKRA0YmFfg_P9zjPLGNoFX6LWyi26pn-UaKNSB=xJgea4OQ@mail.gmail.com
обсуждение исходный текст
Ответ на hot standby, how to disable WAL archiving ?  (Roman Shubovich <r.shubovich@gmail.com>)
Ответы Re: hot standby, how to disable WAL archiving ?
Список pgsql-admin
Дерево обсуждения
Hi Roman,

Maybe one of the developers can chime in on this, but to my knowledge, as at least one WAL file should be available for the server to successfully start, you can't turn these off entirely. My suggestion would be to set wal_keep_segments to a much smaller number, even "1", Also, did you change the default size of the WAL segments? I can't actually remember the exact name for this parameter, but the default is 16MB. You can have this set to a much larger value.
--
Jay

On Tue, Sep 29, 2015 at 6:01 PM, Roman Shubovich <r.shubovich@gmail.com> wrote:
hi

I've up master-slave streaming replication.
each host have RAM tmpfs disk for WAL files with 5BG space, and my config is:

wal_keep_segments = 64
checkpoint_segments = 32
checkpoint_timeout = 1h
checkpoint_completion_target = 0.8
WAL archiving is off

master host works as expected - he keeps about 140-160 files in the pg_xlog folder
but standby host ignore the config, he won't remove old wal files and in archive_status folder I can see many xxxxxx.done files, but archiving is not enabled.

how can I disable that behavior ?

I already tried playing with archive_cleanup_command, recovery_end_command, pg_archivecleanup - nothing helped.
when standby host operate as master server then no problems occurs

postgres version 9.4.4, compiled from source
OS ubuntu 14.04.3

В списке pgsql-admin по дате отправления:

Предыдущее
От: Roman Shubovich
Дата:
Сообщение: hot standby, how to disable WAL archiving ?
Следующее
От: Keith
Дата:
Сообщение: Re: hot standby, how to disable WAL archiving ?