pgadmin - an error has occurred, column "datconfig" does not exist

Question

I've a ubuntu server 12.04 running postgresql version 9.1.10, and I've downloaded pgAdmin III 1.8.4 for windows (7, x64).

When I try to estabish a connection I'm getting this message:

an error has occurred: ERROR: column "datconfig" does not exist LINE1: ...b.dattablespace AS spccoid, spcname, datallowconn, datconfig, ..."

I've googled this and I've only found "upgrade your pgadmin version", but since I'm running the last one...

I appreciate If you could give any assistance.

Solution

The current version of pgAdmin is 1.18.1. pgAdmin 1.8.4 is very old (released 2007). Hardly works with Postgres 9.1.

Install the current version and try again:
http://pgadmin.org/download/

Comments

[Craig Ringer]

datconfig, maybe? If it really says dataconfig in the error message, then there's a typo in the PgAdmin-III codebase.

[Leo]

datconfig, thanks, edit.

[Leo]

the typo was made by me haha

[Craig Ringer]

It looks like datconfig was removed in PostgreSQL 9.0. Verify you're actually running the version of PgAdmin-III you think you are.

[Leo]

the splash screen and the "about" window shows an elephant that says I'm running version 1.8.4 (jun 4 2008, rev 7358)

[Craig Ringer]

Might be worth asking on the pgadmin-support mailing list then.

[Leo]

I've tried that, I believe, before posting here and it failed: This is an automatically generated Delivery Status Notification. Delivery to the following recipients failed. [email protected]

[Craig Ringer]

Er... that's not pgadmin-support.pgadmin.org/support

[Leo]

of course... 18>8... I've missed that. I've just downloaded the last listed one, and because the list is alphabetically ordered, the 1.8 is the last one. I had found strange that the last one was from 2008. Thank you very much!

[Erwin Brandstetter]

Sort order isn't always that trivial ... :)