James wrote:
> Thanks all for the reply.
> Once pg_hba.conf is modified, do I have to run
> pg_ctl reload ?
If in doubt check the documentation :)
http://www.postgresql.org/docs/8.1/static/client-authentication.html#AUTH-PG-HBA-CONF
"The pg_hba.conf file is read on start-up and when the main server
process (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."
So yes.
--
Postgresql & php tutorials
http://www.designmagick.com/