Re: WAL archive (archive_mode = always) ?

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Adelino Silva <adelino(dot)j(dot)silva(at)googlemail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: WAL archive (archive_mode = always) ?
Date: 2018-10-19 14:07:31
Message-ID: 20181019140731.GI2099@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Oct 19, 2018 at 03:00:15PM +0100, Adelino Silva wrote:
> 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?

Some users like having redundancy in their backups and archives, so as
all things are on multiple location. archive_mode = always helps in
leveraging these needs.
--
Michael

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2018-10-19 14:19:44 Re: ERROR's turning FATAL in BRIN regression tests
Previous Message Michael Paquier 2018-10-19 14:00:47 Re: removing unnecessary get_att*() lsyscache functions