Thanks all for the reply. Once pg_hba.conf is modified, do I have to run pg_ctl reload ?
James louis gonzales wrote: > James, > the "psql" command as you know is just the command line program that > requests connection to a database and depending how you issue the > command, determines if it's attempting to connect to a local file, or > via a network protocol (commonly TCP/IP). When you issue the command > from a remote host, relative to where the database is located, once the > database server receives the connection request, that request is looked > up in the pg_hba.conf file to validate the user attempting the request. > > If the user meets the constraints imposed within, the user is granted > access to the database, otherwise, "try again." > > If you launch the psql command directly on the server to connect locally > to the database, in this scenario, the server is 'the client' and > therefore would be looking up pg_hba.conf on 'the client' but this case > is no different from the remote client to the server, in that there are > still both roles being fulfilled and ultimately 'the server' is looking > up the request in the pg_hba.conf. > > Hope this helps. > > Martijn van Oosterhout wrote: > > >On Mon, Jun 26, 2006 at 01:51:24PM -0700, James wrote: > > > > > >>In this command > >>psql -h host ... > >> > >>does it look for pg_hba.conf in the client or in the server? > >> > >> > > > >The server. Client machines do not necessarily have a pg_hba.conf and > >even if they do, clients are unlikely to be able to read it. > > > >Have a nice day, > > > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 3: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
