Re: Error: The database does not exist on the server - Mailing list pgsql-novice

From Oliver Elphick
Subject Re: Error: The database does not exist on the server
Date
Msg-id 1063580860.18281.1691.camel@linda.lfix.co.uk
Whole thread Raw
In response to Error: The database does not exist on the server  (Steve Bond <bondy@skysurf-airdsl.co.uk>)
List pgsql-novice
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


pgsql-novice by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Re: Error: The database does not exist on the server
Next
From: santoso berkah
Date:
Subject: How to access service using LAN