assessor.dump and cook_county.dump contain 'cory' user

[derekeder]

Remove this user from the dumps.

[derekeder]

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;