Database Restore Fail - No liblwgeom.so - Mailing list pgsql-general

From Rebecca Clarke
Subject Database Restore Fail - No liblwgeom.so
Date
Msg-id CANY3h+TFkmmbh7EFfWwz+fQQ5gLTKtxDgeZVn2VLFpjdtG+psQ@mail.gmail.com
Whole thread Raw
Responses Re: Database Restore Fail - No liblwgeom.so
List 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 by date:

Previous
From: dennis jenkins
Date:
Subject: Re: Detecting memory leaks with libpq?
Next
From: Craig Ringer
Date:
Subject: Re: Detecting memory leaks with libpq?