Re: [GENERAL] psql -h host ...

2006-06-29 Thread Chris
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

Re: [GENERAL] psql -h host ...

2006-06-28 Thread James
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 at

Re: [GENERAL] psql -h host ...

2006-06-27 Thread louis gonzales
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 remot

Re: [GENERAL] psql -h host ...

2006-06-27 Thread Martijn van Oosterhout
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 n

[GENERAL] psql -h host ...

2006-06-27 Thread James
In this command psql -h host ... does it look for pg_hba.conf in the client or in the server? James ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings