From: | Charles Tassell <ctassell(at)isn(dot)net> |
---|---|
To: | kurt_miller(at)sfgh(dot)org, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Interface Question |
Date: | 2000-06-29 01:44:37 |
Message-ID: | 4.3.2.7.2.20000628223928.00b38ef0@mailer.isn.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-06-29 01:52:12 | Re: pg_atoi() |
Previous Message | Tom Lane | 2000-06-29 01:44:30 | Re: Re[2]: Restricting queries by the presence of a WHERE clause |