Thread: suppress empty archive_command warning message

On Fri, Apr 23, 2021 at 08:48:39PM +0200, Pavel Tide wrote:
> Hello everyone,
> 
> 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?

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.

Greetings,

* 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?
>
> 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

Greetings,

Why would anyone want to set archive_mode on and empty archive_command?

Thanks,
Yogesh

> On 24-Apr-2021, at 1:08 AM, Stephen Frost <sfrost@snowman.net> wrote:
> 
> Greetings,
> 
> * 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?
>> 
>> 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