public inbox for [email protected]  

help / color / mirror / Atom feed

From: Stephen Frost <[email protected]>
To: Yogesh Jadhav <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Pavel Tide <[email protected]>
Cc: [email protected]
Subject: Re: suppress empty archive_command warning message
Date: Sun, 25 Apr 2021 13:26:22 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <PS2PR03MB370260F10EA97D77B26FDE1AC4439@PS2PR03MB3702.apcprd03.prod.outlook.com>
References: <CAAnkphW8RpmwodKyjQhT+6jaOSLG=ERd7n-9DHr0CLRSY2W+mg@mail.gmail.com>
	<[email protected]>
	<[email protected]>
	<PS2PR03MB370260F10EA97D77B26FDE1AC4439@PS2PR03MB3702.apcprd03.prod.outlook.com>

Greetings,

Please don't top-post on these lists.

* Yogesh Jadhav ([email protected]) wrote:
> Why would anyone want to set archive_mode on and empty archive_command?

Well, not very likely, which is why there's a warning sent out about it.

That said, when doing things like promoting a new node for a failover,
or maybe doing a restore to a new system for some kind of testing or
development work, etc, there could be reasons that you'd want archiving
enabled but not want the archive_command to actually be set (yet).

Thanks,

Stephen

> > On 24-Apr-2021, at 1:08 AM, Stephen Frost <[email protected]> wrote:
> > 
> > Greetings,
> > 
> > * Bruce Momjian ([email protected]) wrote:
> >> On Fri, Apr 23, 2021 at 08:48:39PM +0200, Pavel Tide wrote:
> >>> Is there a way to suppress the WARNING that is thrown in PG logs if
> >>> archive_mode is enabled but the archive command is empty? Maybe some
> >>> configuration key which I have overlooked?
> >> 
> >> Have you tried putting "/bin/true" in there, for non-Windows?
> > 
> > Erm, that would cause all WAL to just be silently thrown away..  To have
> > the same behavior as having it be unset, you'd set it to '/bin/false'.
> > 
> > Of course, which you want depends, but generally you should be using a
> > real archive command to archive your WAL, not throwing it away.
> > 
> > Thanks,
> > 
> > Stephen


Attachments:

  [application/pgp-signature] signature.asc (819B, ../[email protected]/2-signature.asc)
  download

view thread (15+ messages)  latest in thread

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], [email protected], [email protected]
  Subject: Re: suppress empty archive_command warning message
  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