Opened 13 years ago

Closed 13 years ago

#1360 closed task (fixed)

Update new_postgis_restore.pl

Reported by: strk Owned by: strk
Priority: high Milestone: PostGIS 2.0.0
Component: postgis Version: master
Keywords: Cc:

Description

There seem to be lot of items to add to new_postgis_restore.pl.

I just tried dumping & restoring my development database coming from far away and got a lot of ERROR lines during restore.

Many were of the "function already exists" and "type already exists" type. Many were of the "enforce_srid_geom fails" type (we probably need to go back to -1 for unknown).

There was also full of other scary error messages but I think that's a separate topic.

Change History (3)

comment:1 by strk, 13 years ago

Owner: changed from pramsey to strk
Status: newassigned

I'm taking care of this by iteratively running a restore and updating the missing bits. This is happening from 8.4 to 8.4

comment:2 by strk, 13 years ago

The cleanup should probably also include raster and topology

comment:3 by strk, 13 years ago

Resolution: fixed
Status: assignedclosed

With r8361 this script is pretty complete. There are still problems with user views making use of obsoleted functions. The only way to fix those would be to have a script to prepare a database prior to upgrade, making sure to drop dependency on deprecated function before dumping. Such step would also need to clean up the unknown SRID usage and constraints.

Worth a separate ticket.

Note: See TracTickets for help on using tickets.