| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "'drum(dot)lucas(at)gmail(dot)com *EXTERN*'" <drum(dot)lucas(at)gmail(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Error with libdir - PostgreSQL 9.2 |
| Date: | 2016-02-15 10:41:36 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B537F96B2@ntex2010i.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
drum(dot)lucas(at)gmail(dot)com 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2016-02-15 21:20:05 | Re: Could not open file pg_clog , Please help! |
| Previous Message | drum.lucas@gmail.com | 2016-02-14 21:23:17 | Re: Error with libdir - PostgreSQL 9.2 |