Re: WAL archive (archive_mode = always) ? - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: WAL archive (archive_mode = always) ?
Date
Msg-id CAMkU=1zv6ihzih5vFwq0Xu_Ts-9hg923pZS45EhDG03=VcteXA@mail.gmail.com
Whole thread Raw
In response to WAL archive (archive_mode = always) ?  (Adelino Silva <adelino.j.silva@googlemail.com>)
List 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 by date:

Previous
From: Nicky Larson
Date:
Subject: Contribution to postgresql
Next
From: Andres Freund
Date:
Subject: vacuum fails with "could not open statistics file" "Device orresource busy"