[prev in list] [next in list] [prev in thread] [next in thread]
List: postgis-users
Subject: Re: [postgis-users] pg_restore raster workaround help
From: Chris Lee <chris.lee.holcomb () gmail ! com>
Date: 2016-07-19 16:57:01
Message-ID: CAEVevZKPRtODK1A3p7ef=QfXT+tiNQx6jDxRQ1dDhzrtPyVzwQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Thank you, it's there and everything appears to be working. FWIW I'm on
Ubuntu 14.04.4 and used a package manager to install PostGIS 2.2.2 r14797.
As far as the phrase, I suspect that "Please install PostGIS and run script
on the same schema that was used for PostGIS on the database you backed up"
would be slightly more clear. Part of my confusion was that my backup was
only a schema backup, and not the same schema.
Chris
Chris Holcomb
Master in Public Affairs, 2011
Master in Energy and Earth Resources, 2011
cholcomb@mail.utexas.edu
512.496.6942
On Mon, Jul 18, 2016 at 1:39 PM, Chris Lee <chris.lee.holcomb@gmail.com>
wrote:
> Has anyone had any luck with http://postgis
> .net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore?
>
> I have backed up a raster only schema coming from 9.4/2.2 going to
> 9.5/2.2. Can you please clarify "make sure to install in same schema as
> your backup was installed in" ?
>
> The PostGIS extension is on public and I tried loading just the schema
> (rasters) before loading the data. How can I find
> rtpostgis_proc_set_search_path.sql ?
>
> Thanks,
>
> Chris
>
[Attachment #5 (text/html)]
<div dir="ltr">Thank you, it's there and everything appears to be working. FWIW \
I'm on Ubuntu 14.04.4 and used a package manager to install PostGIS 2.2.2 \
r14797. As far as the phrase, I suspect that "Please install PostGIS and run \
script on the same schema that was used for PostGIS on the database you backed \
up" would be slightly more clear. Part of my confusion was that my backup was \
only a schema backup, and not the same schema.<br><br>Chris</div><div \
class="gmail_extra"><br clear="all"><div><div class="gmail_signature" \
data-smartmail="gmail_signature">Chris Holcomb<br>Master in Public Affairs, \
2011<br>Master in Energy and Earth Resources, 2011<br><a \
href="mailto:cholcomb@mail.utexas.edu" \
target="_blank">cholcomb@mail.utexas.edu</a><br>512.496.6942</div></div> <br><div \
class="gmail_quote">On Mon, Jul 18, 2016 at 1:39 PM, Chris Lee <span dir="ltr"><<a \
href="mailto:chris.lee.holcomb@gmail.com" \
target="_blank">chris.lee.holcomb@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"><span style="font-size:12.8px">Has anyone had \
any luck with </span><a \
href="http://postgis.net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore" \
style="font-size:12.8px" \
target="_blank">http://<span>postgis</span>.net/docs/manual-2.2/RT_FAQ.html#faq_raster_data_not_restore</a><span \
style="font-size:12.8px">?</span><br style="font-size:12.8px"><br \
style="font-size:12.8px"><span style="font-size:12.8px">I have backed up a raster \
only schema coming from 9.4/2.2 going to 9.5/2.2. Can you please clarify \
"</span><span style="color:rgb(46,46,46);font-family:"Courier \
New",Courier,Monaco,monospace;font-size:11px;line-height:16px;background-color:rgb(248,248,249)">make \
sure to install in same schema as your backup was installed in"</span><span \
style="font-size:12.8px"> ?</span><br style="font-size:12.8px"><br \
style="font-size:12.8px"><span style="font-size:12.8px">The </span><span \
style="font-size:12.8px">PostGIS</span><span style="font-size:12.8px"> extension is \
on public and I tried loading just the schema (rasters) before loading the data. How \
can I find </span><span style="color:rgb(46,46,46);font-family:"Courier \
New",Courier,Monaco,monospace;font-size:11px;line-height:16px;background-color:rgb(248,248,249)">rtpostgis_proc_set_search_path.sql \
</span><span style="font-size:12.8px">?</span><span \
style="color:rgb(46,46,46);font-family:"Courier \
New",Courier,Monaco,monospace;font-size:11px;line-height:16px;background-color:rgb(248,248,249)"><br><br></span><span \
style="font-size:12.8px">Thanks,</span><br style="font-size:12.8px"><br \
style="font-size:12.8px"><span style="font-size:12.8px">Chris</span><br> </div>
</blockquote></div><br></div>
[Attachment #6 (text/plain)]
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/postgis-users
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic