Created
October 3, 2014 20:00
-
-
Save jjcall/fe730fa4dd47b0b8da69 to your computer and use it in GitHub Desktop.
This file contains hidden or 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 -h localhost -U jjcall -d refinery_database_development latest.dump | |
pg_restore: connecting to database for restore | |
pg_restore: dropping INDEX unique_schema_migrations | |
pg_restore: dropping INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type | |
pg_restore: dropping INDEX index_seo_meta_on_id | |
pg_restore: dropping INDEX index_refinery_users_on_id | |
pg_restore: dropping INDEX index_refinery_user_plugins_on_user_id_and_name | |
pg_restore: dropping INDEX index_refinery_user_plugins_on_name | |
pg_restore: dropping INDEX index_refinery_roles_users_on_user_id_and_role_id | |
pg_restore: dropping INDEX index_refinery_roles_users_on_role_id_and_user_id | |
pg_restore: dropping INDEX index_refinery_pages_on_rgt | |
pg_restore: dropping INDEX index_refinery_pages_on_parent_id | |
pg_restore: dropping INDEX index_refinery_pages_on_lft | |
pg_restore: dropping INDEX index_refinery_pages_on_id | |
pg_restore: dropping INDEX index_refinery_pages_on_depth | |
pg_restore: dropping INDEX index_refinery_page_translations_on_locale | |
pg_restore: dropping INDEX index_refinery_page_parts_on_refinery_page_id | |
pg_restore: dropping INDEX index_refinery_page_parts_on_id | |
pg_restore: dropping INDEX index_refinery_page_part_translations_on_locale | |
pg_restore: dropping INDEX index_f9716c4215584edbca2557e32706a5ae084a15ef | |
pg_restore: dropping INDEX index_d079468f88bff1c6ea81573a0d019ba8bf5c2902 | |
pg_restore: dropping CONSTRAINT seo_meta_pkey | |
pg_restore: dropping CONSTRAINT schema_migrations_pkey | |
pg_restore: [archiver (db)] Error while PROCESSING TOC: | |
pg_restore: [archiver (db)] Error from TOC entry 2353; 2606 947300 CONSTRAINT schema_migrations_pkey enqiusnvouamgp | |
pg_restore: [archiver (db)] could not execute query: ERROR: constraint "schema_migrations_pkey" of relation "schema_migrations" does not exist | |
Command was: ALTER TABLE ONLY public.schema_migrations DROP CONSTRAINT schema_migrations_pkey; | |
pg_restore: dropping CONSTRAINT refinery_users_pkey | |
pg_restore: dropping CONSTRAINT refinery_user_plugins_pkey | |
pg_restore: dropping CONSTRAINT refinery_roles_pkey | |
pg_restore: dropping CONSTRAINT refinery_resources_pkey | |
pg_restore: dropping CONSTRAINT refinery_pages_pkey | |
pg_restore: dropping CONSTRAINT refinery_page_translations_pkey | |
pg_restore: dropping CONSTRAINT refinery_page_parts_pkey | |
pg_restore: dropping CONSTRAINT refinery_page_part_translations_pkey | |
pg_restore: dropping CONSTRAINT refinery_images_pkey | |
pg_restore: dropping SEQUENCE SET seo_meta_id_seq | |
pg_restore: dropping TABLE DATA seo_meta | |
pg_restore: dropping TABLE DATA schema_migrations | |
pg_restore: dropping SEQUENCE SET refinery_users_id_seq | |
pg_restore: dropping TABLE DATA refinery_users | |
pg_restore: dropping SEQUENCE SET refinery_user_plugins_id_seq | |
pg_restore: dropping TABLE DATA refinery_user_plugins | |
pg_restore: dropping TABLE DATA refinery_roles_users | |
pg_restore: dropping SEQUENCE SET refinery_roles_id_seq | |
pg_restore: dropping TABLE DATA refinery_roles | |
pg_restore: dropping SEQUENCE SET refinery_resources_id_seq | |
pg_restore: dropping TABLE DATA refinery_resources | |
pg_restore: dropping SEQUENCE SET refinery_pages_id_seq | |
pg_restore: dropping TABLE DATA refinery_pages | |
pg_restore: dropping SEQUENCE SET refinery_page_translations_id_seq | |
pg_restore: dropping TABLE DATA refinery_page_translations | |
pg_restore: dropping SEQUENCE SET refinery_page_parts_id_seq | |
pg_restore: dropping TABLE DATA refinery_page_parts | |
pg_restore: dropping SEQUENCE SET refinery_page_part_translations_id_seq | |
pg_restore: dropping TABLE DATA refinery_page_part_translations | |
pg_restore: dropping SEQUENCE SET refinery_images_id_seq | |
pg_restore: dropping TABLE DATA refinery_images | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping DEFAULT id | |
pg_restore: dropping SEQUENCE OWNED BY seo_meta_id_seq | |
pg_restore: dropping SEQUENCE seo_meta_id_seq | |
pg_restore: dropping TABLE seo_meta | |
pg_restore: dropping TABLE schema_migrations | |
pg_restore: dropping SEQUENCE OWNED BY refinery_users_id_seq | |
pg_restore: dropping SEQUENCE refinery_users_id_seq | |
pg_restore: dropping TABLE refinery_users | |
pg_restore: dropping SEQUENCE OWNED BY refinery_user_plugins_id_seq | |
pg_restore: dropping SEQUENCE refinery_user_plugins_id_seq | |
pg_restore: dropping TABLE refinery_user_plugins | |
pg_restore: dropping TABLE refinery_roles_users | |
pg_restore: dropping SEQUENCE OWNED BY refinery_roles_id_seq | |
pg_restore: dropping SEQUENCE refinery_roles_id_seq | |
pg_restore: dropping TABLE refinery_roles | |
pg_restore: dropping SEQUENCE OWNED BY refinery_resources_id_seq | |
pg_restore: dropping SEQUENCE refinery_resources_id_seq | |
pg_restore: dropping TABLE refinery_resources | |
pg_restore: dropping SEQUENCE OWNED BY refinery_pages_id_seq | |
pg_restore: dropping SEQUENCE refinery_pages_id_seq | |
pg_restore: dropping TABLE refinery_pages | |
pg_restore: dropping SEQUENCE OWNED BY refinery_page_translations_id_seq | |
pg_restore: dropping SEQUENCE refinery_page_translations_id_seq | |
pg_restore: dropping TABLE refinery_page_translations | |
pg_restore: dropping SEQUENCE OWNED BY refinery_page_parts_id_seq | |
pg_restore: dropping SEQUENCE refinery_page_parts_id_seq | |
pg_restore: dropping TABLE refinery_page_parts | |
pg_restore: dropping SEQUENCE OWNED BY refinery_page_part_translations_id_seq | |
pg_restore: dropping SEQUENCE refinery_page_part_translations_id_seq | |
pg_restore: dropping TABLE refinery_page_part_translations | |
pg_restore: dropping SEQUENCE OWNED BY refinery_images_id_seq | |
pg_restore: dropping SEQUENCE refinery_images_id_seq | |
pg_restore: dropping TABLE refinery_images | |
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 TABLE refinery_images | |
pg_restore: creating SEQUENCE refinery_images_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_images_id_seq | |
pg_restore: creating TABLE refinery_page_part_translations | |
pg_restore: creating SEQUENCE refinery_page_part_translations_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_page_part_translations_id_seq | |
pg_restore: creating TABLE refinery_page_parts | |
pg_restore: creating SEQUENCE refinery_page_parts_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_page_parts_id_seq | |
pg_restore: creating TABLE refinery_page_translations | |
pg_restore: creating SEQUENCE refinery_page_translations_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_page_translations_id_seq | |
pg_restore: creating TABLE refinery_pages | |
pg_restore: creating SEQUENCE refinery_pages_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_pages_id_seq | |
pg_restore: creating TABLE refinery_resources | |
pg_restore: creating SEQUENCE refinery_resources_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_resources_id_seq | |
pg_restore: creating TABLE refinery_roles | |
pg_restore: creating SEQUENCE refinery_roles_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_roles_id_seq | |
pg_restore: creating TABLE refinery_roles_users | |
pg_restore: creating TABLE refinery_user_plugins | |
pg_restore: creating SEQUENCE refinery_user_plugins_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_user_plugins_id_seq | |
pg_restore: creating TABLE refinery_users | |
pg_restore: creating SEQUENCE refinery_users_id_seq | |
pg_restore: creating SEQUENCE OWNED BY refinery_users_id_seq | |
pg_restore: creating TABLE schema_migrations | |
pg_restore: creating TABLE seo_meta | |
pg_restore: creating SEQUENCE seo_meta_id_seq | |
pg_restore: creating SEQUENCE OWNED BY seo_meta_id_seq | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: creating DEFAULT id | |
pg_restore: processing data for table "refinery_images" | |
pg_restore: executing SEQUENCE SET refinery_images_id_seq | |
pg_restore: processing data for table "refinery_page_part_translations" | |
pg_restore: executing SEQUENCE SET refinery_page_part_translations_id_seq | |
pg_restore: processing data for table "refinery_page_parts" | |
pg_restore: executing SEQUENCE SET refinery_page_parts_id_seq | |
pg_restore: processing data for table "refinery_page_translations" | |
pg_restore: executing SEQUENCE SET refinery_page_translations_id_seq | |
pg_restore: processing data for table "refinery_pages" | |
pg_restore: executing SEQUENCE SET refinery_pages_id_seq | |
pg_restore: processing data for table "refinery_resources" | |
pg_restore: executing SEQUENCE SET refinery_resources_id_seq | |
pg_restore: processing data for table "refinery_roles" | |
pg_restore: executing SEQUENCE SET refinery_roles_id_seq | |
pg_restore: processing data for table "refinery_roles_users" | |
pg_restore: processing data for table "refinery_user_plugins" | |
pg_restore: executing SEQUENCE SET refinery_user_plugins_id_seq | |
pg_restore: processing data for table "refinery_users" | |
pg_restore: executing SEQUENCE SET refinery_users_id_seq | |
pg_restore: processing data for table "schema_migrations" | |
pg_restore: processing data for table "seo_meta" | |
pg_restore: executing SEQUENCE SET seo_meta_id_seq | |
pg_restore: creating CONSTRAINT refinery_images_pkey | |
pg_restore: creating CONSTRAINT refinery_page_part_translations_pkey | |
pg_restore: creating CONSTRAINT refinery_page_parts_pkey | |
pg_restore: creating CONSTRAINT refinery_page_translations_pkey | |
pg_restore: creating CONSTRAINT refinery_pages_pkey | |
pg_restore: creating CONSTRAINT refinery_resources_pkey | |
pg_restore: creating CONSTRAINT refinery_roles_pkey | |
pg_restore: creating CONSTRAINT refinery_user_plugins_pkey | |
pg_restore: creating CONSTRAINT refinery_users_pkey | |
pg_restore: creating CONSTRAINT schema_migrations_pkey | |
pg_restore: creating CONSTRAINT seo_meta_pkey | |
pg_restore: creating INDEX index_d079468f88bff1c6ea81573a0d019ba8bf5c2902 | |
pg_restore: creating INDEX index_f9716c4215584edbca2557e32706a5ae084a15ef | |
pg_restore: creating INDEX index_refinery_page_part_translations_on_locale | |
pg_restore: creating INDEX index_refinery_page_parts_on_id | |
pg_restore: creating INDEX index_refinery_page_parts_on_refinery_page_id | |
pg_restore: creating INDEX index_refinery_page_translations_on_locale | |
pg_restore: creating INDEX index_refinery_pages_on_depth | |
pg_restore: creating INDEX index_refinery_pages_on_id | |
pg_restore: creating INDEX index_refinery_pages_on_lft | |
pg_restore: creating INDEX index_refinery_pages_on_parent_id | |
pg_restore: creating INDEX index_refinery_pages_on_rgt | |
pg_restore: creating INDEX index_refinery_roles_users_on_role_id_and_user_id | |
pg_restore: creating INDEX index_refinery_roles_users_on_user_id_and_role_id | |
pg_restore: creating INDEX index_refinery_user_plugins_on_name | |
pg_restore: creating INDEX index_refinery_user_plugins_on_user_id_and_name | |
pg_restore: creating INDEX index_refinery_users_on_id | |
pg_restore: creating INDEX index_seo_meta_on_id | |
pg_restore: creating INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type | |
pg_restore: creating INDEX unique_schema_migrations | |
pg_restore: setting owner and privileges for DATABASE ddl5dofo4trlgn | |
pg_restore: setting owner and privileges for SCHEMA public | |
pg_restore: setting owner and privileges for COMMENT SCHEMA public | |
pg_restore: setting owner and privileges for EXTENSION plpgsql | |
pg_restore: setting owner and privileges for COMMENT EXTENSION plpgsql | |
pg_restore: setting owner and privileges for TABLE refinery_images | |
pg_restore: setting owner and privileges for SEQUENCE refinery_images_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_images_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_page_part_translations | |
pg_restore: setting owner and privileges for SEQUENCE refinery_page_part_translations_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_page_part_translations_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_page_parts | |
pg_restore: setting owner and privileges for SEQUENCE refinery_page_parts_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_page_parts_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_page_translations | |
pg_restore: setting owner and privileges for SEQUENCE refinery_page_translations_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_page_translations_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_pages | |
pg_restore: setting owner and privileges for SEQUENCE refinery_pages_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_pages_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_resources | |
pg_restore: setting owner and privileges for SEQUENCE refinery_resources_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_resources_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_roles | |
pg_restore: setting owner and privileges for SEQUENCE refinery_roles_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_roles_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_roles_users | |
pg_restore: setting owner and privileges for TABLE refinery_user_plugins | |
pg_restore: setting owner and privileges for SEQUENCE refinery_user_plugins_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_user_plugins_id_seq | |
pg_restore: setting owner and privileges for TABLE refinery_users | |
pg_restore: setting owner and privileges for SEQUENCE refinery_users_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY refinery_users_id_seq | |
pg_restore: setting owner and privileges for TABLE schema_migrations | |
pg_restore: setting owner and privileges for TABLE seo_meta | |
pg_restore: setting owner and privileges for SEQUENCE seo_meta_id_seq | |
pg_restore: setting owner and privileges for SEQUENCE OWNED BY seo_meta_id_seq | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for DEFAULT id | |
pg_restore: setting owner and privileges for TABLE DATA refinery_images | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_images_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_page_part_translations | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_page_part_translations_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_page_parts | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_page_parts_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_page_translations | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_page_translations_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_pages | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_pages_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_resources | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_resources_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_roles | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_roles_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_roles_users | |
pg_restore: setting owner and privileges for TABLE DATA refinery_user_plugins | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_user_plugins_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA refinery_users | |
pg_restore: setting owner and privileges for SEQUENCE SET refinery_users_id_seq | |
pg_restore: setting owner and privileges for TABLE DATA schema_migrations | |
pg_restore: setting owner and privileges for TABLE DATA seo_meta | |
pg_restore: setting owner and privileges for SEQUENCE SET seo_meta_id_seq | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_images_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_page_part_translations_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_page_parts_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_page_translations_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_pages_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_resources_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_roles_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_user_plugins_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT refinery_users_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT schema_migrations_pkey | |
pg_restore: setting owner and privileges for CONSTRAINT seo_meta_pkey | |
pg_restore: setting owner and privileges for INDEX index_d079468f88bff1c6ea81573a0d019ba8bf5c2902 | |
pg_restore: setting owner and privileges for INDEX index_f9716c4215584edbca2557e32706a5ae084a15ef | |
pg_restore: setting owner and privileges for INDEX index_refinery_page_part_translations_on_locale | |
pg_restore: setting owner and privileges for INDEX index_refinery_page_parts_on_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_page_parts_on_refinery_page_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_page_translations_on_locale | |
pg_restore: setting owner and privileges for INDEX index_refinery_pages_on_depth | |
pg_restore: setting owner and privileges for INDEX index_refinery_pages_on_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_pages_on_lft | |
pg_restore: setting owner and privileges for INDEX index_refinery_pages_on_parent_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_pages_on_rgt | |
pg_restore: setting owner and privileges for INDEX index_refinery_roles_users_on_role_id_and_user_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_roles_users_on_user_id_and_role_id | |
pg_restore: setting owner and privileges for INDEX index_refinery_user_plugins_on_name | |
pg_restore: setting owner and privileges for INDEX index_refinery_user_plugins_on_user_id_and_name | |
pg_restore: setting owner and privileges for INDEX index_refinery_users_on_id | |
pg_restore: setting owner and privileges for INDEX index_seo_meta_on_id | |
pg_restore: setting owner and privileges for INDEX index_seo_meta_on_seo_meta_id_and_seo_meta_type | |
pg_restore: setting owner and privileges for INDEX unique_schema_migrations | |
WARNING: errors ignored on restore: 1 |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment