Re: trouble with an older version of postgresql - Mailing list pgsql-novice

From Joshua Tolley
Subject Re: trouble with an older version of postgresql
Date
Msg-id 4b701988.9713f30a.4a84.ffff8927@mx.google.com
Whole thread Raw
In response to Re: trouble with an older version of postgresql  (Krešimir Križanović <Kresimir.Krizanovic@fer.hr>)
List pgsql-novice
On Mon, Feb 08, 2010 at 02:26:50PM +0100, Krešimir Križanović wrote:
>     The trouble is there is no database. When i try to create the first one
>    using createdb, i get an error:
>
>    createdb: could not connect to database postgres: FATAL:  Database
>    "postgres" does not exist in the system catalog.

See if you have a file called global/pg_database in your data directory. It
should be plain text, and contain a list of all the databases that exist. One
of them is probably called "template1", and you should be able to connect to
that. Note that 7.3 is awfully old, and you're unlikly to get much support for
it beyond "Upgrade immediately if not sooner."

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com

Attachment

pgsql-novice by date:

Previous
From: Krešimir Križanović
Date:
Subject: Re: trouble with an older version of postgresql
Next
From: Tom Lane
Date:
Subject: Re: Incomplete pg_dump operation