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 , 13 years ago
| Owner: | changed from to |
|---|---|
| Status: | new → assigned |
comment:3 by , 13 years ago
| Resolution: | → fixed |
|---|---|
| Status: | assigned → closed |
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.
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