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:[EMAIL PROTECTED] Sent: Saturday, February 21, 2004 9:41 PM To: Sumita Biswas Cc: [EMAIL PROTECTED] Subject: Re: [SQL] Function "Sumita Biswas" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
