I was trying to create some monitoring tool for new postgresql 9.0 in a project on RHEL. Spent couple of hours tweaking hba file with no effect! Quite disturbing! Then I found the file was somewhere else due to difference between the 9.0 rpm and the original RH one! Here is the command to find it. Quite useful:
postgres=# show hba_file;
hba_file
-------------------------------------
/var/lib/pgsql/9.0/data/pg_hba.conf
(1 row)
I found it in this blog, quite other nice things in it.
No comments:
Post a Comment