Last active
May 31, 2016 00:28
-
-
Save Carmageddon/ee1ba40048493d0ea19a05a0e2b49921 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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