Re: psql -h host ...

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/