[postgis-users] Database restore fails with missing liblwgeom

[Lee Hughes]

The databases were created by restoring the pg_dumpall backup, so I  
installed Postgis (psql -d [yourdatabase] -f postgis.sql) in all of  
them and tried the restore again, with the same errors. In addition to  
the liblwgeom errors (below), which presumably I can ignore, the  
restore also errors with "type geometry does not exist". Can I ignore  
those errors too?

Thanks for the help.

> Date: Tue, 19 Oct 2010 20:17:25 -0400
> From: "Paragon Corporation" <lr at pcorp.us>
> Subject: Re: [postgis-users] Database restore fails with missing
> 	liblwgeom
> To: "'PostGIS Users Discussion'"
> 	<postgis-users at postgis.refractions.net>
> Message-ID: <61923D39EDD5403CB5F5C31ABAB20DE6 at J>
> Content-Type: text/plain;	charset="us-ascii"
>
> Lee,
>
> The liblwgeom.so was renamed in postgis 1.4 to postgis-1.4... So,
> postgis-1.5... So
>
> The easiest way to restore your data is to
>
> 1) Create a new database
> 2) install PostGIS 1.5  (the install files should bie in
> share/contrib/postgis-1.5
> 3) Then restore your data on top
> 4) You'll should then get errors that the functions already exist and they
> will be skipped.  You may get some errors too about the liblwgeom, but those
> you can ignore (unless you are using them)
>  since they represent functions long ago deprecated that got taken out of
> postgis-1.5
>
> Leo
> http://www.postgis.us
>
>
>
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net
> [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Lee
> Hughes
> Sent: Tuesday, October 19, 2010 7:15 PM
> To: postgis-users at postgis.refractions.net
> Subject: [postgis-users] Database restore fails with missing liblwgeom
>
> Restoring a pg_dumpall backup from a Postgres 8.1.3 + Postgis 1.1.4 server
> on a Postgres 9 + Postgis 1.5.2 server fails with
>
> could not access file "$libdir/liblwgeom.so.1.1": No such file or directory
>
> Postgis compiled/installed fine, and make check passed all tests.
> There are no files like liblwgeom.so anywhere on the server, just
> liblwgeom.a and liblwgeom.h in /usr/local/src/postgis-1.5.2/liblwgeom/.
>
> Any ideas greatly appreciated.
>
> Thanks-
>
> Lee