[postgis-users] Restoring a dump

[Jayson Gallardo]

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.


On Mon, May 19, 2014 at 4:14 PM, Jason Mathis
<jmathis at redzonesoftware.com>wrote:

> Are you getting that error on the postgis_restore.pl?
>
> 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.
>
> In the past with raster tables I have had to go this route:
>
>    1. restore schema only
>    2. drop all raster constraints for each table
>    http://postgis.net/docs/RT_DropRasterConstraints.html
>    3. restore the data
>    4. add all raster constants back for each table
>    http://postgis.net/docs/RT_AddRasterConstraints.htm
>
> I actually had to create a separate script to run through my tables
> because we have about 25-30 raster tables.
>
>
> On May 19, 2014 at 3:02:32 PM, Jayson Gallardo (jaysontrades at gmail.com)
> wrote:
>
> 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.
>
>
> On Mon, May 19, 2014 at 3:54 PM, Jason Mathis <jmathis at redzonesoftware.com
> > wrote:
>
>>
>>  Do you have raster columns/tables?
>>
>> On May 19, 2014 at 2:47:47 PM, Jayson Gallardo (jaysontrades at gmail.com)
>> wrote:
>>
>>   So, I finally got around to running the restore, but I get this
>> following error:
>>
>> ERROR:  function st_bandmetadata(public.raster, integer[]) does not exist
>>
>> Any ideas?
>>
>>
>> On Mon, May 19, 2014 at 12:29 PM, Jason Mathis <
>> jmathis at redzonesoftware.com> wrote:
>>
>>>  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.
>>>
>>>  good luck!
>>>
>>>
>>> On May 19, 2014 at 10:22:38 AM, Jayson Gallardo (jaysontrades at gmail.com)
>>> wrote:
>>>
>>>  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
>>>>
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at lists.osgeo.org
>>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>>
>>>
>>> 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.
>>>
>>
>>
>> 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.
>>
>
>
> 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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140519/81dba184/attachment.html>