From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: Prasanna <prasannaphatak@vsnl.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: [BUGS] Problem
Date: Mon, 16 Sep 2002 08:12:24 -0700 (PDT)
Message-ID: <20020916080931.Q89488-100000@megazone23.bigpanda.com> (raw)
In-Reply-To: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA9keTXWlBwhG+JcI+MQUzg8KAAAAQAAAAwElniGNZwhG+JcI+MQUzgwEAAAAA@vsnl.net>
-bugs is the wrong place, redirected to -admin.
On Wed, 11 Sep 2002, Prasanna wrote:
> Im a standalone user of Linux 7.3. Im facing problem to start sql
> command
> Interpreter i.e. psql. See Ive 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.
> Ive tried two nights for this psql but not getting success. May be Im
> 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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: sszabo@megazone23.bigpanda.com, prasannaphatak@vsnl.net
Subject: Re: [BUGS] Problem
In-Reply-To: <20020916080931.Q89488-100000@megazone23.bigpanda.com>
References: <!~!UENERkVCMDkAAQACAAAAAAAAAAAAAAAAABgAAAAAAAAA9keTXWlBwhG+JcI+MQUzg8KAAAAQAAAAwElniGNZwhG+JcI+MQUzgwEAAAAA@vsnl.net> <20020916080931.Q89488-100000@megazone23.bigpanda.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox