Re: Error with libdir - PostgreSQL 9.2

["drum.lucas@xxxxxxxxx" <drum.lucas@xxxxxxxxx>]

On 15 February 2016 at 09:24, drum.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> 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.lucas@xxxxxxxxx <drum.lucas@xxxxxxxxx> 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";