Re[2]: Interface Question

More specifically:

Can this be done without having Postgres installed on the client?
Can one install only the client?

Thanks,
-km



______________________________ Reply Separator _________________________________
Subject: Re: [GENERAL] Interface Question
Author:  Charles Tassell <ctassell@isn.net> at ccmgate
Date:    6/28/2000 10:44 PM


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:
>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
>