Re: Accessing PostgreSQL from a remote host

On Sat, 2003-02-15 at 08:30, Stéphane Pinel wrote:
> As a newbie, I would like to know exactly what I have to
> do (and how) (on the server) in order to get a running connection to my
> PostgreSQL database from a remote host (using a GUI
> client).
>
> I'm going to get mad since I've tried everything I could
> read about this topic without any success for hours ;-)
>
> MacOS X 10.2.4
> PostgreSQL 7.3 (Marc Liyanage package)

You need to edit the pg_hba.conf and add a line like:

# TYPE  DB    USER    IP-ADDRESS    IP-MASK           METHOD

host    mydb  myuser  192.168.3.77  255.255.255.255   crypt

Replace the IP address you are actually connecting from in place of
192.168.3.77, and widen the netmask if you want access from a network.

The method can be "ident", "trust", "crypt" and "md5".

There is more documentation for this sort of thing here:

http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=client-authentication.html

Regards,
                    Andrew.
--
---------------------------------------------------------------------
Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St,  Wellington
WEB: http://catalyst.net.nz/         PHYS: Level 2, 150-154 Willis St
DDI: +64(4)916-7201     MOB: +64(21)635-694    OFFICE: +64(4)499-2267
           Survey for nothing with http://survey.net.nz/
---------------------------------------------------------------------