Skip to content

Instantly share code, notes, and snippets.

@jjcall
Created October 3, 2014 20:00
Show Gist options
  • Save jjcall/fe730fa4dd47b0b8da69 to your computer and use it in GitHub Desktop.
Save jjcall/fe730fa4dd47b0b8da69 to your computer and use it in GitHub Desktop.
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