Re: recovery.conf and archive_cleanup_command

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Rita <rmorgan466(at)gmail(dot)com>, pgsql-novice(at)postgresql(dot)org
Subject: Re: recovery.conf and archive_cleanup_command
Date: 2022-10-09 17:32:51
Message-ID: a50f44d5dbb3bef00594c7539479b29ca464a0dc.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Sat, 2022-10-08 at 08:51 -0400, Rita wrote:
> I have primary and standby replication setup.
>
> On my primary the archive directory is rather large (30GB) and growing. On my standby I have recovery.conf which has 
> archive_cleanup_command = 'pg_archivecleanup -d /var/lib/pgsql/11/data/archive %r'
>
> I was under the impression this line would remove data from my primary AND standby. Is that not the case?

That depends on your PostgreSQL version, for instance.

Also, it depends on whether the standby server is running and actually recovering.
Finally, it depends on whether the standby can execute the command successfully or not.

Did you look at the standby's logs?

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Bart Jonk 2022-10-10 08:50:45 odbc drivers
Previous Message Rita 2022-10-08 12:51:08 recovery.conf and archive_cleanup_command