Re: BUG #5668: initdb failed to create postgres database - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5668: initdb failed to create postgres database
Date
Msg-id 22950.1285042039@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5668: initdb failed to create postgres database  ("Dan Posey" <dan.posey@gmail.com>)
Responses Re: BUG #5668: initdb failed to create postgres database  (Magnus Hagander <magnus@hagander.net>)
Re: BUG #5668: initdb failed to create postgres database  (Dan Posey <dan.posey@gmail.com>)
List pgsql-bugs
"Dan Posey" <dan.posey@gmail.com> writes:
> initdb did create the directory structure and and files but there is no
> postgres database.

> Can login using psql but no postgres database. Same after creating
> connection with pgAdmin.

> Error: column "datconfig" does not exist..........

That error suggests that you're using some client-side tool that hasn't
been updated for 9.0 yet.  pg_database.datconfig is no more.

In a quick test here, 8.4 psql is able to connect to a 9.0 database.
I don't see an error from \l, although it's entirely possible that
some other backslash commands might fall over as a result of expecting
datconfig to be there.  I don't have pgAdmin handy to try, but if you
are using a pre-9.0 version then you should definitely update it.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Mark Kirkwood
Date:
Subject: Re: BUG #5665: VPATH catalog/schemapg.h
Next
From: Craig Ringer
Date:
Subject: Re: BUG #5667: install failure