On Fri, 2003-09-12 at 15:50, Steve Bond wrote:
> I'm running postgresql on a linux box and having trouble connecting to my
> database from another machine. When I do
>
> >psql -l
>
> I get a list of 4 databases but I cannot connect to any of them remotely,
> as they cannot be found. I'm using
>
> /var/lib/pgsql/data/
>
> as my data directory. Am I using the wrong directory or is there a way to
> specify which directory for the client machine to look in?
> Thanks in advance.
You cannot connect from another machine unless you tell the postmaster
on the server to allow it. The postmaster must be started with the -i
option or else you must have `tcpip_socket = true' in postgresql.conf
(in the database directory). You must also configure pg_hba.conf to
allow host connections from the remote machine.
The remote client does not need to know anything about where the
database is stored on the server.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"The fool hath said in his heart, There is no God..."
Psalm 14:1