Re: Error with libdir - PostgreSQL 9.2

Поиск
Список
Период
Сортировка
От drum.lucas@gmail.com
Тема Re: Error with libdir - PostgreSQL 9.2
Дата
Msg-id CAE_gQfUsaa+wOsX62wBSwb+SiFC7gsvdAZFpoDWAuvHm2-QcpQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Error with libdir - PostgreSQL 9.2  ("drum.lucas@gmail.com" <drum.lucas@gmail.com>)
Ответы Re: Error with libdir - PostgreSQL 9.2
Список 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 по дате отправления:

Предыдущее
От: "drum.lucas@gmail.com"
Дата:
Сообщение: Re: Error with libdir - PostgreSQL 9.2
Следующее
От: Albe Laurenz
Дата:
Сообщение: Re: Error with libdir - PostgreSQL 9.2