[postgis-users] Correct dump and restore

Frank Koormann frank.koormann at intevation.de
Fri Nov 10 07:04:11 PST 2006

* Stefan Schwarzer <stefan.schwarzer at grid.unep.ch> [061110 15:55]:
> Under "Hard upgrade" I don't find anything. I guess you mean this  
> section (page 5)? Seems still rather complicated....

I think strk was talking about the online Doku:

Essentially it is 

$ pg_dump -Fc olddb olddb.dump


$ sh utils/postgis_restore.pl lwpostgis.sql newdb olddb.dump > restore.log

The rest are checks and cleanups if migration from older postgresql
versions -  which isn't the case in your situation.



Frank Koormann                             <frank.koormann at intevation.de>
 Professional Service around Free Software       (http://intevation.net/)
 FreeGIS Project                                 (http://freegis.org/)
 PostGIS Support     (http://intevation.de/services/gis/postgis.en.html)

More information about the postgis-users mailing list