Postgres Pro
Downloads
Home   >   mailing lists

Thread: Error with libdir - PostgreSQL 9.2

Error with libdir - PostgreSQL 9.2

From
"drum.lucas@gmail.com"
Date:
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

Re: Error with libdir - PostgreSQL 9.2

From
"drum.lucas@gmail.com"
Date:
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



Lucas Possamai


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


Re: Error with libdir - PostgreSQL 9.2

From
"drum.lucas@gmail.com"
Date:


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

Re: Error with libdir - PostgreSQL 9.2

From
Albe Laurenz
Date:
drum.lucas@gmail.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