[postgis-users] Correct dump and restore

[Frank Koormann]

* 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:
http://postgis.refractions.net/docs/ch02.html#upgrading

Essentially it is 

$ pg_dump -Fc olddb olddb.dump

and 

$ 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.

Regards,

        Frank

-- 
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)