[postgis-users] incorrect restore from pg_dumpall

[Paragon Corporation]

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: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Tomas
Lanczos
Sent: Friday, November 27, 2009 7:27 PM
To: postgis-users at postgis.refractions.net
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
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users