1

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?

migrated from gis.stackexchange.com May 5 '14 at 17:56

This question came from our site for cartographers, geographers and GIS professionals.

  • 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 Joost May 5 '14 at 16:42
0

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy