Database Restore Fail - No liblwgeom.so

Поиск
Список
Период
Сортировка
От Rebecca Clarke
Тема Database Restore Fail - No liblwgeom.so
Дата
Msg-id CANY3h+TFkmmbh7EFfWwz+fQQ5gLTKtxDgeZVn2VLFpjdtG+psQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Database Restore Fail - No liblwgeom.so  (Jeff Davis <pgsql@j-davis.com>)
Список pgsql-general
Hi there

I'm transferring a database from 8.2 to 8.4 and I have some triggers that reference liblwgeom.so within the database.

When I restore a dump of the 8.2 database into my 8.4 database it says that liblwgeom.so does not exist. From various forums on the internet I have discovered that this has been replaced with the file postgis-1.5.so. Does anyone have any recommendations on how I should proceed? I am really aiming for the pg_restore to restore everything to the same state as the 8.2 database but seeing these trigger creations are erroring during the restoration they are not being generated and I want to avoid having to go in after the restore and generate them myself.

Many thanks in advance.

Rebecca

В списке pgsql-general по дате отправления:

Предыдущее
От: dennis jenkins
Дата:
Сообщение: Re: Detecting memory leaks with libpq?
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: Detecting memory leaks with libpq?