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?

  • 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, 2014 at 16:42

1 Answer 1


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 and acknowledge you have read our privacy policy.