drum.lucas@xxxxxxxxx wrote: > I'm using PostgreSQL 9.2 version and, doing a pg_dump command, I got the following error: > ERROR: could not access file "$libdir/postgis-2.0": No such file or directory > > # Running pg_config --libdir > /usr/pgsql-9.2/lib > So.. it seems that in /usr/pgsql-9.2/lib I got: > postgis-2.1.so > > How can I update the postgresql to look for 2.1 and not 2.0? > #select * from pg_available_extensions; > postgis | 2.1.8 | 2.0.3 > > Should be like this? > ALTER EXTENSION postgis UPDATE TO "2.1.8"; Yes, or just "ALTER EXTENSION postgis UPDATE". Yours, Laurenz Albe -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin