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

Поиск
Список
Период
Сортировка
От RAJAMOHAN
Тема SELECT pg_reload_conf(); returning true despite hba file loading was failed
Дата
Msg-id CAFzdntvG95eRKf0NByK4edmG8AWwLvn2-AE5R8UZiwQu=YCRqw@mail.gmail.com
обсуждение исходный текст
Ответы Re: SELECT pg_reload_conf(); returning true despite hba file loading was failed  (Raj kumar <rajkumar820999@gmail.com>)
Re: SELECT pg_reload_conf(); returning true despite hba file loading was failed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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

В списке pgsql-admin по дате отправления:

Предыдущее
От: Ganesh Korde
Дата:
Сообщение: Re: Installation Issue
Следующее
От: Raj kumar
Дата:
Сообщение: Re: SELECT pg_reload_conf(); returning true despite hba file loading was failed