[postgis-users] incorrect restore from pg_dumpall

[Tomas Lanczos]

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: 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
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>