[postgis-users] restore problems with postgis 0.9

[Thomas Zuberbuehler]

Dear Postgis-Friends

I have a problem with postgis 0.9 to restore my dump file. I think the 
problem would be between the different version I used, but I need your 
advice and hope you can help me.

First I made a test between my two computers and this would work very 
well. I installed postgres with postgis on tswo different windows 
computer. Both of them have the same win32 postgres 8.1 (postgis 1.0.4). 
So I created on one of them a dump file with following call:

pg_dump -U posgres -v "GeonamenDB" > geonamendb.out

This command worked fine and without problem. Also without problem I 
could restore this dump file on my second computer with following command:

psql -U geometa -d "GeonamenDB" -f geonamendb.out

Before - of course - I created my database with:

CREATE DATABASE "GeonamenDB" WITH OWNER = geometa TEMPLATE = template0 
ENCODING = 'utf8' TABLESPACE = pg_default;

To create a new database and to restore the dump file worked without any 
problem!

*Problem*: Now I want to restore my database on linux (feudora) with 
postgres 8.0.0rc3, postgis 0.9.1 geos 2.1.1 and proj 4.4.9. I used the 
*same* dump file, the *same* commands and this would not work! I tried 
it also with pg_restore without any success. I hope you can help me?

So I redirect the stderr (from restore command) to a file. You can see 
this file here: http://www.zubi.li/restore.log. The first 200 lines of 
the dump file you can get here: http://www.zubi.li/geonamendb.out.

I think this error can be the key for my problem?

psql:geonamendb.out:48: ERROR:  could not access file 
"$libdir/liblwgeom.dll": No such file or directory

Can you give me some tips or ideas? How I can restore my dump file? If 
you need more information please ask me. Thanks a lot for your help!

Greetings from Switzerland, Zürich
Thomas Zuberbühler

-- 
Thomas Zuberbühler
http://www.zubi.li

______________________________________________________________________
 >> GPS Access for Java, http://www.gafj.net, http://gafj.tigris.org <<