Content-Type: text/plain;
	charset=utf-8
Mime-Version: 1.0 (Mac OS X Mail 14.0 \(3654.20.0.2.21\))
Subject: Re: Archive directory
From: =?utf-8?Q?Paul_F=C3=B6rster?= <paul.foerster@gmail.com>
In-Reply-To: <9076CFB7-5E9B-4458-AD4F-BC94AE3B6A0F@elevated-dev.com>
Date: Mon, 7 Dec 2020 15:31:21 +0100
Cc: Yambu <hyambu@gmail.com>,
 Ian Lawrence Barwick <barwick@gmail.com>,
 Pgsql-admin <pgsql-admin@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <A8B05077-547F-4899-9D9E-4051C02DA2BE@gmail.com>
References: 
 <CALhHtcBhOqhHmRjgiLfCKVS0mV3PSBS_61ZkKT9NvjNYMQw5wQ@mail.gmail.com>
 <CAB8KJ=gLEma2G3yGy6dO1PRtG1-nrRzTFcg8g17a8bPLXs5ODw@mail.gmail.com>
 <CALhHtcBRydsziEtQV+7rj81rHhL4N4jwTqGbBWDnLRMnB0tLBw@mail.gmail.com>
 <5AAB0FED-45AA-45F6-AFB5-A65A36275492@elevated-dev.com>
 <92588443-EB0E-412B-B768-301603D21CCA@gmail.com>
 <9076CFB7-5E9B-4458-AD4F-BC94AE3B6A0F@elevated-dev.com>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Precedence: bulk

Hi Scott, hi Yambu,

> On 07. Dec, 2020, at 15:11, Scott Ribe <scott_ribe@elevated-dev.com> =
wrote:
>=20
>> On Dec 7, 2020, at 7:02 AM, Paul F=C3=B6rster =
<paul.foerster@gmail.com> wrote:
>>=20
>> 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.
>=20
> I don't think OP is talking about the WAL files PG is managing; I =
think he's talking about WAL files copied into an archive directory.

if those files already archived to some destination are referred to, =
then yes, you can do with them whatever you want. They can be removed if =
they are not needed for a PITR.

For example, we remove them time-based. Files older than a certain =
number of days are removed (cron job, note: the job only removes files =
in the archive destination, NOT in ${PGDATA}/pg_wal).

Cheers,
Paul=