Many thanks Leo, You were right, the databases are successfully reloaded! Many thanks for Your help, moreover the also the mentioned tables were succesfully reloaded. This is however a kind of mystery for me, those tables did not contain any spatial data.
All You postgis people have a nice time! Tomas On Fri, 2009-11-27 at 23:44 -0500, Paragon Corporation wrote: > 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 > _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
