Postgres create a database; column 'dataconfig' does not exist

Question

I just installed PgAdmin 8.4 on an OSX Lion 10.7.3 PC with Postgres 9.1 installed. When I try to add a database, I get the error message: "Error: the column" dataconfig "does not exist. Does this mean a mismatch between the client and server versions? I could not find a later version of PgAdmin.

Answer 1

If you mean the version of pgAdmin associated with some versions of postgresql 8.4, then this version is old. It checks system directories to determine the structure of the database, but does not support system catalog version 9.1. If you used a one-click installer, you can use the associated pgadmin. You can find it in applications / PostgreSQL 9.1 / pgAdmin III.app

Otherwise, download the latest version here.

Answer 2

Try pgadmin3-1.16.1 - it works. I tried with many other versions (e.g. pgadmin3-1.8.3 and pgadmin3-1.16.0), but to no avail.