Created
February 12, 2014 15:01
-
-
Save sethherr/8957055 to your computer and use it in GitHub Desktop.
Trying to load Viddy data dump...
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
$ pg_restore --verbose --clean --no-acl --no-owner -d viddy latest.dump | |
pg_restore: connecting to database for restore | |
pg_restore: dropping MATERIALIZED VIEW DATA station_additions | |
pg_restore: dropping MATERIALIZED VIEW DATA current_stations | |
pg_restore: dropping FK CONSTRAINT station_updates_execution_id_fkey | |
pg_restore: [archiver (db)] Error while PROCESSING TOC: | |
pg_restore: [archiver (db)] Error from TOC entry 2742; 2606 16432 FK CONSTRAINT station_updates_execution_id_fkey ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_updates" does not exist | |
Command was: ALTER TABLE ONLY public.station_updates DROP CONSTRAINT station_updates_execution_id_fkey; | |
pg_restore: dropping TRIGGER station_update_executions_insertion_trigger | |
pg_restore: [archiver (db)] Error from TOC entry 2743; 2620 16431 TRIGGER station_update_executions_insertion_trigger ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_update_executions" does not exist | |
Command was: DROP TRIGGER station_update_executions_insertion_trigger ON public.station_update_executions; | |
pg_restore: dropping INDEX station_updates_station_id | |
pg_restore: [archiver (db)] Error from TOC entry 2741; 1259 240968 INDEX station_updates_station_id ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: index "station_updates_station_id" does not exist | |
Command was: DROP INDEX public.station_updates_station_id; | |
pg_restore: dropping INDEX station_updates_execution_id | |
pg_restore: [archiver (db)] Error from TOC entry 2738; 1259 240940 INDEX station_updates_execution_id ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: index "station_updates_execution_id" does not exist | |
Command was: DROP INDEX public.station_updates_execution_id; | |
pg_restore: dropping INDEX station_update_executions_insertion_time | |
pg_restore: [archiver (db)] Error from TOC entry 2735; 1259 16428 INDEX station_update_executions_insertion_time ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: index "station_update_executions_insertion_time" does not exist | |
Command was: DROP INDEX public.station_update_executions_insertion_time; | |
pg_restore: dropping INDEX station_update_executions_execution_time | |
pg_restore: [archiver (db)] Error from TOC entry 2734; 1259 240893 INDEX station_update_executions_execution_time ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: index "station_update_executions_execution_time" does not exist | |
Command was: DROP INDEX public.station_update_executions_execution_time; | |
pg_restore: dropping CONSTRAINT station_updates_pkey | |
pg_restore: [archiver (db)] Error from TOC entry 2740; 2606 16427 CONSTRAINT station_updates_pkey ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_updates" does not exist | |
Command was: ALTER TABLE ONLY public.station_updates DROP CONSTRAINT station_updates_pkey; | |
pg_restore: dropping CONSTRAINT station_update_executions_pkey | |
pg_restore: [archiver (db)] Error from TOC entry 2737; 2606 16425 CONSTRAINT station_update_executions_pkey ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_update_executions" does not exist | |
Command was: ALTER TABLE ONLY public.station_update_executions DROP CONSTRAINT station_update_executions_pkey; | |
pg_restore: dropping SEQUENCE SET station_updates_id_seq | |
pg_restore: dropping TABLE DATA station_updates | |
pg_restore: dropping SEQUENCE SET station_update_executions_id_seq | |
pg_restore: dropping TABLE DATA station_update_executions | |
pg_restore: dropping DEFAULT id | |
pg_restore: [archiver (db)] Error from TOC entry 2733; 2604 16423 DEFAULT id ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_updates" does not exist | |
Command was: ALTER TABLE public.station_updates ALTER COLUMN id DROP DEFAULT; | |
pg_restore: dropping DEFAULT id | |
pg_restore: [archiver (db)] Error from TOC entry 2732; 2604 16422 DEFAULT id ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: relation "public.station_update_executions" does not exist | |
Command was: ALTER TABLE public.station_update_executions ALTER COLUMN id DROP DEFAULT; | |
pg_restore: dropping SEQUENCE OWNED BY station_updates_id_seq | |
pg_restore: dropping SEQUENCE station_updates_id_seq | |
pg_restore: [archiver (db)] Error from TOC entry 173; 1259 16420 SEQUENCE station_updates_id_seq ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: sequence "station_updates_id_seq" does not exist | |
Command was: DROP SEQUENCE public.station_updates_id_seq; | |
pg_restore: dropping SEQUENCE OWNED BY station_update_executions_id_seq | |
pg_restore: dropping SEQUENCE station_update_executions_id_seq | |
pg_restore: [archiver (db)] Error from TOC entry 172; 1259 16418 SEQUENCE station_update_executions_id_seq ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: sequence "station_update_executions_id_seq" does not exist | |
Command was: DROP SEQUENCE public.station_update_executions_id_seq; | |
pg_restore: dropping MATERIALIZED VIEW station_additions | |
pg_restore: [archiver (db)] Error from TOC entry 175; 1259 16452 MATERIALIZED VIEW station_additions ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: materialized view "station_additions" does not exist | |
Command was: DROP MATERIALIZED VIEW public.station_additions; | |
pg_restore: dropping MATERIALIZED VIEW current_stations | |
pg_restore: [archiver (db)] Error from TOC entry 174; 1259 16445 MATERIALIZED VIEW current_stations ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: materialized view "current_stations" does not exist | |
Command was: DROP MATERIALIZED VIEW public.current_stations; | |
pg_restore: dropping TABLE station_updates | |
pg_restore: [archiver (db)] Error from TOC entry 171; 1259 16404 TABLE station_updates ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: table "station_updates" does not exist | |
Command was: DROP TABLE public.station_updates; | |
pg_restore: dropping TABLE station_update_executions | |
pg_restore: [archiver (db)] Error from TOC entry 170; 1259 16401 TABLE station_update_executions ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: table "station_update_executions" does not exist | |
Command was: DROP TABLE public.station_update_executions; | |
pg_restore: dropping FUNCTION set_insertion_time_timestamp() | |
pg_restore: [archiver (db)] Error from TOC entry 189; 1255 16400 FUNCTION set_insertion_time_timestamp() ufasaucshs5ksb | |
pg_restore: [archiver (db)] could not execute query: ERROR: function public.set_insertion_time_timestamp() does not exist | |
Command was: DROP FUNCTION public.set_insertion_time_timestamp(); | |
pg_restore: dropping COMMENT EXTENSION plpgsql | |
pg_restore: dropping EXTENSION plpgsql | |
pg_restore: dropping COMMENT SCHEMA public | |
pg_restore: dropping SCHEMA public | |
pg_restore: creating SCHEMA public | |
pg_restore: creating COMMENT SCHEMA public | |
pg_restore: creating EXTENSION plpgsql | |
pg_restore: creating COMMENT EXTENSION plpgsql | |
pg_restore: creating FUNCTION set_insertion_time_timestamp() | |
pg_restore: creating TABLE station_update_executions | |
pg_restore: creating TABLE station_updates | |
pg_restore: creating MATERIALIZED VIEW current_stations | |
pg_restore: creating MATERIALIZED VIEW station_additions | |
pg_restore: creating SEQUENCE station_update_executions_id_seq | |
pg_restore: creating SEQUENCE OWNED BY station_update_executions_id_seq | |
pg_restore: creating SEQUENCE station_updates_id_seq | |
pg_restore: creating SEQUENCE OWNED BY station_updates_id_seq | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: processing data for table "station_update_executions" | |
pg_restore: executing SEQUENCE SET station_update_executions_id_seq | |
pg_restore: processing data for table "station_updates" | |
pg_restore: executing SEQUENCE SET station_updates_id_seq | |
pg_restore: creating CONSTRAINT station_update_executions_pkey | |
pg_restore: creating CONSTRAINT station_updates_pkey | |
pg_restore: creating INDEX station_update_executions_execution_time | |
pg_restore: creating INDEX station_update_executions_insertion_time | |
pg_restore: creating INDEX station_updates_execution_id | |
pg_restore: creating INDEX station_updates_station_id |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment