On Mon, May 19, 2014 at 09:39:20AM -0500, Jayson Gallardo wrote: > Hey, all. So, we recently re-did our server. We were previously running > Ubuntu, and now we are running Debian. I had performed a pg_dumpall on our > Postgres database (with PostGIS) and would now like to restore said dump. > However, I want to make sure I do it right.
Follow the instructions here: http://postgis.net/docs/manual-2.1/postgis_installation.html#hard_upgrade > Since I dumped everything, will I need to create all the databases before > restoring the dump? > > I should probably install the Postgis plug-in first, right? You should create the databases and spatially-enable them (could be a chance to switch to EXTENSION-based install). > My dump is pretty big at 101 GB (it contains 3m resolution DEMs of Iowa). > Is there anything I need to do in order to minimize errors in the restore? I guess you could reinstall each database separately, to at least be more in control of what fails ... --strk; () ASCII ribbon campaign -- Keep it simple ! /\ http://strk.keybit.net/rants/ascii_mails.txt _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
