<div dir="ltr">Well, the the thing is psql is what's initially giving me the error that function st_bandmetadata(public.raster, integer[]) does not exist. <div><br></div><div>Would it be okay to let the restore continue even with those errors? I just simply want all the data back into a database so I can get our webapp back online. </div>
<div><br></div><div>Our data is static, so I don't see the benefit of dumping each database individually. I only did this since we were having issues upgrading Postgres and PostGIS, along with other Ubuntu issues.</div>
<div><br></div><div>Thanks for all the help. I will start afresh tomorrow morning.</div><div><br></div><div>Cheers,</div><div>Jayson</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 19, 2014 at 5:24 PM, Bborie Park <span dir="ltr"><<a href="mailto:dustymugs@gmail.com" target="_blank">dustymugs@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Jayson,<div><br></div><div>Too late now but you generally don't want to use pg_dumpall as that dumps a database cluster (all databases and catalog data) into one text (SQL) file. You may need to go down this nasty road...</div>
<div><br></div><div>1. Set up a clean postgresql server</div><div><br></div><div>2. Use psql to restore the database cluster to that new server</div><div><br></div><div>3. Dump your databases individually using pg_dump and the custom file format ("-F c")</div>
<div><br></div><div>4. On your final database server, restore each database using pg_restore. I usually extract the backup from the custom file format to a text file as I have to modify the search_path parameter to include my schema layout.</div>
<span class="HOEnZb"><font color="#888888">
<div><br></div><div>-bborie</div></font></span></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 19, 2014 at 3:11 PM, Jayson Gallardo <span dir="ltr"><<a href="mailto:jaysontrades@gmail.com" target="_blank">jaysontrades@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">We have about that many raster sources that are tiled into the database. I would like to try your suggestion, however when I run pg_restore it tells me that my dump is text format and that I should use psql. I don't see an option for psql to do a restore schema only.</div>
<div><div>
<div class="gmail_extra"><br><br><div class="gmail_quote">On Mon, May 19, 2014 at 4:14 PM, Jason Mathis <span dir="ltr"><<a href="mailto:jmathis@redzonesoftware.com" target="_blank">jmathis@redzonesoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
Are you getting that error on the <a href="http://postgis_restore.pl" target="_blank">postgis_restore.pl</a>? </div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">If yes I am not sure about that one I will leave it up to the pros. I think there is a bug open somewhere about this issue…Basically its calling a function (to create the constraint) that is in another schema not the one you are restoring to and the call is not fully qualified. </div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
In the past with raster tables I have had to go this route:</div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><ol><li>restore schema only</li><li>drop all raster constraints for each table <a href="http://postgis.net/docs/RT_DropRasterConstraints.html" target="_blank">http://postgis.net/docs/RT_DropRasterConstraints.html</a></li>
<li>restore the data</li><li>add all raster constants back for each table <a href="http://postgis.net/docs/RT_AddRasterConstraints.htm" target="_blank">http://postgis.net/docs/RT_AddRasterConstraints.htm</a></li></ol></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">I actually had to create a separate script to run through my tables because we have about 25-30 raster tables. </div>
<div><div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto"><br></div><div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div><p style="color:#000">On May 19, 2014 at 3:02:32 PM, Jayson Gallardo (<a href="mailto:jaysontrades@gmail.com" target="_blank">jaysontrades@gmail.com</a>) wrote:</p> <blockquote type="cite"><span><div><div></div>
<div>
<div dir="ltr">Yes. The database has rasters. I just tried loading
rtpostgis.sql, etc., but none of those seemed to help at all. I did
load legacy.sql before the dump as well.</div>
<div class="gmail_extra"><br>
<br>
<div class="gmail_quote">On Mon, May 19, 2014 at 3:54 PM, Jason
Mathis <span dir="ltr"><<a href="mailto:jmathis@redzonesoftware.com" target="_blank">jmathis@redzonesoftware.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div>
<div style="font-family:helvetica,arial;font-size:13px">Do you have
raster columns/tables?</div>
</div>
<div>
<div><br>
<p style="color:#000">On May 19, 2014 at 2:47:47 PM, Jayson
Gallardo (<a href="mailto:jaysontrades@gmail.com" target="_blank">jaysontrades@gmail.com</a>) wrote:</p>
<blockquote type="cite">
<div>
<div>
<div dir="ltr">
<div><span>So, I finally got around to running the restore, but I
get this following error:</span></div>
<div><span><br></span></div>
<div><span>ERROR: function st_bandmetadata(public.raster,
integer[]) does not exist</span></div>
<div><span><br></span></div>
<div><span>Any ideas?</span></div>
</div>
<div class="gmail_extra"><span><br>
<br></span>
<div class="gmail_quote"><span>On Mon, May 19, 2014 at 12:29 PM,
Jason Mathis <span dir="ltr"><<a href="mailto:jmathis@redzonesoftware.com" target="_blank">jmathis@redzonesoftware.com</a>></span>
wrote:<br></span>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">
<div 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 style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
<br></div>
<div style="font-family:Helvetica,Arial;font-size:13px;color:rgba(0,0,0,1.0);margin:0px;line-height:auto">
good luck!</div>
<div>
<div>
<div>
<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" target="_blank">jaysontrades@gmail.com</a>) wrote:</p>
<blockquote type="cite">
<div>
<div>
<div dir="ltr"><span>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.</span></div>
<div class="gmail_extra"><span><br>
<br></span>
<div class="gmail_quote"><span>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></span>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div>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>
<div><br></div></blockquote></div></div></div></div></blockquote></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div></blockquote></div></div></div></div></span></blockquote><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><blockquote type="cite">
<span><div><div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><div><blockquote type="cite">
<div><div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div><div><blockquote type="cite">
<div><div><div class="gmail_extra"><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div>
> 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><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" target="_blank">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>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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></div>
</div>
</blockquote>
</div>
</div>
</div>
<br>
<p><font face="Arial">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 <a href="tel:%28303%29%20386-3955" value="+13033863955" target="_blank">(303) 386-3955</a> or by return e-mail to the
sender.</font></p>
</blockquote>
</div>
<br></div>
</div>
</div>
</blockquote>
</div>
</div>
</div>
<div>
<div><br>
<p><font face="Arial">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 <a href="tel:%28303%29%20386-3955" value="+13033863955" target="_blank">(303) 386-3955</a> or by return e-mail to the
sender.</font></p>
</div>
</div>
</blockquote>
</div>
<br></div>
</div></div></span></blockquote></div></div></div><div><div>
<br>
<p><font face="Arial">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
<a href="tel:%28303%29%20386-3955" value="+13033863955" target="_blank">(303) 386-3955</a> or by return e-mail to the sender.</font></p>
</div></div></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@lists.osgeo.org" target="_blank">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>
</div></div><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>