I need to upgrade from postgis 1.5 to postgis 2.0 but i cant backup my data and restore it can someone give me a link where it is clear enough for doing this?
2
-
postgis.org/docs/postgis_installation.html#hard_upgrade– MapperzCommented May 5, 2014 at 16:21
-
Can you save the data to a spatialite database? If it is only openstreetmap data (guessing from your tagging) a full import after upgrading would be easier.– Andre JoostCommented May 5, 2014 at 16:42
Add a comment
|
1 Answer
If you can't follow the correct procedures suggested by Mapperz and Andre Joost, I'd advise you to do an extraction through tools such as or "Qgis" (ogr) in shp format, and then perform a batch import in a fresh postgis 2.0 installation with shp2pgsql-gui.
You just have to make sure that during the export value of the attributes (columns) of the various spatial layers may be slightly different because of shape format specification.
The length of the porting procedure depends strictly on the amount of data.
