Re: BUG #5668: initdb failed to create postgres database

On Tue, Sep 21, 2010 at 06:07, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "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. =A0pg_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. =A0I don't have pgAdmin handy to try, but if you
> are using a pre-9.0 version then you should definitely update it.

Correct, you need pgadmin 1.12 for it to work with PostgreSQL 9.0.

--=20
=A0Magnus Hagander
=A0Me: http://www.hagander.net/
=A0Work: http://www.redpill-linpro.com/