Problem

Started by Ramalmost 24 years ago2 messagesbugs

ram@anantinfotech.com

almost 24 years ago

Sir,
I dont know whether this is a right place to ask this question,but I
hope you guys will still help me out.
I'm in a serious problem,we are using Postgres having 2-3
databases,today when i started the server I couldnot find a single
database,also it is not allowing me to create a new one.Its showing the
following error
# createdb test;
psql: FATAL 1: Database "template1" does not exist in the system
catalog.
createdb: database creation failed

What could be the reason ?
Please help me out.
Thanx in Advance.

Ram

Tom Lane

tgl@sss.pgh.pa.us

almost 24 years ago

In reply to: Ram (#1)

Re: Problem

Ram <ram@anantinfotech.com> writes:

# createdb test;
psql: FATAL 1: Database "template1" does not exist in the system
catalog.

What PG version is this? Can you get into any of your other databases?
If so, what do you get from "SELECT * FROM pg_database"?

regards, tom lane