search

Flink / dokku-psql-single-container

Plugin for dokku that provides a Postgresql server in a single container
MIT License
51 stars 9 forks source link

error when restoring into an app with a slightly different name #22

Open sglebs opened 8 years ago

sglebs commented 8 years ago

I use the app named softdispdjango-dev for development and then softdispdjango for demos. Do, I dumped the database from "softdispdjango-dev" and tried to restore into softdispdjango. Unfortunately I get errors:

vagrant@dokku-vagrant:~$ dokku psql:restore softdispdjango < /vagrant/softdispdjango-dev-2015-12-04.dump
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2013; 2606 16478 FK CONSTRAINT user_id_refs_id_c0d12874 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT user_id_refs_id_c0d12874;

pg_restore: [archiver (db)] Error from TOC entry 2021; 2606 16488 FK CONSTRAINT user_id_refs_id_4dc23c39 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT user_id_refs_id_4dc23c39;

pg_restore: [archiver (db)] Error from TOC entry 2019; 2606 16483 FK CONSTRAINT user_id_refs_id_40c41112 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT user_id_refs_id_40c41112;

pg_restore: [archiver (db)] Error from TOC entry 2025; 2606 16630 FK CONSTRAINT system_id_refs_id_c87b3e5b softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_healthsnapshot DROP CONSTRAINT system_id_refs_id_c87b3e5b;

pg_restore: [archiver (db)] Error from TOC entry 2026; 2606 16650 FK CONSTRAINT system_id_refs_id_743dd05c softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_newrelicsnapshot DROP CONSTRAINT system_id_refs_id_743dd05c;

pg_restore: [archiver (db)] Error from TOC entry 2023; 2606 16611 FK CONSTRAINT system_id_refs_id_53a5e0ae softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incident DROP CONSTRAINT system_id_refs_id_53a5e0ae;

pg_restore: [archiver (db)] Error from TOC entry 2022; 2606 16636 FK CONSTRAINT parent_id_refs_id_52ae967c softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_system DROP CONSTRAINT parent_id_refs_id_52ae967c;

pg_restore: [archiver (db)] Error from TOC entry 2024; 2606 16616 FK CONSTRAINT incident_id_refs_id_a42b464e softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incidentupdate DROP CONSTRAINT incident_id_refs_id_a42b464e;

pg_restore: [archiver (db)] Error from TOC entry 2017; 2606 16433 FK CONSTRAINT group_id_refs_id_f4b32aac softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT group_id_refs_id_f4b32aac;

pg_restore: [archiver (db)] Error from TOC entry 2027; 2606 16699 FK CONSTRAINT dashbo_client_system_id_54d93b3e0ad1525d_fk_dashboard_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashbo_client_system_id_54d93b3e0ad1525d_fk_dashboard_sys...
pg_restore: [archiver (db)] Error from TOC entry 2028; 2606 16704 FK CONSTRAINT dashb_service_system_id_3e039a9228c1383c_fk_dashboard_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashb_service_system_id_3e039a9228c1383c_fk_dashboard_sys...
pg_restore: [archiver (db)] Error from TOC entry 2015; 2606 16508 FK CONSTRAINT content_type_id_refs_id_d043b34a softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT content_type_id_refs_id_d043b34a;

pg_restore: [archiver (db)] Error from TOC entry 2014; 2606 16503 FK CONSTRAINT content_type_id_refs_id_93d2d1f8 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT content_type_id_refs_id_93d2d1f8;

pg_restore: [archiver (db)] Error from TOC entry 2020; 2606 16463 FK CONSTRAINT auth_user_user_permissions_permission_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_permission_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 2018; 2606 16448 FK CONSTRAINT auth_user_groups_group_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_group_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 2016; 2606 16418 FK CONSTRAINT auth_group_permissions_permission_id_fkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_permission_id_fkey;

pg_restore: [archiver (db)] Error from TOC entry 1989; 1259 16544 INDEX django_session_session_key_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_session_session_key_like" does not exist
    Command was: DROP INDEX public.django_session_session_key_like;

pg_restore: [archiver (db)] Error from TOC entry 1986; 1259 16545 INDEX django_session_expire_date softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_session_expire_date" does not exist
    Command was: DROP INDEX public.django_session_expire_date;

pg_restore: [archiver (db)] Error from TOC entry 1948; 1259 16533 INDEX django_admin_log_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_admin_log_user_id" does not exist
    Command was: DROP INDEX public.django_admin_log_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1945; 1259 16534 INDEX django_admin_log_content_type_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "django_admin_log_content_type_id" does not exist
    Command was: DROP INDEX public.django_admin_log_content_type_id;

pg_restore: [archiver (db)] Error from TOC entry 2010; 1259 16709 INDEX dashboard_systemdependency_cae6e9f0 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_systemdependency_cae6e9f0" does not exist
    Command was: DROP INDEX public.dashboard_systemdependency_cae6e9f0;

pg_restore: [archiver (db)] Error from TOC entry 2009; 1259 16710 INDEX dashboard_systemdependency_7dad87f4 softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_systemdependency_7dad87f4" does not exist
    Command was: DROP INDEX public.dashboard_systemdependency_7dad87f4;

pg_restore: [archiver (db)] Error from TOC entry 1992; 1259 16641 INDEX dashboard_system_parent_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_system_parent_id" does not exist
    Command was: DROP INDEX public.dashboard_system_parent_id;

pg_restore: [archiver (db)] Error from TOC entry 2006; 1259 16655 INDEX dashboard_newrelicsnapshot_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_newrelicsnapshot_system_id" does not exist
    Command was: DROP INDEX public.dashboard_newrelicsnapshot_system_id;

pg_restore: [archiver (db)] Error from TOC entry 1998; 1259 16621 INDEX dashboard_incidentupdate_incident_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_incidentupdate_incident_id" does not exist
    Command was: DROP INDEX public.dashboard_incidentupdate_incident_id;

pg_restore: [archiver (db)] Error from TOC entry 1997; 1259 16610 INDEX dashboard_incident_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_incident_system_id" does not exist
    Command was: DROP INDEX public.dashboard_incident_system_id;

pg_restore: [archiver (db)] Error from TOC entry 2003; 1259 16635 INDEX dashboard_healthsnapshot_system_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "dashboard_healthsnapshot_system_id" does not exist
    Command was: DROP INDEX public.dashboard_healthsnapshot_system_id;

pg_restore: [archiver (db)] Error from TOC entry 1981; 1259 16543 INDEX auth_user_username_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_username_like" does not exist
    Command was: DROP INDEX public.auth_user_username_like;

pg_restore: [archiver (db)] Error from TOC entry 1974; 1259 16541 INDEX auth_user_user_permissions_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_user_permissions_user_id" does not exist
    Command was: DROP INDEX public.auth_user_user_permissions_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1971; 1259 16542 INDEX auth_user_user_permissions_permission_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_user_permissions_permission_id" does not exist
    Command was: DROP INDEX public.auth_user_user_permissions_permission_id;

pg_restore: [archiver (db)] Error from TOC entry 1968; 1259 16539 INDEX auth_user_groups_user_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_groups_user_id" does not exist
    Command was: DROP INDEX public.auth_user_groups_user_id;

pg_restore: [archiver (db)] Error from TOC entry 1965; 1259 16540 INDEX auth_user_groups_group_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_user_groups_group_id" does not exist
    Command was: DROP INDEX public.auth_user_groups_group_id;

pg_restore: [archiver (db)] Error from TOC entry 1949; 1259 16535 INDEX auth_permission_content_type_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_permission_content_type_id" does not exist
    Command was: DROP INDEX public.auth_permission_content_type_id;

pg_restore: [archiver (db)] Error from TOC entry 1957; 1259 16537 INDEX auth_group_permissions_permission_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_permissions_permission_id" does not exist
    Command was: DROP INDEX public.auth_group_permissions_permission_id;

pg_restore: [archiver (db)] Error from TOC entry 1954; 1259 16536 INDEX auth_group_permissions_group_id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_permissions_group_id" does not exist
    Command was: DROP INDEX public.auth_group_permissions_group_id;

pg_restore: [archiver (db)] Error from TOC entry 1962; 1259 16538 INDEX auth_group_name_like softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  index "auth_group_name_like" does not exist
    Command was: DROP INDEX public.auth_group_name_like;

pg_restore: [archiver (db)] Error from TOC entry 1991; 2606 16531 CONSTRAINT south_migrationhistory_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.south_migrationhistory" does not exist
    Command was: ALTER TABLE ONLY public.south_migrationhistory DROP CONSTRAINT south_migrationhistory_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1988; 2606 16520 CONSTRAINT django_session_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_session" does not exist
    Command was: ALTER TABLE ONLY public.django_session DROP CONSTRAINT django_session_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2008; 2606 16675 CONSTRAINT django_migrations_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_migrations" does not exist
    Command was: ALTER TABLE ONLY public.django_migrations DROP CONSTRAINT django_migrations_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1985; 2606 16500 CONSTRAINT django_content_type_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1983; 2606 16502 CONSTRAINT django_content_type_app_label_model_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE ONLY public.django_content_type DROP CONSTRAINT django_content_type_app_label_model_key;

pg_restore: [archiver (db)] Error from TOC entry 1947; 2606 16397 CONSTRAINT django_admin_log_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE ONLY public.django_admin_log DROP CONSTRAINT django_admin_log_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1994; 2606 16570 CONSTRAINT dashboard_systemstatus_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_system DROP CONSTRAINT dashboard_systemstatus_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2012; 2606 16698 CONSTRAINT dashboard_systemdependency_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_systemdependency DROP CONSTRAINT dashboard_systemdependency_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2005; 2606 16649 CONSTRAINT dashboard_newrelicsnapshot_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_newrelicsnapshot DROP CONSTRAINT dashboard_newrelicsnapshot_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2000; 2606 16609 CONSTRAINT dashboard_incidentupdate_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incidentupdate DROP CONSTRAINT dashboard_incidentupdate_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1996; 2606 16587 CONSTRAINT dashboard_incident_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_incident DROP CONSTRAINT dashboard_incident_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2002; 2606 16629 CONSTRAINT dashboard_healthsnapshot_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE ONLY public.dashboard_healthsnapshot DROP CONSTRAINT dashboard_healthsnapshot_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1980; 2606 16477 CONSTRAINT auth_user_username_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_username_key;

pg_restore: [archiver (db)] Error from TOC entry 1976; 2606 16462 CONSTRAINT auth_user_user_permissions_user_id_permission_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_user_id_permission_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1973; 2606 16460 CONSTRAINT auth_user_user_permissions_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_user_permissions DROP CONSTRAINT auth_user_user_permissions_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1978; 2606 16475 CONSTRAINT auth_user_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE ONLY public.auth_user DROP CONSTRAINT auth_user_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1970; 2606 16447 CONSTRAINT auth_user_groups_user_id_group_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_user_id_group_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1967; 2606 16445 CONSTRAINT auth_user_groups_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE ONLY public.auth_user_groups DROP CONSTRAINT auth_user_groups_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1953; 2606 16405 CONSTRAINT auth_permission_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1951; 2606 16407 CONSTRAINT auth_permission_content_type_id_codename_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE ONLY public.auth_permission DROP CONSTRAINT auth_permission_content_type_id_codename_key;

pg_restore: [archiver (db)] Error from TOC entry 1964; 2606 16430 CONSTRAINT auth_group_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1959; 2606 16415 CONSTRAINT auth_group_permissions_pkey softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_pkey;

pg_restore: [archiver (db)] Error from TOC entry 1956; 2606 16417 CONSTRAINT auth_group_permissions_group_id_permission_id_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE ONLY public.auth_group_permissions DROP CONSTRAINT auth_group_permissions_group_id_permission_id_key;

pg_restore: [archiver (db)] Error from TOC entry 1961; 2606 16432 CONSTRAINT auth_group_name_key softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE ONLY public.auth_group DROP CONSTRAINT auth_group_name_key;

pg_restore: [archiver (db)] Error from TOC entry 1937; 2604 16526 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.south_migrationhistory" does not exist
    Command was: ALTER TABLE public.south_migrationhistory ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1943; 2604 16670 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_migrations" does not exist
    Command was: ALTER TABLE public.django_migrations ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1936; 2604 16498 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_content_type" does not exist
    Command was: ALTER TABLE public.django_content_type ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1928; 2604 16391 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.django_admin_log" does not exist
    Command was: ALTER TABLE public.django_admin_log ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1944; 2604 16696 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_systemdependency" does not exist
    Command was: ALTER TABLE public.dashboard_systemdependency ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1938; 2604 16568 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_system" does not exist
    Command was: ALTER TABLE public.dashboard_system ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1942; 2604 16647 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_newrelicsnapshot" does not exist
    Command was: ALTER TABLE public.dashboard_newrelicsnapshot ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1940; 2604 16604 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incidentupdate" does not exist
    Command was: ALTER TABLE public.dashboard_incidentupdate ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1939; 2604 16582 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_incident" does not exist
    Command was: ALTER TABLE public.dashboard_incident ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1941; 2604 16627 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.dashboard_healthsnapshot" does not exist
    Command was: ALTER TABLE public.dashboard_healthsnapshot ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1934; 2604 16458 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_user_permissions" does not exist
    Command was: ALTER TABLE public.auth_user_user_permissions ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1933; 2604 16443 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user_groups" does not exist
    Command was: ALTER TABLE public.auth_user_groups ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1935; 2604 16473 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_user" does not exist
    Command was: ALTER TABLE public.auth_user ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1930; 2604 16403 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_permission" does not exist
    Command was: ALTER TABLE public.auth_permission ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1931; 2604 16413 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group_permissions" does not exist
    Command was: ALTER TABLE public.auth_group_permissions ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 1932; 2604 16428 DEFAULT id softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "public.auth_group" does not exist
    Command was: ALTER TABLE public.auth_group ALTER COLUMN id DROP DEFAULT;

pg_restore: [archiver (db)] Error from TOC entry 187; 1259 16521 SEQUENCE south_migrationhistory_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "south_migrationhistory_id_seq" does not exist
    Command was: DROP SEQUENCE public.south_migrationhistory_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 188; 1259 16523 TABLE south_migrationhistory softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "south_migrationhistory" does not exist
    Command was: DROP TABLE public.south_migrationhistory;

pg_restore: [archiver (db)] Error from TOC entry 186; 1259 16513 TABLE django_session softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_session" does not exist
    Command was: DROP TABLE public.django_session;

pg_restore: [archiver (db)] Error from TOC entry 199; 1259 16665 SEQUENCE django_migrations_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_migrations_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_migrations_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 200; 1259 16667 TABLE django_migrations softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_migrations" does not exist
    Command was: DROP TABLE public.django_migrations;

pg_restore: [archiver (db)] Error from TOC entry 184; 1259 16493 SEQUENCE django_content_type_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_content_type_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_content_type_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 185; 1259 16495 TABLE django_content_type softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_content_type" does not exist
    Command was: DROP TABLE public.django_content_type;

pg_restore: [archiver (db)] Error from TOC entry 170; 1259 16386 SEQUENCE django_admin_log_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "django_admin_log_id_seq" does not exist
    Command was: DROP SEQUENCE public.django_admin_log_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 171; 1259 16388 TABLE django_admin_log softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "django_admin_log" does not exist
    Command was: DROP TABLE public.django_admin_log;

pg_restore: [archiver (db)] Error from TOC entry 201; 1259 16691 SEQUENCE dashboard_systemdependency_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_systemdependency_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_systemdependency_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 202; 1259 16693 TABLE dashboard_systemdependency softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_systemdependency" does not exist
    Command was: DROP TABLE public.dashboard_systemdependency;

pg_restore: [archiver (db)] Error from TOC entry 189; 1259 16563 SEQUENCE dashboard_system_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_system_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_system_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 190; 1259 16565 TABLE dashboard_system softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_system" does not exist
    Command was: DROP TABLE public.dashboard_system;

pg_restore: [archiver (db)] Error from TOC entry 197; 1259 16642 SEQUENCE dashboard_newrelicsnapshot_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_newrelicsnapshot_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_newrelicsnapshot_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 198; 1259 16644 TABLE dashboard_newrelicsnapshot softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_newrelicsnapshot" does not exist
    Command was: DROP TABLE public.dashboard_newrelicsnapshot;

pg_restore: [archiver (db)] Error from TOC entry 193; 1259 16599 SEQUENCE dashboard_incidentupdate_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_incidentupdate_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_incidentupdate_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 194; 1259 16601 TABLE dashboard_incidentupdate softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_incidentupdate" does not exist
    Command was: DROP TABLE public.dashboard_incidentupdate;

pg_restore: [archiver (db)] Error from TOC entry 191; 1259 16577 SEQUENCE dashboard_incident_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_incident_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_incident_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 192; 1259 16579 TABLE dashboard_incident softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_incident" does not exist
    Command was: DROP TABLE public.dashboard_incident;

pg_restore: [archiver (db)] Error from TOC entry 195; 1259 16622 SEQUENCE dashboard_healthsnapshot_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "dashboard_healthsnapshot_id_seq" does not exist
    Command was: DROP SEQUENCE public.dashboard_healthsnapshot_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 196; 1259 16624 TABLE dashboard_healthsnapshot softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "dashboard_healthsnapshot" does not exist
    Command was: DROP TABLE public.dashboard_healthsnapshot;

pg_restore: [archiver (db)] Error from TOC entry 180; 1259 16453 SEQUENCE auth_user_user_permissions_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_user_permissions_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_user_permissions_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 181; 1259 16455 TABLE auth_user_user_permissions softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user_user_permissions" does not exist
    Command was: DROP TABLE public.auth_user_user_permissions;

pg_restore: [archiver (db)] Error from TOC entry 182; 1259 16468 SEQUENCE auth_user_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 178; 1259 16438 SEQUENCE auth_user_groups_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_user_groups_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_user_groups_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 179; 1259 16440 TABLE auth_user_groups softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user_groups" does not exist
    Command was: DROP TABLE public.auth_user_groups;

pg_restore: [archiver (db)] Error from TOC entry 183; 1259 16470 TABLE auth_user softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_user" does not exist
    Command was: DROP TABLE public.auth_user;

pg_restore: [archiver (db)] Error from TOC entry 172; 1259 16398 SEQUENCE auth_permission_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_permission_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_permission_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 173; 1259 16400 TABLE auth_permission softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_permission" does not exist
    Command was: DROP TABLE public.auth_permission;

pg_restore: [archiver (db)] Error from TOC entry 174; 1259 16408 SEQUENCE auth_group_permissions_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_group_permissions_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_group_permissions_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 175; 1259 16410 TABLE auth_group_permissions softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_group_permissions" does not exist
    Command was: DROP TABLE public.auth_group_permissions;

pg_restore: [archiver (db)] Error from TOC entry 176; 1259 16423 SEQUENCE auth_group_id_seq softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  sequence "auth_group_id_seq" does not exist
    Command was: DROP SEQUENCE public.auth_group_id_seq;

pg_restore: [archiver (db)] Error from TOC entry 177; 1259 16425 TABLE auth_group softdispdjango_dev
pg_restore: [archiver (db)] could not execute query: ERROR:  table "auth_group" does not exist
    Command was: DROP TABLE public.auth_group;

pg_restore: [archiver (db)] Error from TOC entry 203; 3079 11756 EXTENSION plpgsql 
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension plpgsql
    Command was: DROP EXTENSION plpgsql;

pg_restore: [archiver (db)] Error from TOC entry 5; 2615 2200 SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of schema public
    Command was: DROP SCHEMA public;

pg_restore: [archiver (db)] could not execute query: ERROR:  schema "public" already exists
    Command was: CREATE SCHEMA public;

pg_restore: [archiver (db)] Error from TOC entry 2174; 0 0 COMMENT SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of schema public
    Command was: COMMENT ON SCHEMA public IS 'standard public schema';

pg_restore: [archiver (db)] Error from TOC entry 2175; 0 0 COMMENT EXTENSION plpgsql 
pg_restore: [archiver (db)] could not execute query: ERROR:  must be owner of extension plpgsql
    Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';

WARNING: errors ignored on restore: 114

Is there a way to override the user/owner?

Flink commented 8 years ago 
WARNING: errors ignored on restore: 114

I think those errors are non fatal and your dump has been in fact restored. (I always have this kind of errors when restoring)

Flink commented 8 years ago

But I can only guarantee the dump/restore work correctly if you have dumped with a similar command than the one used by the plugin (it’s what Heroku does too).

sglebs commented 8 years ago

The dump was made with your plugin. Indeed it seems to work despite all warnings.