[postgis-users] Restoring a dump

[Jayson Gallardo]

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 <strk at keybit.net> 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
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140519/249343b0/attachment.html>