Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

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.

like image 630
Leo Avatar asked Dec 11 '13 03:12

Leo


1 Answers

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/

like image 162
Erwin Brandstetter Avatar answered Oct 21 '22 01:10

Erwin Brandstetter