PostGIS Back-up and restore
Posted on 04 October 2011
Ever wondered on what is the most appropriate way of backing up and restoring your precious PostGIS database? Or have you experienced errors when restoring your old database backup file?
The solution is, put simple: Do not store your data in the public schema in PostGreSQL!
Paul Ramsey explains more in detail on his blog:
http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html