derekeder
commented
11 years ago assessor.dump and cook_county.dump errors:
pg_restore -U derekeder -h localhost -O -c -d edifice downloads/assessor.dump pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 527; 1259 28108 TABLE vacant_improved cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table vacant_improved because other objects depend on it DETAIL: view countdown depends on table vacant_improved HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.vacant_improved;
pg_restore: [archiver (db)] Error from TOC entry 526; 1259 28105 TABLE vacant_adjacent cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table vacant_adjacent because other objects depend on it DETAIL: view countdown depends on table vacant_adjacent HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.vacant_adjacent;
pg_restore: [archiver (db)] Error from TOC entry 525; 1259 28102 TABLE vacant cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table vacant because other objects depend on it DETAIL: view countdown depends on table vacant HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.vacant;
pg_restore: [archiver (db)] Error from TOC entry 524; 1259 28096 TABLE res202 cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table res202 because other objects depend on it DETAIL: view countdown depends on table res202 HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.res202;
pg_restore: [archiver (db)] Error from TOC entry 523; 1259 28093 TABLE exempt cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table exempt because other objects depend on it DETAIL: view countdown depends on table exempt HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.exempt;
pg_restore: [archiver (db)] Error from TOC entry 515; 1259 27981 TABLE condos_distinct cory pg_restore: [archiver (db)] could not execute query: ERROR: table "condos_distinct" does not exist Command was: DROP TABLE assessed.condos_distinct;
pg_restore: [archiver (db)] Error from TOC entry 522; 1259 28087 TABLE condos cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table condos because other objects depend on it DETAIL: view countdown depends on table condos HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.condos;
pg_restore: [archiver (db)] Error from TOC entry 520; 1259 28081 TABLE apts cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop table apts because other objects depend on it DETAIL: view countdown depends on table apts HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP TABLE assessed.apts;
pg_restore: [archiver (db)] Error from TOC entry 10; 2615 27913 SCHEMA assessed cory pg_restore: [archiver (db)] could not execute query: ERROR: cannot drop schema assessed because other objects depend on it DETAIL: table apts depends on schema assessed table condos depends on schema assessed table exempt depends on schema assessed table res202 depends on schema assessed table vacant depends on schema assessed table vacant_adjacent depends on schema assessed table vacant_improved depends on schema assessed view countdown depends on schema assessed table pins_propclass_tocheck depends on schema assessed table sent_pins depends on schema assessed HINT: Use DROP ... CASCADE to drop the dependent objects too. Command was: DROP SCHEMA assessed;
pg_restore: [archiver (db)] could not execute query: ERROR: schema "assessed" already exists Command was: CREATE SCHEMA assessed;
pg_restore: [archiver (db)] Error from TOC entry 520; 1259 28081 TABLE apts cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "apts" already exists Command was: CREATE TABLE apts ( pin character varying(20), address character varying(100), lav_2011 character varying(20), ... pg_restore: [archiver (db)] Error from TOC entry 522; 1259 28087 TABLE condos cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "condos" already exists Command was: CREATE TABLE condos ( pin character varying(20), address character varying(150), lav_2011 character varying(50),... pg_restore: [archiver (db)] Error from TOC entry 523; 1259 28093 TABLE exempt cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "exempt" already exists Command was: CREATE TABLE exempt ( pin character varying(20) );
pg_restore: [archiver (db)] Error from TOC entry 524; 1259 28096 TABLE res202 cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "res202" already exists Command was: CREATE TABLE res202 ( pin character varying(20), address character varying(100), lav_2011 character varying(20),... pg_restore: [archiver (db)] Error from TOC entry 525; 1259 28102 TABLE vacant cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "vacant" already exists Command was: CREATE TABLE vacant ( pin character varying(20), address character varying(150), lav_2011 character varying(50),... pg_restore: [archiver (db)] Error from TOC entry 526; 1259 28105 TABLE vacant_adjacent cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "vacant_adjacent" already exists Command was: CREATE TABLE vacant_adjacent ( pin character varying(20), address character varying(150), lav_2011 character var... pg_restore: [archiver (db)] Error from TOC entry 527; 1259 28108 TABLE vacant_improved cory pg_restore: [archiver (db)] could not execute query: ERROR: relation "vacant_improved" already exists Command was: CREATE TABLE vacant_improved ( pin character varying(20), address character varying(100), lav_last character var... pg_restore: [archiver (db)] Error from TOC entry 3669; 0 0 ACL assessed cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON SCHEMA assessed FROM PUBLIC; REVOKE ALL ON SCHEMA assessed FROM cory; GRANT ALL ON SCHEMA assessed TO cory; GR... pg_restore: [archiver (db)] Error from TOC entry 3670; 0 0 ACL apts cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE apts FROM PUBLIC; REVOKE ALL ON TABLE apts FROM cory; GRANT ALL ON TABLE apts TO cory; GRANT SELECT ON T... pg_restore: [archiver (db)] Error from TOC entry 3671; 0 0 ACL assessed_sent_pins cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE assessed_sent_pins FROM PUBLIC; REVOKE ALL ON TABLE assessed_sent_pins FROM cory; GRANT ALL ON TABLE ass... pg_restore: [archiver (db)] Error from TOC entry 3672; 0 0 ACL condos cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE condos FROM PUBLIC; REVOKE ALL ON TABLE condos FROM cory; GRANT ALL ON TABLE condos TO cory; GRANT SELEC... pg_restore: [archiver (db)] Error from TOC entry 3673; 0 0 ACL condos_distinct cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE condos_distinct FROM PUBLIC; REVOKE ALL ON TABLE condos_distinct FROM cory; GRANT ALL ON TABLE condos_di... pg_restore: [archiver (db)] Error from TOC entry 3674; 0 0 ACL exempt cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE exempt FROM PUBLIC; REVOKE ALL ON TABLE exempt FROM cory; GRANT ALL ON TABLE exempt TO cory; GRANT SELEC... pg_restore: [archiver (db)] Error from TOC entry 3675; 0 0 ACL garage cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE garage FROM PUBLIC; REVOKE ALL ON TABLE garage FROM cory; GRANT ALL ON TABLE garage TO cory; GRANT SELEC... pg_restore: [archiver (db)] Error from TOC entry 3676; 0 0 ACL invalid_pins cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE invalid_pins FROM PUBLIC; REVOKE ALL ON TABLE invalid_pins FROM cory; GRANT ALL ON TABLE invalid_pins TO... pg_restore: [archiver (db)] Error from TOC entry 3677; 0 0 ACL propclass cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE propclass FROM PUBLIC; REVOKE ALL ON TABLE propclass FROM cory; GRANT ALL ON TABLE propclass TO cory; GR... pg_restore: [archiver (db)] Error from TOC entry 3678; 0 0 ACL res202 cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE res202 FROM PUBLIC; REVOKE ALL ON TABLE res202 FROM cory; GRANT ALL ON TABLE res202 TO cory; GRANT SELEC... pg_restore: [archiver (db)] Error from TOC entry 3679; 0 0 ACL retry cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE retry FROM PUBLIC; REVOKE ALL ON TABLE retry FROM cory; GRANT ALL ON TABLE retry TO cory; GRANT SELECT O... pg_restore: [archiver (db)] Error from TOC entry 3680; 0 0 ACL vacant cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE vacant FROM PUBLIC; REVOKE ALL ON TABLE vacant FROM cory; GRANT ALL ON TABLE vacant TO cory; GRANT SELEC... pg_restore: [archiver (db)] Error from TOC entry 3681; 0 0 ACL vacant_adjacent cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE vacant_adjacent FROM PUBLIC; REVOKE ALL ON TABLE vacant_adjacent FROM cory; GRANT ALL ON TABLE vacant_ad... pg_restore: [archiver (db)] Error from TOC entry 3682; 0 0 ACL vacant_improved cory pg_restore: [archiver (db)] could not execute query: ERROR: role "cory" does not exist Command was: REVOKE ALL ON TABLE vacant_improved FROM PUBLIC; REVOKE ALL ON TABLE vacant_improved FROM cory; GRANT ALL ON TABLE vacant_im... WARNING: errors ignored on restore: 31 Note: cook_county.dump already exists. Not fetching it. Loading property cook_county... pg_restore -U derekeder -h localhost -O -c -d edifice downloads/cook_county.dump pg_restore: [archiver] Error while PROCESSING TOC: pg_restore: [archiver] Error from TOC entry 3644; 1259 27904 INDEX county_temp_distinct_geom_gist cory pg_restore: [archiver] could not set search_path to "county": ERROR: invalid value for parameter "search_path": "county, pg_catalog" DETAIL: schema "county" does not exist pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP INDEX county.county_temp_distinct_geom_gist;
pg_restore: [archiver (db)] Error from TOC entry 3646; 2606 28167 CONSTRAINT pins_master_pkey cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: ALTER TABLE ONLY county.pins_master DROP CONSTRAINT pins_master_pkey;
pg_restore: [archiver (db)] Error from TOC entry 3643; 2604 28165 DEFAULT id cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: ALTER TABLE county.pins_master ALTER COLUMN id DROP DEFAULT;
pg_restore: [archiver (db)] Error from TOC entry 516; 1259 28013 TABLE taxcode cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP TABLE county.taxcode;
pg_restore: [archiver (db)] Error from TOC entry 512; 1259 27898 TABLE property_info cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP TABLE county.property_info;
pg_restore: [archiver (db)] Error from TOC entry 514; 1259 27957 TABLE propclass cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP TABLE county.propclass;
pg_restore: [archiver (db)] Error from TOC entry 537; 1259 28163 SEQUENCE pins_master_id_seq cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP SEQUENCE county.pins_master_id_seq;
pg_restore: [archiver (db)] Error from TOC entry 536; 1259 28160 TABLE pins_master cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP TABLE county.pins_master;
pg_restore: [archiver (db)] Error from TOC entry 16; 2615 28016 SCHEMA county cory pg_restore: [archiver (db)] could not execute query: ERROR: schema "county" does not exist Command was: DROP SCHEMA county;
Remove this user from the dumps.