Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 5106A4764BE for ; Mon, 16 Sep 2002 11:12:24 -0400 (EDT) Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178]) by postgresql.org (Postfix) with ESMTP id B5CAD47648C for ; Mon, 16 Sep 2002 11:12:23 -0400 (EDT) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 1217DD600; Mon, 16 Sep 2002 08:12:25 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 03B535C02; Mon, 16 Sep 2002 08:12:24 -0700 (PDT) Date: Mon, 16 Sep 2002 08:12:24 -0700 (PDT) From: Stephan Szabo To: Prasanna Cc: Subject: Re: [BUGS] Problem In-Reply-To: Message-ID: <20020916080931.Q89488-100000@megazone23.bigpanda.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=X-UNKNOWN Content-Transfer-Encoding: QUOTED-PRINTABLE X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/183 X-Sequence-Number: 5722 -bugs is the wrong place, redirected to -admin. On Wed, 11 Sep 2002, Prasanna wrote: > I=92m a standalone user of Linux 7.3. I=92m facing problem to start sql > command > Interpreter i.e. psql. See I=92ve 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 =96D dbms > so it gets started. Now if I gave command like psql =96D dbms > Then it gives error like > > Fatal 1: database name =91dbms=92 is not present in the system catalog. > > Now what should I do? This fatal error appears on the postmaster server. > I=92ve tried two nights for this psql but not getting success. May be I= =92m > 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).