From: "Sumita Biswas" <sbiswas@cisco.com>
To: "'Tom Lane'" <tgl@sss.pgh.pa.us>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: Postgres DB
Date: Mon, 23 Feb 2004 08:24:17 +0530
Message-ID: <001101c3f9b8$54403aa0$2a154d0a@apac.cisco.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: 7bit
In-reply-to: <11975.1077379855@sss.pgh.pa.us>
Importance: Normal

Hi Tom,

I have read that template1 is the default DB that gets installed with
Postgres.
But when I type the command "psql" and don't specify a DB name, it says
that:

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

This is the reason why I guessed that it expects the postgres DB be
installed by default.
Also earlier I have seen this DB get installed by itself, although we
have not created it.

Any answers to the above questions.

Regards,
Sumita

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us] 
Sent: Saturday, February 21, 2004 9:41 PM
To: Sumita Biswas
Cc: pgsql-sql@postgresql.org
Subject: Re: [SQL] Function 


"Sumita Biswas" <sbiswas@cisco.com> writes:
> We installed postgres, but it did not install the default DB 
> "postgres".

The only DB that exists in a fresh installation is "template1".  If you
want to create a DB named "postgres", use the createdb script.

BTW, it's bad manners to ask a new question by following up an existing
unrelated thread.  Start a new thread with an appropriate subject line.
Otherwise you're wasting the time of the other people on the mailing
list, who are exactly the people who might answer your question.

			regards, tom lane