Friday, 20 May 2011

Postgresql 9.0 and ident

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