Re: Error with libdir - PostgreSQL 9.2 - Mailing list pgsql-admin

From drum.lucas@gmail.com
Subject Re: Error with libdir - PostgreSQL 9.2
Date
Msg-id CAE_gQfUsaa+wOsX62wBSwb+SiFC7gsvdAZFpoDWAuvHm2-QcpQ@mail.gmail.com
Whole thread Raw
In response to Re: Error with libdir - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Responses Re: Error with libdir - PostgreSQL 9.2
List pgsql-admin


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

pgsql-admin by date:

Previous
From: "drum.lucas@gmail.com"
Date:
Subject: Re: Error with libdir - PostgreSQL 9.2
Next
From: Albe Laurenz
Date:
Subject: Re: Error with libdir - PostgreSQL 9.2