Skip site navigation (1) Skip section navigation (2)

Re: Postgres DB

From: "Sumita Biswas" <sbiswas(at)cisco(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: Postgres DB
Date: 2004-02-23 02:54:17
Message-ID: 001101c3f9b8$54403aa0$ (view raw, whole thread or download thread mbox)
Lists: pgsql-sql
Hi Tom,

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

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.


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

"Sumita Biswas" <sbiswas(at)cisco(dot)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

In response to


pgsql-sql by date

Next:From: Tom LaneDate: 2004-02-23 03:29:08
Subject: Re: Postgres DB
Previous:From: Greg PatnudeDate: 2004-02-23 00:45:51
Subject: Re: User defined types -- Social Security number...

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group