SELECT pg_reload_conf(); returning true despite hba file loading was failed

From: RAJAMOHAN <garajamohan(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: SELECT pg_reload_conf(); returning true despite hba file loading was failed
Date: 2021-02-05 05:59:25
Message-ID: CAFzdntvG95eRKf0NByK4edmG8AWwLvn2-AE5R8UZiwQu=YCRqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello all,

I came across this situation, where I was allowing some new ip-address to
connect to the database. But while making the change in the hba file i
added a invalid character by mistake. And i reloaded using the
pg_reload_conf function, it returns true. I thought everything was fine,
until the client people reported that they were still not able to login to
the database.

After checking the logs, I found out that the hba file was not loaded
successfully because of the invalid character. My concern is
why pg_reload_conf is returning true if the load was unsuccessful.

Is there any option to check if the load is successful or not, without
going through the logs?

PostgreSQL 10.15 (Ubuntu 10.15-0ubuntu0.18.04.1)

postgres=# select pg_reload_conf();
pg_reload_conf
----------------
t

In logs below error was reported:

line 45 of configuration file ""/******************/pg_hba.conf"""
LOG,00000,"pg_hba.conf was not reloaded",,,,,,,,"SIGHUP_handler,
postmaster.c:2642","" \

Thanks & Regards,
Rajamohan.J
Mobile : +91 8098167651, +91 7259157485
Email:garajamohan(at)gmail(dot)com

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raj kumar 2021-02-05 06:08:50 Re: SELECT pg_reload_conf(); returning true despite hba file loading was failed
Previous Message Ganesh Korde 2021-02-05 05:09:31 Re: Installation Issue