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 <[email protected]>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 ([email protected]) > 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 <[email protected]> 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 >> [email protected] >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users >> > > _______________________________________________ > postgis-users mailing list > [email protected] > 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. >
_______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
