[postgis-users] Restoring a dump

[Jayson Gallardo]

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.
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20140519/aa6d83d2/attachment.html>