Skip to content

Instantly share code, notes, and snippets.

@Carmageddon
Last active May 31, 2016 00:28
Show Gist options
  • Save Carmageddon/ee1ba40048493d0ea19a05a0e2b49921 to your computer and use it in GitHub Desktop.
Save Carmageddon/ee1ba40048493d0ea19a05a0e2b49921 to your computer and use it in GitHub Desktop.
root@Dev:~ # pg_restore -h localhost -U superuser -d postgres -C Room-DB
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3700; 1262 16384 DATABASE room postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER DATABASE room OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 7; 2615 34105 SCHEMA tiger postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER SCHEMA tiger OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 9; 2615 34673 SCHEMA tiger_staging postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER SCHEMA tiger_staging OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 3026; 3602 41230 TEXT SEARCH CONFIGURATION english postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TEXT SEARCH CONFIGURATION public.english OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 175; 1259 32781 TABLE cities postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.cities OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 176; 1259 32786 TABLE countries postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.countries OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 246; 1259 41059 SEQUENCE country_country_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.country_country_id_seq OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 245; 1259 41057 SEQUENCE county_country_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.county_country_id_seq OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 251; 1259 41197 TABLE event_messages postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.event_messages OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 174; 1259 32768 TABLE event_tags postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.event_tags OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 177; 1259 32791 TABLE events postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.events OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 247; 1259 41067 SEQUENCE events_event_id postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.events_event_id OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 248; 1259 41069 SEQUENCE events_event_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.events_event_id_seq OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 244; 1259 41047 TABLE global_points postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.global_points OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 243; 1259 41045 SEQUENCE global_points_id_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.global_points_id_seq OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 253; 1259 42739 TABLE roles postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.roles OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 173; 1259 24576 TABLE tags postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.tags OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 254; 1259 42745 TABLE user_events postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.user_events OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 250; 1259 41184 TABLE user_phones postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.user_phones OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 249; 1259 41174 TABLE users postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.users OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 252; 1259 41215 TABLE users_followed postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE public.users_followed OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 241; 1259 34674 TABLE county_all postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE tiger_data.county_all OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 242; 1259 41037 TABLE county_all_lookup postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE tiger_data.county_all_lookup OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 240; 1259 34531 TABLE state_all postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: ALTER TABLE tiger_data.state_all OWNER TO postgres;
pg_restore: [archiver (db)] Error from TOC entry 3424; 0 34112 TABLE DATA geocode_settings postgres
pg_restore: [archiver (db)] COPY failed for table "geocode_settings": ERROR: duplicate key value violates unique constraint "geocode_settings_pkey"
DETAIL: Key (name)=(debug_geocode_address) already exists.
CONTEXT: COPY geocode_settings, line 1
pg_restore: [archiver (db)] Error from TOC entry 3703; 0 0 ACL public postgres
pg_restore: [archiver (db)] could not execute query: ERROR: role "postgres" does not exist
Command was: REVOKE ALL ON SCHEMA public FROM PUBLIC;
REVOKE ALL ON SCHEMA public FROM postgres;
GRANT ALL ON SCHEMA public TO postgres;
...
WARNING: errors ignored on restore: 26
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment