Re: Archive cleanup

Use PgBackRest, and make your life a *lot* easier.

On 8/5/23 19:36, Rajesh Kumar wrote:
> Archive is must for point in time recovery right?
>
> On Fri, 4 Aug 2023 at 06:48, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> wrote:
>
> On Fri, Aug 4, 2023 at 5:04 AM Rajesh Kumar
> <rajeshkumar(dot)dba09(at)gmail(dot)com> wrote:
>
> Hi friends,
>
> Anybody let me know how to automate the archive clean up in postgres.
>
>
> If the only reason you have an archive is so a standby can get the
> WAL, then you can just use a slot instead.  If you don't have an
> archive, you don't need to clean it up.
>
> If you are using the archive for something else, you would need to
> tell us what that is.  Otherwise, you are just asking "how long is a
> piece of string"?
>
> Cheers,
>
> Jeff
>

--
Born in Arizona, moved to Babylonia.