Interface Question
How would I connect a Unix client (perl,psql,etc.) on one machine to a Unix
postgres backend on another machine?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
All of the different interfaces have there own way of specifying the host
to connect to (eg, with pgsql it's "pgsql -h hostname databasename") You
also have to setup the pg_hba.conf file in your PGDATA directory
(/usr/local/pgsql/data on my machine) to allow access from the remote
machine. Usually adding this line will do the trick:
host all REMOTE.IP.ADDR.ESS 255.255.255.255
crypt
You will have to specify a username/password to connect from that machine,
however (use the -u option of pgsql, ie: pgsql -u -h remote.ip.addr.ess
dbname.) If you don't care quite so much about security, you can use
"trust" or "ident" instead of crypt. The pg_hba.conf man page and the file
itself provides good documentation.
At 03:18 PM 6/28/00, kurt miller wrote:
Show quoted text
How would I connect a Unix client (perl,psql,etc.) on one machine to a
Unix postgres backend on another machine?
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com