Re: Error with libdir - PostgreSQL 9.2

On 15 February 2016 at 09:24, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
wrote:

> Just to help you a little bit:
>
> #select version ();
>
>> PostgreSQL 9.2.15 on x86_64-unknown-linux-gnu, compiled by gcc (GCC)
>> 4.4.7 20120313 (Red Hat 4.4.7-16), 64-bit
>
>
>
> On 15 February 2016 at 09:21, drum(dot)lucas(at)gmail(dot)com <drum(dot)lucas(at)gmail(dot)com>
> wrote:
>
>> Hi all...
>>
>> 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
>>
>>
>> Does anyone know how to solve the problem? Maybe a ls -ln? but if so, to
>> where?
>>
>>
>> Cheers
>>
>> Lucas
>>
>
>

Hi all

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";