Re: WAL archive (archive_mode = always) ?

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: WAL archive (archive_mode = always) ?
Дата
Msg-id CAMkU=1zv6ihzih5vFwq0Xu_Ts-9hg923pZS45EhDG03=VcteXA@mail.gmail.com
обсуждение исходный текст
Ответ на WAL archive (archive_mode = always) ?  (Adelino Silva <adelino.j.silva@googlemail.com>)
Список pgsql-hackers
Дерево обсуждения

On Fri, Oct 19, 2018 at 10:00 AM Adelino Silva <adelino.j.silva@googlemail.com> wrote:
Hi,

What is the advantage to use archive_mode = always in a slave server compared to archive_mode = on (shared WAL archive) ?
I only see duplication of Wal files, what is the purpose of this feature ?

You might not have a shared wal archive in the first place.  For example, your only access to the master is through the streaming replication protocol, but you want to maintain a local WAL archive anyway so you can PITR locally for testing or debugging purposes.

Cheers,

Jeff

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

Предыдущее
От: Nicky Larson
Дата:
Сообщение: Contribution to postgresql
Следующее
От: Andres Freund
Дата:
Сообщение: vacuum fails with "could not open statistics file" "Device orresource busy"