Thread: system catalog

system catalog

From
Jean-Michel Zigna
Date:
Hello,

I'm tying to connect to an 7.3.4 postgres instance on a redhat 7.3 server
after the creation and start of the database server using the port 5433
(5432 is used by postgres 7.1).

The command is : psql test -p 5433 (where test is the name of the database
I have created)

The following error message  appears :

psql : FATAL : Database "test" does not exist in the system catalog.

Something is probably missing in my installation but I didn't find my
message in the documentation.

Thank you for your Help.

Regards.

Zigna Jean-Michel.


Re: system catalog

From
Kris Jurka
Date:

On Wed, 5 Nov 2003, Jean-Michel Zigna wrote:

> Hello,
>
> I'm tying to connect to an 7.3.4 postgres instance on a redhat 7.3 server
> after the creation and start of the database server using the port 5433
> (5432 is used by postgres 7.1).
>
> The command is : psql test -p 5433 (where test is the name of the database
> I have created)
>
> The following error message  appears :
>
> psql : FATAL : Database "test" does not exist in the system catalog.
>

This is not a JDBC question and isn't really appropriate for this list,
but the obvious question is: did you create a database named "test" on the
7.3 server?  Try connecting to template1 and listing the databases (\l).

Kris Jurka