<div dir="ltr">Hi Regina,<div><br></div><div>Thanks so much for the quick response, that did the trick! </div><div><br></div><div>-Shane</div></div><br><div class="gmail_quote"><div dir="ltr">On Tue, May 2, 2017 at 1:53 PM Regina Obe <<a href="mailto:lr@pcorp.us">lr@pcorp.us</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div lang="EN-US" link="blue" vlink="purple"><div class="m_100085399647806870WordSection1"><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Shane,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">I've ticketed this issue here: <a href="https://trac.osgeo.org/postgis/ticket/3750" target="_blank">https://trac.osgeo.org/postgis/ticket/3750</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"> Most of these issues related to restore were fixed in PostGIS 2.3, but looks like you found a missed spot.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">To fix, you should have a folder in your postgresql install share/extension with a file called postgis.sql<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Search for $1 @ $2<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Should be around line 4057<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Change that to:<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">$1 OPERATOR(@extschema@.@) $2<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">And then try to reinstall your backup in a clean database.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Let me know if you still run into issues.<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Thanks,<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">Regina<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d">PostGIS PSC Member<u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://www.postgis.us" target="_blank">http://www.postgis.us</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><a href="http://postgis.net" target="_blank">http://postgis.net</a><u></u><u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri",sans-serif;color:#1f497d"><u></u> <u></u></span></p><p class="MsoNormal" style="margin-left:.5in"><b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri",sans-serif"> postgis-users [mailto:<a href="mailto:postgis-users-bounces@lists.osgeo.org" target="_blank">postgis-users-bounces@lists.osgeo.org</a>] <b>On Behalf Of </b>Shane StClair<br><b>Sent:</b> Tuesday, May 02, 2017 3:55 PM<br><b>To:</b> <a href="mailto:postgis-users@lists.osgeo.org" target="_blank">postgis-users@lists.osgeo.org</a><br><b>Subject:</b> Re: [postgis-users] Restore a raster dump from PostGIS 2.1.0 to PostGIS 2.3.0<u></u><u></u></span></p></div></div><div lang="EN-US" link="blue" vlink="purple"><div class="m_100085399647806870WordSection1"><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><p class="MsoNormal" style="margin-left:.5in">Was a solution to this problem ever discovered? I'm running into exactly the same problem (backup from PostGIS 2.1 with raster tables can't be restored to PostGIS 2.3).<u></u><u></u></p><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><div><div><p class="MsoNormal" style="margin-left:.5in">HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">QUERY:  SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">CONTEXT:  SQL function "st_coveredby" during inlining<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">COPY coei_166_3857, line 1: "1  010000010091C9D81F26AAE94091C9D81F26AAE9C082B6A532F81B73C103DAD0FE58846041000000000000000000000000..."<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">pg_restore: [archiver (db)] Error from TOC entry 187538; 0 223203 TABLE DATA coei_196_3857 asdf<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">pg_restore: [archiver (db)] COPY failed for table "coei_196_3857": ERROR:  operator does not exist: public.geometry @ public.geometry<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in">LINE 1: SELECT $1 @ $2 AND public._ST_CoveredBy($1,$2)<u></u><u></u></p></div></div><div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p><div><div><p class="MsoNormal" style="margin-left:.5in">On Fri, Nov 25, 2016 at 6:48 AM Cedric Duprez <<a href="mailto:Cedric.Duprez@ign.fr" target="_blank">Cedric.Duprez@ign.fr</a>> wrote:<u></u><u></u></p></div><blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in"><div><p class="MsoNormal" style="margin-left:.5in">Sorry, I thought I had installed PostGIS 2.1 on my backup server, but it is 2.3 that has been finally installed.<br><br>I don't understand how that could be.<br><br>The server is on Debian Jessie, and I did the following packages installation:<br><br> apt-get update && apt-get install -y postgresql-9.3 postgresql-client-9.3 postgresql-contrib-9.3 postgresql-server-dev-9.3 && \<br>    apt-get install -y gdal-bin libgdal-dev && \<br>    apt-get install -y postgresql-9.3-postgis-2.1<br><br>Why do I get the 2.3 version of PostGIS installed? How can I downgrade to 2.1?<br><br>Thanks for you help.<br>Regards,<br><br>Cedric<u></u><u></u></p></div><div><p class="MsoNormal" style="margin-left:.5in"><br><br><br><u></u><u></u></p><blockquote style="margin-top:5.0pt;margin-bottom:5.0pt"><p class="MsoNormal" style="margin-left:.5in"><span style="font-family:"Helvetica",sans-serif">Hi,<br><br>Still same issue with two servers having the same configuration.<br><br>Regards,<br><br>Cedric</span><u></u><u></u></p><div><p class="MsoNormal" style="margin-right:0in;margin-bottom:12.0pt;margin-left:.5in"><u></u> <u></u></p></div><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></blockquote><p class="MsoNormal" style="margin-left:.5in"><u></u> <u></u></p></div><p class="MsoNormal" style="margin-left:.5in">_______________________________________________<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/mailman/listinfo/postgis-users" target="_blank">http://lists.osgeo.org/mailman/listinfo/postgis-users</a><u></u><u></u></p></blockquote></div></div></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="https://lists.osgeo.org/mailman/listinfo/postgis-users" rel="noreferrer" target="_blank">https://lists.osgeo.org/mailman/listinfo/postgis-users</a></blockquote></div>