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

On Tue, Sep 21, 2010 at 06:07, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> "Dan Posey" <dan(dot)posey(at)gmail(dot)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.

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

--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/