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. 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/
Got the pgAdminIII .12. Connects fine.
Thanks.
On Mon, Sep 20, 2010 at 9:07 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
Show quoted text
"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