Re: Error with libdir - PostgreSQL 9.2

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

In response to

Browse pgsql-admin by date

  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