Re: Archive directory

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Yambu <hyambu(at)gmail(dot)com>
Cc: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>, Ian Lawrence Barwick <barwick(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Archive directory
Date: 2020-12-07 18:15:48
Message-ID: CAMkU=1xU4nWAuZBP6c2hcYQjOvCqmWZr8SkrPt8UDOfADBHx+A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Mon, Dec 7, 2020 at 9:01 AM Yambu <hyambu(at)gmail(dot)com> wrote:

> Ok, whats happens in the case when you have 2 slave servers?
>

Then use streaming replication with replication slots, and don't use a WAL
archive at all. This is what replication slots were invented for.

If you are using an archive merely to support replication, then you are
using an archaic setup.

You might have a good reason for using a WAL archive, but you haven't
described what that reason is.

Cheers,

Jeff

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2020-12-08 00:45:46 reindexing db
Previous Message Paul Förster 2020-12-07 14:31:21 Re: Archive directory