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

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Suppress logging of "pg_hba.conf rejects connection for host"
Date: 2023-04-17 13:11:54
Message-ID: 4dcbad87-4727-9649-9d1d-f5c1aa768b83@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 4/16/23 10:02, ertan(dot)kucukoglu(at)1nar(dot)com(dot)tr wrote:
> Hello,
>
> 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?

1. Why do you need that line, instead of just allowing in the addresses you
want?
2. Why are you getting so many "illegal" connection attempts?
3. Auditors like to see that you're rejecting "illegal" connection attempts.

--
Born in Arizona, moved to Babylonia.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Siddharth Jain 2023-04-17 15:37:16 Question on SSI - Serializable Snapshot Isolation
Previous Message Peter Smith 2023-04-17 12:16:50 Re: Support logical replication of DDLs