Обсуждение: BUG #5668: initdb failed to create postgres database

The following bug has been logged online:

Bug reference:      5668
Logged by:          Dan Posey
Email address:      dan.posey@gmail.com
PostgreSQL version: 9.0
Operating system:   Ubuntu 10.04 LTS Server
Description:        initdb failed to create postgres database
Details:

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..........

"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

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/

Got the pgAdminIII .12. Connects fine.

Thanks.

On Mon, Sep 20, 2010 at 9:07 PM, 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.  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
>