Tomas, The name of the library file changed between postgis 1.3 and postgis 1.4. With that said, I suspect
You just have the new 1.4 installed on your box and not the 1.3 2 choices (well actually I see 3 but the third option is not desirable since it requires upgrading your old box) I see A)1) Create new databases with same name you are trying to restore and install PostGIS 1.4 in them 2) Restore your dump backup on top of that (hopefully your dump will not try to drop databases first - if it does you might need to manually remove those commands in it) B) 1) Install PostGIS 1.3 on your new box 2) Reload the backup 3) Upgrade each db after that using the included PostGIS 1.4 upgrade script Now why your other tables are failing I don't know. If you have referential integrity constraints in place I suppose that could cause the problem. Leo -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Tomas Lanczos Sent: Friday, November 27, 2009 7:27 PM To: [email protected] Subject: [postgis-users] incorrect restore from pg_dumpall Hello, I am trying to restore my databases stored by a pg_dumpall command in the Karmic Koala box. The restore command is the following: psql -f /media/disk/.../backup -U postgres I have a PostsgreSQL 8.4 installed from repositories and postgis1.4.1 compiled from source code. I recognized that the tables with spatial geometries were not restored but at the moment I am almost sure that it's caused by that the older version of postgis in the stored database. What is a kind of mystery for me that data in several tables were not restored, although the table definitions did (it means that I got several tables without data) althoug the data are there in the backup file (I checked physically). I really don't understand what's going on there, I did the same many times before, without any problem. So, my question is how to override the problem with restoring the spatial geometry tables and also the empty table problem (I know that this is a bit off-topic on this list, but if somebody had the same experience ...) Tomas p.s.: sorry for the eventual crossposting _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
