Re: Error: The database does not exist on the server

A couple things need to be done. On the server, PostgreSQL needs to be
started with the -i option (or set enable_tcpip to true in
/var/lib/pgsql/data/postgresql..conf).

/var/lib/pgsql/data/pg_hba.conf needs to be edited to allow certain IP
addresses (the client machines).

See the Adminstratior Guide for more information.

Jeff
On Friday, September 12, 2003, at 09:50 AM, 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.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org