public inbox for [email protected]  

help / color / mirror / Atom feed

From: Laurenz Albe <[email protected]>
To: Yang Steve <[email protected]>
Cc: Rita <[email protected]>
Cc: [email protected]
Subject: Re: recovery.conf and archive_cleanup_command
Date: Fri, 12 May 2023 16:52:56 +0200
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH4uYX5dweEnoUgi8Z4tLfuX7K3stY84N+Z=iq9sxsQB=pY2Kg@mail.gmail.com>
References: <CAOF-KfhGM28vyE+HShrfnTNx8PYBeyTkiNGDA_xPF1DDS_PEHg@mail.gmail.com>
	<[email protected]>
	<CAH4uYX5dweEnoUgi8Z4tLfuX7K3stY84N+Z=iq9sxsQB=pY2Kg@mail.gmail.com>

On Fri, 2023-05-12 at 23:45 +1000, Yang Steve wrote:
> Laurenz Albe <[email protected]> 于2022年10月10日周一 04:33写道：
> > 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?
>
> I am using PostgreSQL Version 15 now, however, archive_cleanup_command only triggered on standby box, not on primary.
> Is that expected as designing?

Yes.  It is a recovery parameter, and they are only used if PostgreSQL is in recovery.
The parameter makes no sense unless you are recovering.

Yours,
Laurenz Albe

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: recovery.conf and archive_cleanup_command
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox