Re: Archive directory

From: Paul Förster <paul(dot)foerster(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Yambu <hyambu(at)gmail(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 14:02:32
Message-ID: 92588443-EB0E-412B-B768-301603D21CCA@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi Scott,

> On 07. Dec, 2020, at 14:53, Scott Ribe <scott_ribe(at)elevated-dev(dot)com> wrote:
>
> The point of the archive command is to copy to the replica. If you're archiving on master, then using some script to copy to replica, then postgres has no way to know when it is safe to delete WAL files.

in my understanding, this is only true if you don't use replication slots. If you use replication slots then the primary should know when a WAL file is no longer needed and abandoned or ready to be recycled.

Cheers,
Paul

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message MichaelDBA 2020-12-07 14:08:15 Re: Archive directory
Previous Message Yambu 2020-12-07 14:01:29 Re: Archive directory