Re: Suppress logging of "pg_hba.conf rejects connection for host"

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Suppress logging of "pg_hba.conf rejects connection for host"
Date: 2023-04-16 15:51:58
Message-ID: 751523480.271967.1681660318625@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On 16/04/2023 17:02 CEST ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr wrote:
>
> One of the systems running PostgreSQL 14.7 receive a lot of lines like in
> the subject. I have below pg_hba.conf line and that line causes these to be
> logged.
>
> host all all 0.0.0.0/0 reject
>
> If possible, I do not want to see these lines in my logs. But, I failed to
> find a parameter for it.
>
> Is it possible to turn this specific message logging off?

There's no special config for this specific error message. It is logged as
FATAL so the only way to silence it *and any other messages from DEBUG5 to FATAL*
is to set log_min_messages = PANIC. I don't recommend it. It also complicates
troubleshooting failing connections in the future if you don't log this message.

When logging to syslog you may be able to discard specific messages.
rsyslog has property-based filters[0] for example:

:msg, contains, "pg_hba.conf rejects connection for host" ~

You should also investigate the clients that try connecting ("a lot" as you
write) and figure out why they keep connecting if you want to reject their
attempts anyway.

[0] https://rsyslog.readthedocs.io/en/latest/configuration/filters.html#property-based-filters

--
Erik

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2023-04-16 16:07:32 Re: Call a Normal function inside a Trigger Function
Previous Message Erik Wienhold 2023-04-16 15:05:49 Re: Call a Normal function inside a Trigger Function