<html><head><style>body{font-family:Helvetica,Arial;font-size:13px}</style></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;"><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">What do you mean, starting from scratch? You have to install postgresql/postgis and then follow the answers/links from sandro. You should be good with that dump. </div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;"><br></div><div id="bloop_customfont" style="font-family:Helvetica,Arial;font-size:13px; color: rgba(0,0,0,1.0); margin: 0px; line-height: auto;">good luck!</div> <div id="bloop_sign_1400520431406853888" class="bloop_sign"><div style="font-family:helvetica,arial;font-size:13px"><br></div></div> <br><p style="color:#000;">On May 19, 2014 at 10:22:38 AM, Jayson Gallardo (<a href="mailto:jaysontrades@gmail.com">jaysontrades@gmail.com</a>) wrote:</p> <blockquote type="cite" class="clean_bq"><span><div><div></div><div>
<title></title>
<div dir="ltr">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.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, May 19, 2014 at 10:15 AM, Sandro
Santilli <span dir="ltr"><<a href="mailto:strk@keybit.net" target="_blank">strk@keybit.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="">On Mon, May 19, 2014 at 09:39:20AM -0500, Jayson
Gallardo wrote:<br>
> Hey, all. So, we recently re-did our server. We were
previously running<br>
> Ubuntu, and now we are running Debian. I had performed a
pg_dumpall on our<br>
> Postgres database (with PostGIS) and would now like to restore
said dump.<br>
> However, I want to make sure I do it right.<br>
<br></div>
Follow the instructions here:<br>
<a href="http://postgis.net/docs/manual-2.1/postgis_installation.html#hard_upgrade" target="_blank">http://postgis.net/docs/manual-2.1/postgis_installation.html#hard_upgrade</a><br>
<div class=""><br>
> Since I dumped everything, will I need to create all the
databases before<br>
> restoring the dump?<br>
><br>
> I should probably install the Postgis plug-in first,
right?<br>
<br></div>
You should create the databases and spatially-enable them<br>
(could be a chance to switch to EXTENSION-based install).<br>
<div class=""><br>
> My dump is pretty big at 101 GB (it contains 3m resolution
DEMs of Iowa).<br>
> Is there anything I need to do in order to minimize errors in
the restore?<br>
<br></div>
I guess you could reinstall each database separately, to at
least<br>
be more in control of what fails ...<br>
<br>
--strk;<br>
<br>
() ASCII ribbon campaign -- Keep it simple
!<br>
/\ <a href="http://strk.keybit.net/rants/ascii_mails.txt" target="_blank">http://strk.keybit.net/rants/ascii_mails.txt</a><br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org">postgis-users@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</a><br>
</blockquote>
</div>
<br></div>
_______________________________________________
<br>postgis-users mailing list
<br>postgis-users@lists.osgeo.org
<br>http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users</div></div></span></blockquote></body></html>
<br>
<p><font face="Arial" size="2">This transmission contains confidential and privileged
information intended solely for the party identified above. If you receive this message in error, you must not use
it or convey it to others. Please destroy it immediately and contact the sender at
(303) 386-3955 or by return e-mail to the sender.</font></p>