Date: Sun, 25 Apr 2021 13:26:22 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Yogesh Jadhav <pgyogesh@outlook.com>
Cc: Bruce Momjian <bruce@momjian.us>, Pavel Tide <paveltide@gmail.com>,
	pgsql-novice@lists.postgresql.org
Subject: Re: suppress empty archive_command warning message
Message-ID: <20210425172622.GP20766@tamriel.snowman.net>
References: 
 <CAAnkphW8RpmwodKyjQhT+6jaOSLG=ERd7n-9DHr0CLRSY2W+mg@mail.gmail.com>
 <20210423191750.GA7630@momjian.us>
 <20210423193809.GL20766@tamriel.snowman.net>
 <PS2PR03MB370260F10EA97D77B26FDE1AC4439@PS2PR03MB3702.apcprd03.prod.outlook.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="jMeun4R0ds2U4966"
Content-Disposition: inline
In-Reply-To: 
 <PS2PR03MB370260F10EA97D77B26FDE1AC4439@PS2PR03MB3702.apcprd03.prod.outlook.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Archived-At: 
 <https://www.postgresql.org/message-id/20210425172622.GP20766%40tamriel.snowman.net>
Precedence: bulk


--jMeun4R0ds2U4966
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

Greetings,

Please don't top-post on these lists.

* Yogesh Jadhav (pgyogesh@outlook.com) 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 <sfrost@snowman.net> wrote:
> >=20
> > Greetings,
> >=20
> > * Bruce Momjian (bruce@momjian.us) 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?
> >>=20
> >> Have you tried putting "/bin/true" in there, for non-Windows?
> >=20
> > 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'.
> >=20
> > Of course, which you want depends, but generally you should be using a
> > real archive command to archive your WAL, not throwing it away.
> >=20
> > Thanks,
> >=20
> > Stephen

--jMeun4R0ds2U4966
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJghaY+AAoJEO1sijiDR2RVwaQP/iKLtXzybWVxZiMw+zjNkshr
uTdBdqjKrK43WQ5hYfIR5nWeW+z35+DBLG35s2gm7x3DYj1SjT9Oz+rvZWCrBteO
66Kx9/bwKpwn19bw+5C3NotcGeo/VojxQzeSyoYFFhLs7itnOquYbKkCV6KD17wl
r7EOqduWjcBE2dr8uoaRbGC+wOQ8mjN/17EVKX1jqPltDNynvyr2xNl9vgSFaN13
hpf5l1c95bLM1KvaBM2kG/1X+vYllciJ5gySQqaq9X1boQZKJZ+VH5uipxbslY3c
cm0hDPO0Quz+oseg4v3Z5tJoQhuyIpFx5tkMILR2W0G+VyeuZTTrYcwYuRr9zA0H
IkHrmpl/WkFoMaQsp2uGO4YggKESEIFIELQh/ufGHnlqH7d2qIXvkeCpMai84OnC
6HZXz+UlAttK73t0ZVj4OYFk8DnIGoVBpxsBB3cwPEuy1jFN9Y3f4Omy0+vgstuQ
wAYtPAOW1TF2/XU43xcqSdG9697xW2luzHHo+4Gw0gyreSptB+haHHqBUnHg9rsQ
+0zFnCRVyulWhqh9cLeg8QoQ2blJP1uKJ8Ml0b0WYNTrPX03Az30lw1YXLjjcrCY
uW8aTSLANkejX886gnwXRsS+BvaFsa+qBqSg7ZK2tfonnBbEv341fnBGecQnsEz/
91BpKPESCBI4Nrk7RxpJ
=apXI
-----END PGP SIGNATURE-----

--jMeun4R0ds2U4966--