Here's the thing, all I have is a dump (postgres_dump_03172014.gz) using pg_dumpall. The server has been reformatted with a clean install of Debian. I haven't even installed Postgres yet. So, what are my options then? I really would hate to start from scratch.
On Mon, May 19, 2014 at 10:15 AM, Sandro Santilli <[email protected]> wrote: > 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 >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
