-bugs is the wrong place, redirected to -admin.
On Wed, 11 Sep 2002, Prasanna wrote:
> I�m a standalone user of Linux 7.3. I�m facing problem to start sql
> command
> Interpreter i.e. psql. See I�ve first of all created a database using
> initdb dbms
> Command it gets created. And it also creates directory dbms which
> contains
> Many files and directories. That directory is /home/Prasanna/dbms.
> Now I want to start the server so I can start it by giving command
> /usr/bin/postmaster �D dbms
> so it gets started. Now if I gave command like psql �D dbms
> Then it gives error like
>
> Fatal 1: database name �dbms� is not present in the system catalog.
>
> Now what should I do? This fatal error appears on the postmaster server.
> I�ve tried two nights for this psql but not getting success. May be I�m
> wrong.
> Will you please tell me how to start the psql with my database created
> by
> Initdb. It will be very helpful to me.
The location of the data directory is not a database name, databases are
stored inside that location. Try psql template1 or make a database
with createdb and connect to that (template1 is one of the template
databases for new databases so stuff you do there can pollute other
databases you create).