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> (raw)
In-Reply-To: <11975.1077379855@sss.pgh.pa.us>
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
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sbiswas@cisco.com, tgl@sss.pgh.pa.us
Subject: Re: Postgres DB
In-Reply-To: <001101c3f9b8$54403aa0$2a154d0a@apac.cisco.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