AmericanRedCross / GeoForce

Making Salesforce spatial
BSD 3-Clause "New" or "Revised" License
13 stars 3 forks source link

PostGIS Messed Up: No Longer Dumps #84

Closed hallahan closed 10 years ago

hallahan commented 10 years ago

I can't back up the DB anymore. I did a apt-get upgrade, and now the database is messed up.

pg_dump redcross_dev | gzip > dump.gz pg_dump: [archiver (db)] query failed: ERROR: could not load library "/usr/lib/postgresql/9.3/lib/postgis-2.1.so": liblwgeom-2.1.2.so: cannot open shared object file: No such file or directory pg_dump: [archiver (db)] query was: SELECT a.attnum, a.attname, a.atttypmod, a.attstattarget, a.attstorage, t.typstorage, a.attnotnull, a.atthasdef, a.attisdropped, a.attlen, a.attalign, a.attislocal, pg_catalog.format_type(t.oid,a.atttypmod) AS atttypname, array_to_string(a.attoptions, ', ') AS attoptions, CASE WHEN a.attcollation <> t.typcollation THEN a.attcollation ELSE 0 END AS attcollation, pg_catalog.array_to_string(ARRAY(SELECT pg_catalog.quote_ident(option_name) || ' ' || pg_catalog.quote_literal(option_value) FROM pg_catalog.pg_options_to_table(attfdwoptions) ORDER BY option_name), E', ') AS attfdwoptions FROM pg_catalog.pg_attribute a LEFT JOIN pg_catalog.pg_type t ON a.atttypid = t.oid WHERE a.attrelid = '19595'::pg_catalog.oid AND a.attnum > 0::pg_catalog.int2 ORDER BY a.attrelid, a.attnum

hallahan commented 10 years ago

http://gis.stackexchange.com/questions/97871/postgis-2-1-error-after-update

I'm going to try this.

hallahan commented 10 years ago

But first I'll remotely dump from my mac so that we don't lose the data. Frustrating...

hallahan commented 10 years ago

Database redeployed to Amazon RDS. GeoForce uses redcross_dev and https://webviz.redcross.org uses webviz_prod databases.