RE : pg_hba.conf

Ganesan Kanavathy a écrit :

>If I do any changes in pg_hba.conf file do I need restart pgsql.
>The changes I made does not taking effect.

Hello,

The PostgreSQL documentation indicates that the pg_hba.conf file is read
on start-up and when the postmaster receives a SIGHUP signal. If you
edit the file on an active system, you will need to signal the
postmaster (using pg_ctl reload or kill -HUP) to make it re-read the
file.

You can have more infos about the pg_hba.conf file in the following URL
:
http://www.postgresql.org/docs/7.3/static/client-authentication.html#AUT
H-PG-HBA-CONF

Hope this helps :-)

Regards,

---------------------------------------
Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net