Anyone restore from one database to another before?

2,248 views

Skip to first unread message

Matthew Yauch

unread,

Oct 25, 2017, 7:48:22 PM10/25/17

to NetBox

I had a standalone Netbox install running for quite a while with postgres 9.2.23. Decided to mess with getting it into Docker with postgres 9.6.5 and both 1. dumping the database to a data file and importing it and 2. doing a direct dump from one server directly into the other does not complete with 100% data retention. After one import it had some items. After a second it had more. After a third it had even more, but now more will not populate.

I am currently missing all of my IP addresses, devices, and interfaces. I *believe* everything else is in there.

Any ideas? Below is my pg_dumpall | psql output. It looks like a bunch of foreign key constraints are getting violated, almost like a chicken or the egg?

/ # pg_dumpall -p 5432 -U postgres -h myoldserverhostname.example.com| psql -p 5432 -U postgres

SET

ERROR: role "netbox" already exists

ALTER ROLE

ERROR: role "postgres" already exists

ALTER ROLE

ERROR: database "netbox" already exists

REVOKE

GRANT

REVOKE

GRANT

You are now connected to database "netbox" as user "postgres".

SET

CREATE EXTENSION

COMMENT

SET

ERROR: relation "auth_group" already exists

ALTER TABLE

ERROR: relation "auth_group_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "auth_group_permissions" already exists

ALTER TABLE

ERROR: relation "auth_group_permissions_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "auth_permission" already exists

ALTER TABLE

ERROR: relation "auth_permission_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "auth_user" already exists

ALTER TABLE

ERROR: relation "auth_user_groups" already exists

ALTER TABLE

ERROR: relation "auth_user_groups_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "auth_user_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "auth_user_user_permissions" already exists

ALTER TABLE

ERROR: relation "auth_user_user_permissions_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "circuits_circuit" already exists

ALTER TABLE

ERROR: relation "circuits_circuit_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "circuits_circuittermination" already exists

ALTER TABLE

ERROR: relation "circuits_circuittermination_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "circuits_circuittype" already exists

ALTER TABLE

ERROR: relation "circuits_circuittype_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "circuits_provider" already exists

ALTER TABLE

ERROR: relation "circuits_provider_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_consoleport" already exists

ALTER TABLE

ERROR: relation "dcim_consoleport_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_consoleporttemplate" already exists

ALTER TABLE

ERROR: relation "dcim_consoleporttemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_consoleserverport" already exists

ALTER TABLE

ERROR: relation "dcim_consoleserverport_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_consoleserverporttemplate" already exists

ALTER TABLE

ERROR: relation "dcim_consoleserverporttemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_device" already exists

ALTER TABLE

ERROR: relation "dcim_device_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_devicebay" already exists

ALTER TABLE

ERROR: relation "dcim_devicebay_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_devicebaytemplate" already exists

ALTER TABLE

ERROR: relation "dcim_devicebaytemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_devicerole" already exists

ALTER TABLE

ERROR: relation "dcim_devicerole_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_devicetype" already exists

ALTER TABLE

ERROR: relation "dcim_devicetype_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_interface" already exists

ALTER TABLE

ERROR: relation "dcim_interface_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_interfaceconnection" already exists

ALTER TABLE

ERROR: relation "dcim_interfaceconnection_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_interfacetemplate" already exists

ALTER TABLE

ERROR: relation "dcim_interfacetemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_inventoryitem" already exists

ALTER TABLE

ERROR: relation "dcim_manufacturer" already exists

ALTER TABLE

ERROR: relation "dcim_manufacturer_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_module_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_platform" already exists

ALTER TABLE

ERROR: relation "dcim_platform_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_poweroutlet" already exists

ALTER TABLE

ERROR: relation "dcim_poweroutlet_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_poweroutlettemplate" already exists

ALTER TABLE

ERROR: relation "dcim_poweroutlettemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_powerport" already exists

ALTER TABLE

ERROR: relation "dcim_powerport_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_powerporttemplate" already exists

ALTER TABLE

ERROR: relation "dcim_powerporttemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_rack" already exists

ALTER TABLE

ERROR: relation "dcim_rack_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_rackgroup" already exists

ALTER TABLE

ERROR: relation "dcim_rackgroup_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_rackreservation" already exists

ALTER TABLE

ERROR: relation "dcim_rackreservation_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_rackrole" already exists

ALTER TABLE

ERROR: relation "dcim_rackrole_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_region" already exists

ALTER TABLE

ERROR: relation "dcim_region_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "dcim_site" already exists

ALTER TABLE

ERROR: relation "dcim_site_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "django_admin_log" already exists

ALTER TABLE

ERROR: relation "django_admin_log_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "django_content_type" already exists

ALTER TABLE

ERROR: relation "django_content_type_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "django_migrations" already exists

ALTER TABLE

ERROR: relation "django_migrations_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "django_session" already exists

ALTER TABLE

ERROR: relation "extras_customfield" already exists

ALTER TABLE

ERROR: relation "extras_customfield_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_customfield_obj_type" already exists

ALTER TABLE

ERROR: relation "extras_customfield_obj_type_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_customfieldchoice" already exists

ALTER TABLE

ERROR: relation "extras_customfieldchoice_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_customfieldvalue" already exists

ALTER TABLE

ERROR: relation "extras_customfieldvalue_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_exporttemplate" already exists

ALTER TABLE

ERROR: relation "extras_exporttemplate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_graph" already exists

ALTER TABLE

ERROR: relation "extras_graph_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_imageattachment" already exists

ALTER TABLE

ERROR: relation "extras_imageattachment_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_topologymap" already exists

ALTER TABLE

ERROR: relation "extras_topologymap_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "extras_useraction" already exists

ALTER TABLE

ERROR: relation "extras_useraction_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_aggregate" already exists

ALTER TABLE

ERROR: relation "ipam_aggregate_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_ipaddress" already exists

ALTER TABLE

ERROR: relation "ipam_ipaddress_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_prefix" already exists

ALTER TABLE

ERROR: relation "ipam_prefix_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_rir" already exists

ALTER TABLE

ERROR: relation "ipam_rir_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_role" already exists

ALTER TABLE

ERROR: relation "ipam_role_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_service" already exists

ALTER TABLE

ERROR: relation "ipam_service_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_service_ipaddresses" already exists

ALTER TABLE

ERROR: relation "ipam_service_ipaddresses_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_vlan" already exists

ALTER TABLE

ERROR: relation "ipam_vlan_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_vlangroup" already exists

ALTER TABLE

ERROR: relation "ipam_vlangroup_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "ipam_vrf" already exists

ALTER TABLE

ERROR: relation "ipam_vrf_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_secret" already exists

ALTER TABLE

ERROR: relation "secrets_secret_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_secretrole" already exists

ALTER TABLE

ERROR: relation "secrets_secretrole_groups" already exists

ALTER TABLE

ERROR: relation "secrets_secretrole_groups_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_secretrole_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_secretrole_users" already exists

ALTER TABLE

ERROR: relation "secrets_secretrole_users_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_sessionkey" already exists

ALTER TABLE

ERROR: relation "secrets_sessionkey_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "secrets_userkey" already exists

ALTER TABLE

ERROR: relation "secrets_userkey_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "tenancy_tenant" already exists

ALTER TABLE

ERROR: relation "tenancy_tenant_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "tenancy_tenantgroup" already exists

ALTER TABLE

ERROR: relation "tenancy_tenantgroup_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "users_token" already exists

ALTER TABLE

ERROR: relation "users_token_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "virtualization_cluster" already exists

ALTER TABLE

ERROR: relation "virtualization_cluster_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "virtualization_clustergroup" already exists

ALTER TABLE

ERROR: relation "virtualization_clustergroup_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "virtualization_clustertype" already exists

ALTER TABLE

ERROR: relation "virtualization_clustertype_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ERROR: relation "virtualization_virtualmachine" already exists

ALTER TABLE

ERROR: relation "virtualization_virtualmachine_id_seq" already exists

ALTER TABLE

ALTER SEQUENCE

ALTER TABLE

ERROR: duplicate key value violates unique constraint "auth_group_pkey"

DETAIL: Key (id)=(2) already exists.

CONTEXT: COPY auth_group, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "auth_group_permissions_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY auth_group_permissions, line 1

setval

--------

308

(1 row)

ERROR: duplicate key value violates unique constraint "auth_permission_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY auth_permission, line 1

setval

--------

178

(1 row)

ERROR: duplicate key value violates unique constraint "auth_user_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY auth_user, line 3

ERROR: insert or update on table "auth_user_groups" violates foreign key constraint "auth_user_groups_user_id_6a12ed8b_fk_auth_user_id"

DETAIL: Key (user_id)=(9) is not present in table "auth_user".

setval

--------

(1 row)

setval

--------

(1 row)

ERROR: insert or update on table "auth_user_user_permissions" violates foreign key constraint "auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id"

DETAIL: Key (user_id)=(2) is not present in table "auth_user".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "circuits_circuit_pkey"

DETAIL: Key (id)=(49) already exists.

CONTEXT: COPY circuits_circuit, line 1

setval

--------

(1 row)

ERROR: insert or update on table "circuits_circuittermination" violates foreign key constraint "circuits_circuitterm_interface_id_a147755f_fk_dcim_inte"

DETAIL: Key (interface_id)=(3) is not present in table "dcim_interface".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "circuits_circuittype_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY circuits_circuittype, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "circuits_provider_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY circuits_provider, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: insert or update on table "dcim_device" violates foreign key constraint "dcim_device_primary_ip4_id_2ccd943a_fk_ipam_ipaddress_id"

DETAIL: Key (primary_ip4_id)=(26) is not present in table "ipam_ipaddress".

setval

--------

311

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_devicerole_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_devicerole, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_devicetype_pkey"

DETAIL: Key (id)=(2) already exists.

CONTEXT: COPY dcim_devicetype, line 1

setval

--------

(1 row)

ERROR: insert or update on table "dcim_interface" violates foreign key constraint "dcim_interface_device_id_359c6115_fk_dcim_device_id"

DETAIL: Key (device_id)=(2) is not present in table "dcim_device".

setval

--------

154

(1 row)

ERROR: insert or update on table "dcim_interfaceconnection" violates foreign key constraint "dcim_interfaceconnec_interface_a_id_503f46c2_fk_dcim_inte"

DETAIL: Key (interface_a_id)=(24) is not present in table "dcim_interface".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_interfacetemplate_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_interfacetemplate, line 1

setval

--------

(1 row)

ERROR: insert or update on table "dcim_inventoryitem" violates foreign key constraint "dcim_inventoryitem_device_id_033d83f8_fk_dcim_device_id"

DETAIL: Key (device_id)=(4) is not present in table "dcim_device".

ERROR: duplicate key value violates unique constraint "dcim_manufacturer_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_manufacturer, line 1

setval

--------

(1 row)

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_platform_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_platform, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_rack_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_rack, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_rackgroup_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY dcim_rackgroup, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "dcim_site_pkey"

DETAIL: Key (id)=(27) already exists.

CONTEXT: COPY dcim_site, line 1

setval

--------

(1 row)

ERROR: insert or update on table "django_admin_log" violates foreign key constraint "django_admin_log_user_id_c564eba6_fk_auth_user_id"

DETAIL: Key (user_id)=(3) is not present in table "auth_user".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "django_content_type_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY django_content_type, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "django_migrations_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY django_migrations, line 1

setval

--------

102

(1 row)

ERROR: duplicate key value violates unique constraint "django_session_pkey"

DETAIL: Key (session_key)=(r57i2x32uh5qo0yixf4lw4mpkgeewcaa) already exists.

CONTEXT: COPY django_session, line 1

ERROR: duplicate key value violates unique constraint "extras_customfield_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY extras_customfield, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "extras_customfield_obj_type_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY extras_customfield_obj_type, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "extras_customfieldchoice_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY extras_customfieldchoice, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "extras_customfieldvalue_pkey"

DETAIL: Key (id)=(30) already exists.

CONTEXT: COPY extras_customfieldvalue, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "extras_imageattachment_pkey"

DETAIL: Key (id)=(2) already exists.

CONTEXT: COPY extras_imageattachment, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: insert or update on table "extras_useraction" violates foreign key constraint "extras_useraction_user_id_8aacec56_fk_auth_user_id"

DETAIL: Key (user_id)=(6) is not present in table "auth_user".

setval

--------

724

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_aggregate_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY ipam_aggregate, line 1

setval

--------

(1 row)

ERROR: insert or update on table "ipam_ipaddress" violates foreign key constraint "ipam_ipaddress_interface_id_91e71d9d_fk_dcim_interface_id"

DETAIL: Key (interface_id)=(2) is not present in table "dcim_interface".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_prefix_pkey"

DETAIL: Key (id)=(294) already exists.

CONTEXT: COPY ipam_prefix, line 1

setval

--------

300

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_rir_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY ipam_rir, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_role_pkey"

DETAIL: Key (id)=(2) already exists.

CONTEXT: COPY ipam_role, line 1

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_vlan_pkey"

DETAIL: Key (id)=(4) already exists.

CONTEXT: COPY ipam_vlan, line 1

setval

--------

252

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_vlangroup_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY ipam_vlangroup, line 1

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "ipam_vrf_pkey"

DETAIL: Key (id)=(34) already exists.

CONTEXT: COPY ipam_vrf, line 1

setval

--------

(1 row)

ERROR: insert or update on table "secrets_secret" violates foreign key constraint "secrets_secret_device_id_c7c13124_fk_dcim_device_id"

DETAIL: Key (device_id)=(8) is not present in table "dcim_device".

setval

--------

(1 row)

ERROR: duplicate key value violates unique constraint "secrets_secretrole_pkey"

DETAIL: Key (id)=(1) already exists.

CONTEXT: COPY secrets_secretrole, line 1

COPY 0

setval

--------

(1 row)

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: insert or update on table "secrets_userkey" violates foreign key constraint "secrets_userkey_user_id_13ada46b_fk_auth_user_id"

DETAIL: Key (user_id)=(3) is not present in table "auth_user".

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: insert or update on table "users_token" violates foreign key constraint "users_token_user_id_af964690_fk_auth_user_id"

DETAIL: Key (user_id)=(9) is not present in table "auth_user".

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

COPY 0

setval

--------

(1 row)

ERROR: relation "auth_group_name_key" already exists

ERROR: relation "auth_group_permissions_group_id_0cd325b0_uniq" already exists

ERROR: multiple primary keys for table "auth_group_permissions" are not allowed

ERROR: multiple primary keys for table "auth_group" are not allowed

ERROR: relation "auth_permission_content_type_id_01ab375a_uniq" already exists

ERROR: multiple primary keys for table "auth_permission" are not allowed

ERROR: multiple primary keys for table "auth_user_groups" are not allowed

ERROR: relation "auth_user_groups_user_id_94350c0c_uniq" already exists

ERROR: multiple primary keys for table "auth_user" are not allowed

ERROR: multiple primary keys for table "auth_user_user_permissions" are not allowed

ERROR: relation "auth_user_user_permissions_user_id_14a6b632_uniq" already exists

ERROR: relation "auth_user_username_key" already exists

ERROR: multiple primary keys for table "circuits_circuit" are not allowed

ERROR: relation "circuits_circuit_provider_id_b6f29862_uniq" already exists

ERROR: relation "circuits_circuittermination_circuit_id_b13efd0e_uniq" already exists

ERROR: relation "circuits_circuittermination_interface_id_key" already exists

ERROR: multiple primary keys for table "circuits_circuittermination" are not allowed

ERROR: relation "circuits_circuittype_name_key" already exists

ERROR: multiple primary keys for table "circuits_circuittype" are not allowed

ERROR: relation "circuits_circuittype_slug_key" already exists

ERROR: relation "circuits_provider_name_key" already exists

ERROR: multiple primary keys for table "circuits_provider" are not allowed

ERROR: relation "circuits_provider_slug_key" already exists

ERROR: relation "dcim_consoleport_cs_port_id_key" already exists

ERROR: relation "dcim_consoleport_device_id_293786b6_uniq" already exists

ERROR: multiple primary keys for table "dcim_consoleport" are not allowed

ERROR: relation "dcim_consoleporttemplate_device_type_id_8208f9ca_uniq" already exists

ERROR: multiple primary keys for table "dcim_consoleporttemplate" are not allowed

ERROR: relation "dcim_consoleserverport_device_id_fb1c5999_uniq" already exists

ERROR: multiple primary keys for table "dcim_consoleserverport" are not allowed

ERROR: relation "dcim_consoleserverporttemplate_device_type_id_a05c974d_uniq" already exists

ERROR: multiple primary keys for table "dcim_consoleserverporttemplate" are not allowed

ERROR: relation "dcim_device_asset_tag_key" already exists

ERROR: relation "dcim_device_name_key" already exists

ERROR: multiple primary keys for table "dcim_device" are not allowed

ERROR: relation "dcim_device_primary_ip4_id_key" already exists

ERROR: relation "dcim_device_primary_ip6_id_key" already exists

ERROR: relation "dcim_device_rack_id_43208a79_uniq" already exists

ERROR: relation "dcim_devicebay_device_id_2475a67b_uniq" already exists

ERROR: relation "dcim_devicebay_installed_device_id_key" already exists

ERROR: multiple primary keys for table "dcim_devicebay" are not allowed

ERROR: relation "dcim_devicebaytemplate_device_type_id_8f4899fe_uniq" already exists

ERROR: multiple primary keys for table "dcim_devicebaytemplate" are not allowed

ERROR: relation "dcim_devicerole_name_key" already exists

ERROR: multiple primary keys for table "dcim_devicerole" are not allowed

ERROR: relation "dcim_devicerole_slug_key" already exists

ERROR: relation "dcim_devicetype_manufacturer_id_17948c0c_uniq" already exists

ERROR: relation "dcim_devicetype_manufacturer_id_a0b931cb_uniq" already exists

ERROR: multiple primary keys for table "dcim_devicetype" are not allowed

ERROR: relation "dcim_interface_device_id_bffc4ec4_uniq" already exists

ERROR: multiple primary keys for table "dcim_interface" are not allowed

ERROR: relation "dcim_interfaceconnection_interface_a_id_key" already exists

ERROR: relation "dcim_interfaceconnection_interface_b_id_key" already exists

ERROR: multiple primary keys for table "dcim_interfaceconnection" are not allowed

ERROR: relation "dcim_interfacetemplate_device_type_id_3a847237_uniq" already exists

ERROR: multiple primary keys for table "dcim_interfacetemplate" are not allowed

ERROR: relation "dcim_inventoryitem_asset_tag_key" already exists

ERROR: relation "dcim_manufacturer_name_key" already exists

ERROR: multiple primary keys for table "dcim_manufacturer" are not allowed

ERROR: relation "dcim_manufacturer_slug_key" already exists

ERROR: relation "dcim_module_device_id_4d8292af_uniq" already exists

ERROR: multiple primary keys for table "dcim_inventoryitem" are not allowed

ERROR: relation "dcim_platform_name_key" already exists

ERROR: multiple primary keys for table "dcim_platform" are not allowed

ERROR: relation "dcim_platform_slug_key" already exists

ERROR: relation "dcim_poweroutlet_device_id_981b00c1_uniq" already exists

ERROR: multiple primary keys for table "dcim_poweroutlet" are not allowed

ERROR: relation "dcim_poweroutlettemplate_device_type_id_eafbb07d_uniq" already exists

ERROR: multiple primary keys for table "dcim_poweroutlettemplate" are not allowed

ERROR: relation "dcim_powerport_device_id_948af82c_uniq" already exists

ERROR: multiple primary keys for table "dcim_powerport" are not allowed

ERROR: relation "dcim_powerport_power_outlet_id_key" already exists

ERROR: relation "dcim_powerporttemplate_device_type_id_b4e9689f_uniq" already exists

ERROR: multiple primary keys for table "dcim_powerporttemplate" are not allowed

ERROR: multiple primary keys for table "dcim_rack" are not allowed

ERROR: relation "dcim_rack_site_id_2a1d0860_uniq" already exists

ERROR: relation "dcim_rack_site_id_5fde0119_uniq" already exists

ERROR: multiple primary keys for table "dcim_rackgroup" are not allowed

ERROR: relation "dcim_rackgroup_site_id_7fbfd118_uniq" already exists

ERROR: relation "dcim_rackgroup_site_id_c9bd921f_uniq" already exists

ERROR: multiple primary keys for table "dcim_rackreservation" are not allowed

ERROR: relation "dcim_rackrole_name_key" already exists

ERROR: multiple primary keys for table "dcim_rackrole" are not allowed

ERROR: relation "dcim_rackrole_slug_key" already exists

ERROR: relation "dcim_region_name_key" already exists

ERROR: multiple primary keys for table "dcim_region" are not allowed

ERROR: relation "dcim_region_slug_key" already exists

ERROR: relation "dcim_site_name_key" already exists

ERROR: multiple primary keys for table "dcim_site" are not allowed

ERROR: relation "dcim_site_slug_key" already exists

ERROR: multiple primary keys for table "django_admin_log" are not allowed

ERROR: relation "django_content_type_app_label_76bd3d3b_uniq" already exists

ERROR: multiple primary keys for table "django_content_type" are not allowed

ERROR: multiple primary keys for table "django_migrations" are not allowed

ERROR: multiple primary keys for table "django_session" are not allowed

ERROR: relation "extras_customfield_name_key" already exists

ERROR: relation "extras_customfield_obj_type_customfield_id_77878958_uniq" already exists

ERROR: multiple primary keys for table "extras_customfield_obj_type" are not allowed

ERROR: multiple primary keys for table "extras_customfield" are not allowed

ERROR: relation "extras_customfieldchoice_field_id_f959a108_uniq" already exists

ERROR: multiple primary keys for table "extras_customfieldchoice" are not allowed

ERROR: relation "extras_customfieldvalue_field_id_876f6d9c_uniq" already exists

ERROR: multiple primary keys for table "extras_customfieldvalue" are not allowed

ERROR: relation "extras_exporttemplate_content_type_id_edca9b9b_uniq" already exists

ERROR: multiple primary keys for table "extras_exporttemplate" are not allowed

ERROR: multiple primary keys for table "extras_graph" are not allowed

ERROR: multiple primary keys for table "extras_imageattachment" are not allowed

ERROR: relation "extras_topologymap_name_key" already exists

ERROR: multiple primary keys for table "extras_topologymap" are not allowed

ERROR: relation "extras_topologymap_slug_key" already exists

ERROR: multiple primary keys for table "extras_useraction" are not allowed

ERROR: multiple primary keys for table "ipam_aggregate" are not allowed

ERROR: relation "ipam_ipaddress_nat_inside_id_key" already exists

ERROR: multiple primary keys for table "ipam_ipaddress" are not allowed

ERROR: multiple primary keys for table "ipam_prefix" are not allowed

ERROR: relation "ipam_rir_name_key" already exists

ERROR: multiple primary keys for table "ipam_rir" are not allowed

ERROR: relation "ipam_rir_slug_key" already exists

ERROR: relation "ipam_role_name_key" already exists

ERROR: multiple primary keys for table "ipam_role" are not allowed

ERROR: relation "ipam_role_slug_key" already exists

ERROR: multiple primary keys for table "ipam_service_ipaddresses" are not allowed

ERROR: relation "ipam_service_ipaddresses_service_id_d019a805_uniq" already exists

ERROR: multiple primary keys for table "ipam_service" are not allowed

ERROR: relation "ipam_vlan_group_id_5ca4cc47_uniq" already exists

ERROR: relation "ipam_vlan_group_id_e53919df_uniq" already exists

ERROR: multiple primary keys for table "ipam_vlan" are not allowed

ERROR: multiple primary keys for table "ipam_vlangroup" are not allowed

ERROR: relation "ipam_vlangroup_site_id_6372a304_uniq" already exists

ERROR: relation "ipam_vlangroup_site_id_a38e981b_uniq" already exists

ERROR: multiple primary keys for table "ipam_vrf" are not allowed

ERROR: relation "ipam_vrf_rd_key" already exists

ERROR: relation "secrets_secret_device_id_f8acc218_uniq" already exists

ERROR: multiple primary keys for table "secrets_secret" are not allowed

ERROR: multiple primary keys for table "secrets_secretrole_groups" are not allowed

ERROR: relation "secrets_secretrole_groups_secretrole_id_1c7f7ee5_uniq" already exists

ERROR: relation "secrets_secretrole_name_key" already exists

ERROR: multiple primary keys for table "secrets_secretrole" are not allowed

ERROR: relation "secrets_secretrole_slug_key" already exists

ERROR: multiple primary keys for table "secrets_secretrole_users" are not allowed

ERROR: relation "secrets_secretrole_users_secretrole_id_41832d38_uniq" already exists

ERROR: multiple primary keys for table "secrets_sessionkey" are not allowed

ERROR: relation "secrets_sessionkey_userkey_id_key" already exists

ERROR: multiple primary keys for table "secrets_userkey" are not allowed

ERROR: relation "secrets_userkey_user_id_key" already exists

ERROR: relation "tenancy_tenant_name_key" already exists

ERROR: multiple primary keys for table "tenancy_tenant" are not allowed

ERROR: relation "tenancy_tenant_slug_key" already exists

ERROR: relation "tenancy_tenantgroup_name_key" already exists

ERROR: multiple primary keys for table "tenancy_tenantgroup" are not allowed

ERROR: relation "tenancy_tenantgroup_slug_key" already exists

ERROR: relation "users_token_key_key" already exists

ERROR: multiple primary keys for table "users_token" are not allowed

ERROR: relation "virtualization_cluster_name_key" already exists

ERROR: multiple primary keys for table "virtualization_cluster" are not allowed

ERROR: relation "virtualization_clustergroup_name_key" already exists

ERROR: multiple primary keys for table "virtualization_clustergroup" are not allowed

ERROR: relation "virtualization_clustergroup_slug_key" already exists

ERROR: relation "virtualization_clustertype_name_key" already exists

ERROR: multiple primary keys for table "virtualization_clustertype" are not allowed

ERROR: relation "virtualization_clustertype_slug_key" already exists

ERROR: relation "virtualization_virtualmachine_name_key" already exists

ERROR: multiple primary keys for table "virtualization_virtualmachine" are not allowed

ERROR: relation "virtualization_virtualmachine_primary_ip4_id_key" already exists

ERROR: relation "virtualization_virtualmachine_primary_ip6_id_key" already exists

ERROR: relation "auth_group_name_a6ea08ec_like" already exists

ERROR: relation "auth_group_permissions_0e939a4f" already exists

ERROR: relation "auth_group_permissions_8373b171" already exists

ERROR: relation "auth_permission_417f1b1c" already exists

ERROR: relation "auth_user_groups_0e939a4f" already exists

ERROR: relation "auth_user_groups_e8701ad4" already exists

ERROR: relation "auth_user_user_permissions_8373b171" already exists

ERROR: relation "auth_user_user_permissions_e8701ad4" already exists

ERROR: relation "auth_user_username_6821ab7c_like" already exists

ERROR: relation "circuits_circuit_32ca2ddc" already exists

ERROR: relation "circuits_circuit_38543614" already exists

ERROR: relation "circuits_circuit_94757cae" already exists

ERROR: relation "circuits_circuittermination_3acc614b" already exists

ERROR: relation "circuits_circuittermination_9365d6e7" already exists

ERROR: relation "circuits_circuittype_name_8256ea9a_like" already exists

ERROR: relation "circuits_circuittype_slug_9b4b3cf9_like" already exists

ERROR: relation "circuits_provider_name_8f2514f5_like" already exists

ERROR: relation "circuits_provider_slug_c3c0aa10_like" already exists

ERROR: relation "dcim_consoleport_9379346c" already exists

ERROR: relation "dcim_consoleporttemplate_bddcf45f" already exists

ERROR: relation "dcim_consoleserverport_9379346c" already exists

ERROR: relation "dcim_consoleserverporttemplate_bddcf45f" already exists

ERROR: relation "dcim_device_136ca3fc" already exists

ERROR: relation "dcim_device_21556361" already exists

ERROR: relation "dcim_device_38543614" already exists

ERROR: relation "dcim_device_9365d6e7" already exists

ERROR: relation "dcim_device_asset_tag_8dac1079_like" already exists

ERROR: relation "dcim_device_bddcf45f" already exists

ERROR: relation "dcim_device_cb857215" already exists

ERROR: relation "dcim_device_cluster_id_cf852f78" already exists

ERROR: relation "dcim_device_name_cfa61dd8_like" already exists

ERROR: relation "dcim_devicebay_9379346c" already exists

ERROR: relation "dcim_devicebaytemplate_bddcf45f" already exists

ERROR: relation "dcim_devicerole_name_1c813306_like" already exists

ERROR: relation "dcim_devicerole_slug_7952643b_like" already exists

ERROR: relation "dcim_devicetype_2dbcba41" already exists

ERROR: relation "dcim_devicetype_4d136c4a" already exists

ERROR: relation "dcim_devicetype_slug_448745bd_like" already exists

ERROR: relation "dcim_interface_2ffa8a80" already exists

ERROR: relation "dcim_interface_9379346c" already exists

ERROR: relation "dcim_interface_virtual_machine_id_2afd2d50" already exists

ERROR: relation "dcim_interfacetemplate_bddcf45f" already exists

ERROR: relation "dcim_inventoryitem_asset_tag_d3289273_like" already exists

ERROR: relation "dcim_manufacturer_name_841fcd92_like" already exists

ERROR: relation "dcim_manufacturer_slug_00430749_like" already exists

ERROR: relation "dcim_module_4d136c4a" already exists

ERROR: relation "dcim_module_6be37982" already exists

ERROR: relation "dcim_module_9379346c" already exists

ERROR: relation "dcim_platform_name_c2f04255_like" already exists

ERROR: relation "dcim_platform_slug_b0908ae4_like" already exists

ERROR: relation "dcim_poweroutlet_9379346c" already exists

ERROR: relation "dcim_poweroutlettemplate_bddcf45f" already exists

ERROR: relation "dcim_powerport_9379346c" already exists

ERROR: relation "dcim_powerporttemplate_bddcf45f" already exists

ERROR: relation "dcim_rack_0e939a4f" already exists

ERROR: relation "dcim_rack_38543614" already exists

ERROR: relation "dcim_rack_84566833" already exists

ERROR: relation "dcim_rack_9365d6e7" already exists

ERROR: relation "dcim_rackgroup_2dbcba41" already exists

ERROR: relation "dcim_rackgroup_9365d6e7" already exists

ERROR: relation "dcim_rackgroup_slug_3f4582a7_like" already exists

ERROR: relation "dcim_rackreservation_21556361" already exists

ERROR: relation "dcim_rackreservation_e8701ad4" already exists

ERROR: relation "dcim_rackrole_name_9077cfcc_like" already exists

ERROR: relation "dcim_rackrole_slug_40bbcd3a_like" already exists

ERROR: relation "dcim_region_3cfbd988" already exists

ERROR: relation "dcim_region_656442a0" already exists

ERROR: relation "dcim_region_6be37982" already exists

ERROR: relation "dcim_region_c9e9a848" already exists

ERROR: relation "dcim_region_caf7cc51" already exists

ERROR: relation "dcim_region_name_ba5a7082_like" already exists

ERROR: relation "dcim_region_slug_ff078a66_like" already exists

ERROR: relation "dcim_site_0f442f96" already exists

ERROR: relation "dcim_site_38543614" already exists

ERROR: relation "dcim_site_name_8fe66c76_like" already exists

ERROR: relation "dcim_site_slug_4412c762_like" already exists

ERROR: relation "django_admin_log_417f1b1c" already exists

ERROR: relation "django_admin_log_e8701ad4" already exists

ERROR: relation "django_session_de54fa62" already exists

ERROR: relation "django_session_session_key_c0390e0f_like" already exists

ERROR: relation "extras_customfield_name_2fe72707_like" already exists

ERROR: relation "extras_customfield_obj_type_17321e91" already exists

ERROR: relation "extras_customfield_obj_type_d912b125" already exists

ERROR: relation "extras_customfieldchoice_3aabf39f" already exists

ERROR: relation "extras_customfieldvalue_171028db" already exists

ERROR: relation "extras_customfieldvalue_3aabf39f" already exists

ERROR: relation "extras_exporttemplate_417f1b1c" already exists

ERROR: relation "extras_imageattachment_content_type_id_90e0643d" already exists

ERROR: relation "extras_topologymap_9365d6e7" already exists

ERROR: relation "extras_topologymap_name_f377ebf1_like" already exists

ERROR: relation "extras_topologymap_slug_9ba3d31e_like" already exists

ERROR: relation "extras_useraction_417f1b1c" already exists

ERROR: relation "extras_useraction_e8701ad4" already exists

ERROR: relation "ipam_aggregate_5433d70a" already exists

ERROR: relation "ipam_ipaddress_0db30079" already exists

ERROR: relation "ipam_ipaddress_38543614" already exists

ERROR: relation "ipam_ipaddress_991706b3" already exists

ERROR: relation "ipam_prefix_0db30079" already exists

ERROR: relation "ipam_prefix_38543614" already exists

ERROR: relation "ipam_prefix_84566833" already exists

ERROR: relation "ipam_prefix_9365d6e7" already exists

ERROR: relation "ipam_prefix_cd1dc8b7" already exists

ERROR: relation "ipam_rir_name_64a71982_like" already exists

ERROR: relation "ipam_rir_slug_ff1a369a_like" already exists

ERROR: relation "ipam_role_name_13784849_like" already exists

ERROR: relation "ipam_role_slug_309ca14c_like" already exists

ERROR: relation "ipam_service_9379346c" already exists

ERROR: relation "ipam_service_ipaddresses_b0dc1e29" already exists

ERROR: relation "ipam_service_ipaddresses_c28bc684" already exists

ERROR: relation "ipam_vlan_0e939a4f" already exists

ERROR: relation "ipam_vlan_38543614" already exists

ERROR: relation "ipam_vlan_84566833" already exists

ERROR: relation "ipam_vlan_9365d6e7" already exists

ERROR: relation "ipam_vlangroup_2dbcba41" already exists

ERROR: relation "ipam_vlangroup_9365d6e7" already exists

ERROR: relation "ipam_vlangroup_slug_40abcf6b_like" already exists

ERROR: relation "ipam_vrf_38543614" already exists

ERROR: relation "ipam_vrf_rd_0ac1bde1_like" already exists

ERROR: relation "secrets_secret_84566833" already exists

ERROR: relation "secrets_secret_9379346c" already exists

ERROR: relation "secrets_secretrole_groups_0e939a4f" already exists

ERROR: relation "secrets_secretrole_groups_be893205" already exists

ERROR: relation "secrets_secretrole_name_7b6ee7a4_like" already exists

ERROR: relation "secrets_secretrole_slug_a06c885e_like" already exists

ERROR: relation "secrets_secretrole_users_be893205" already exists

ERROR: relation "secrets_secretrole_users_e8701ad4" already exists

ERROR: relation "tenancy_tenant_0e939a4f" already exists

ERROR: relation "tenancy_tenant_name_f6e5b2f5_like" already exists

ERROR: relation "tenancy_tenant_slug_0716575e_like" already exists

ERROR: relation "tenancy_tenantgroup_name_53363199_like" already exists

ERROR: relation "tenancy_tenantgroup_slug_e2af1cb6_like" already exists

ERROR: relation "users_token_key_820deccd_like" already exists

ERROR: relation "users_token_user_id_af964690" already exists

ERROR: relation "virtualization_cluster_group_id_de379828" already exists

ERROR: relation "virtualization_cluster_name_1b59a61b_like" already exists

ERROR: relation "virtualization_cluster_type_id_4efafb0a" already exists

ERROR: relation "virtualization_clustergroup_name_4fcd26b4_like" already exists

ERROR: relation "virtualization_clustergroup_slug_57ca1d23_like" already exists

ERROR: relation "virtualization_clustertype_name_ea854d3d_like" already exists

ERROR: relation "virtualization_clustertype_slug_8ee4d0e0_like" already exists

ERROR: relation "virtualization_virtualmachine_cluster_id_6c9f9047" already exists

ERROR: relation "virtualization_virtualmachine_name_266f6cdc_like" already exists

ERROR: relation "virtualization_virtualmachine_platform_id_a6c5ccb2" already exists

ERROR: relation "virtualization_virtualmachine_tenant_id_d00d1d77" already exists

ERROR: constraint "auth_group_permiss_permission_id_84c5c92e_fk_auth_permission_id" for relation "auth_group_permissions" already exists

ERROR: constraint "auth_group_permissions_group_id_b120cbf9_fk_auth_group_id" for relation "auth_group_permissions" already exists

ERROR: constraint "auth_permiss_content_type_id_2f476e4b_fk_django_content_type_id" for relation "auth_permission" already exists

ERROR: constraint "auth_user_groups_group_id_97559544_fk_auth_group_id" for relation "auth_user_groups" already exists

ERROR: constraint "auth_user_groups_user_id_6a12ed8b_fk_auth_user_id" for relation "auth_user_groups" already exists

ERROR: constraint "auth_user_user_per_permission_id_1fbb5f2c_fk_auth_permission_id" for relation "auth_user_user_permissions" already exists

ERROR: constraint "auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id" for relation "auth_user_user_permissions" already exists

ERROR: constraint "circuits_circuit_provider_id_d9195418_fk_circuits_provider_id" for relation "circuits_circuit" already exists

ERROR: constraint "circuits_circuit_tenant_id_812508a5_fk_tenancy_tenant_id" for relation "circuits_circuit" already exists

ERROR: constraint "circuits_circuit_type_id_1b9f485a_fk_circuits_circuittype_id" for relation "circuits_circuit" already exists

ERROR: constraint "circuits_circuitterm_circuit_id_257e87e7_fk_circuits_circuit_id" for relation "circuits_circuittermination" already exists

ERROR: constraint "circuits_circuitterm_interface_id_a147755f_fk_dcim_inte" for relation "circuits_circuittermination" already exists

ERROR: constraint "circuits_circuittermination_site_id_e6fe5652_fk_dcim_site_id" for relation "circuits_circuittermination" already exists

ERROR: constraint "dcim_consoleport_cs_port_id_41f056d5_fk_dcim_cons" for relation "dcim_consoleport" already exists

ERROR: constraint "dcim_consoleport_device_id_f2d90d3c_fk_dcim_device_id" for relation "dcim_consoleport" already exists

ERROR: constraint "dcim_consoleportt_device_type_id_075d4015_fk_dcim_devicetype_id" for relation "dcim_consoleporttemplate" already exists

ERROR: constraint "dcim_consoleserve_device_type_id_579bdc86_fk_dcim_devicetype_id" for relation "dcim_consoleserverporttemplate" already exists

ERROR: constraint "dcim_consoleserverport_device_id_d9866581_fk_dcim_device_id" for relation "dcim_consoleserverport" already exists

ERROR: constraint "dcim_device_cluster_id_cf852f78_fk_virtualization_cluster_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_device_role_id_682e8188_fk_dcim_devicerole_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_device_type_id_d61b4086_fk_dcim_devicetype_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_platform_id_468138f1_fk_dcim_platform_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_primary_ip4_id_2ccd943a_fk_ipam_ipaddress_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_primary_ip6_id_d180fe91_fk_ipam_ipaddress_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_rack_id_23bde71f_fk_dcim_rack_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_site_id_ff897cf6_fk_dcim_site_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_device_tenant_id_dcea7969_fk_tenancy_tenant_id" for relation "dcim_device" already exists

ERROR: constraint "dcim_devicebay_device_id_0c8a1218_fk_dcim_device_id" for relation "dcim_devicebay" already exists

ERROR: constraint "dcim_devicebay_installed_device_id_04618112_fk_dcim_device_id" for relation "dcim_devicebay" already exists

ERROR: constraint "dcim_devicebaytem_device_type_id_f4b24a29_fk_dcim_devicetype_id" for relation "dcim_devicebaytemplate" already exists

ERROR: constraint "dcim_devicetyp_manufacturer_id_a3e8029e_fk_dcim_manufacturer_id" for relation "dcim_devicetype" already exists

ERROR: constraint "dcim_interface_device_id_359c6115_fk_dcim_device_id" for relation "dcim_interface" already exists

ERROR: constraint "dcim_interface_lag_id_ea1a1d12_fk_dcim_interface_id" for relation "dcim_interface" already exists

ERROR: constraint "dcim_interface_virtual_machine_id_2afd2d50_fk_virtualiz" for relation "dcim_interface" already exists

ERROR: constraint "dcim_interfaceconn_interface_a_id_503f46c2_fk_dcim_interface_id" for relation "dcim_interfaceconnection" already exists

ERROR: constraint "dcim_interfaceconn_interface_b_id_85faa104_fk_dcim_interface_id" for relation "dcim_interfaceconnection" already exists

ERROR: constraint "dcim_interfacetem_device_type_id_4bfcbfab_fk_dcim_devicetype_id" for relation "dcim_interfacetemplate" already exists

ERROR: constraint "dcim_inventoryitem_device_id_033d83f8_fk_dcim_device_id" for relation "dcim_inventoryitem" already exists

ERROR: constraint "dcim_inventoryitem_manufacturer_id_dcd1b78a_fk_dcim_manu" for relation "dcim_inventoryitem" already exists

ERROR: constraint "dcim_inventoryitem_parent_id_7ebcd457_fk_dcim_inventoryitem_id" for relation "dcim_inventoryitem" already exists

ERROR: constraint "dcim_poweroutlet_device_id_286351d7_fk_dcim_device_id" for relation "dcim_poweroutlet" already exists

ERROR: constraint "dcim_poweroutlett_device_type_id_26b2316c_fk_dcim_devicetype_id" for relation "dcim_poweroutlettemplate" already exists

ERROR: constraint "dcim_powerport_device_id_ef7185ae_fk_dcim_device_id" for relation "dcim_powerport" already exists

ERROR: constraint "dcim_powerport_power_outlet_id_741276ef_fk_dcim_poweroutlet_id" for relation "dcim_powerport" already exists

ERROR: constraint "dcim_powerporttem_device_type_id_1ddfbfcc_fk_dcim_devicetype_id" for relation "dcim_powerporttemplate" already exists

ERROR: constraint "dcim_rack_group_id_44e90ea9_fk_dcim_rackgroup_id" for relation "dcim_rack" already exists

ERROR: constraint "dcim_rack_role_id_62d6919e_fk_dcim_rackrole_id" for relation "dcim_rack" already exists

ERROR: constraint "dcim_rack_site_id_403c7b3a_fk_dcim_site_id" for relation "dcim_rack" already exists

ERROR: constraint "dcim_rack_tenant_id_7cdf3725_fk_tenancy_tenant_id" for relation "dcim_rack" already exists

ERROR: constraint "dcim_rackgroup_site_id_13520e89_fk_dcim_site_id" for relation "dcim_rackgroup" already exists

ERROR: constraint "dcim_rackreservation_rack_id_1ebbaa9b_fk_dcim_rack_id" for relation "dcim_rackreservation" already exists

ERROR: constraint "dcim_rackreservation_user_id_0785a527_fk_auth_user_id" for relation "dcim_rackreservation" already exists

ERROR: constraint "dcim_region_parent_id_2486f5d4_fk_dcim_region_id" for relation "dcim_region" already exists

ERROR: constraint "dcim_site_region_id_45210932_fk_dcim_region_id" for relation "dcim_site" already exists

ERROR: constraint "dcim_site_tenant_id_15e7df63_fk_tenancy_tenant_id" for relation "dcim_site" already exists

ERROR: constraint "django_admin_content_type_id_c4bce8eb_fk_django_content_type_id" for relation "django_admin_log" already exists

ERROR: constraint "django_admin_log_user_id_c564eba6_fk_auth_user_id" for relation "django_admin_log" already exists

ERROR: constraint "extras_customfie_obj_type_id_b750b07b_fk_django_content_type_id" for relation "extras_customfieldvalue" already exists

ERROR: constraint "extras_customfield_o_contenttype_id_6890b714_fk_django_co" for relation "extras_customfield_obj_type" already exists

ERROR: constraint "extras_customfield_o_customfield_id_82480f86_fk_extras_cu" for relation "extras_customfield_obj_type" already exists

ERROR: constraint "extras_customfieldch_field_id_35006739_fk_extras_customfield_id" for relation "extras_customfieldchoice" already exists

ERROR: constraint "extras_customfieldva_field_id_1a461f0d_fk_extras_customfield_id" for relation "extras_customfieldvalue" already exists

ERROR: constraint "extras_expor_content_type_id_59737e21_fk_django_content_type_id" for relation "extras_exporttemplate" already exists

ERROR: constraint "extras_imageattachme_content_type_id_90e0643d_fk_django_co" for relation "extras_imageattachment" already exists

ERROR: constraint "extras_topologymap_site_id_b56b3ceb_fk_dcim_site_id" for relation "extras_topologymap" already exists

ERROR: constraint "extras_usera_content_type_id_99f782d7_fk_django_content_type_id" for relation "extras_useraction" already exists

ERROR: constraint "extras_useraction_user_id_8aacec56_fk_auth_user_id" for relation "extras_useraction" already exists

ERROR: constraint "ipam_aggregate_rir_id_ef7a27bd_fk_ipam_rir_id" for relation "ipam_aggregate" already exists

ERROR: constraint "ipam_ipaddress_interface_id_91e71d9d_fk_dcim_interface_id" for relation "ipam_ipaddress" already exists

ERROR: constraint "ipam_ipaddress_nat_inside_id_a45fb7c5_fk_ipam_ipaddress_id" for relation "ipam_ipaddress" already exists

ERROR: constraint "ipam_ipaddress_tenant_id_ac55acfd_fk_tenancy_tenant_id" for relation "ipam_ipaddress" already exists

ERROR: constraint "ipam_ipaddress_vrf_id_51fcc59b_fk_ipam_vrf_id" for relation "ipam_ipaddress" already exists

ERROR: constraint "ipam_prefix_role_id_0a98d415_fk_ipam_role_id" for relation "ipam_prefix" already exists

ERROR: constraint "ipam_prefix_site_id_0b20df05_fk_dcim_site_id" for relation "ipam_prefix" already exists

ERROR: constraint "ipam_prefix_tenant_id_7ba1fcc4_fk_tenancy_tenant_id" for relation "ipam_prefix" already exists

ERROR: constraint "ipam_prefix_vlan_id_1db91bff_fk_ipam_vlan_id" for relation "ipam_prefix" already exists

ERROR: constraint "ipam_prefix_vrf_id_34f78ed0_fk_ipam_vrf_id" for relation "ipam_prefix" already exists

ERROR: constraint "ipam_service_device_id_b4d2bb9c_fk_dcim_device_id" for relation "ipam_service" already exists

ERROR: constraint "ipam_service_ipaddre_ipaddress_id_b4138c6d_fk_ipam_ipad" for relation "ipam_service_ipaddresses" already exists

ERROR: constraint "ipam_service_ipaddresses_service_id_ae26b9ab_fk_ipam_service_id" for relation "ipam_service_ipaddresses" already exists

ERROR: constraint "ipam_vlan_group_id_88cbfa62_fk_ipam_vlangroup_id" for relation "ipam_vlan" already exists

ERROR: constraint "ipam_vlan_role_id_f5015962_fk_ipam_role_id" for relation "ipam_vlan" already exists

ERROR: constraint "ipam_vlan_site_id_a59334e3_fk_dcim_site_id" for relation "ipam_vlan" already exists

ERROR: constraint "ipam_vlan_tenant_id_71a8290d_fk_tenancy_tenant_id" for relation "ipam_vlan" already exists

ERROR: constraint "ipam_vlangroup_site_id_264f36f6_fk_dcim_site_id" for relation "ipam_vlangroup" already exists

ERROR: constraint "ipam_vrf_tenant_id_498b0051_fk_tenancy_tenant_id" for relation "ipam_vrf" already exists

ERROR: constraint "secrets_secret_device_id_c7c13124_fk_dcim_device_id" for relation "secrets_secret" already exists

ERROR: constraint "secrets_secret_role_id_39d9347f_fk_secrets_secretrole_id" for relation "secrets_secret" already exists

ERROR: constraint "secrets_secretr_secretrole_id_3cf0338b_fk_secrets_secretrole_id" for relation "secrets_secretrole_groups" already exists

ERROR: constraint "secrets_secretr_secretrole_id_d2eac298_fk_secrets_secretrole_id" for relation "secrets_secretrole_users" already exists

ERROR: constraint "secrets_secretrole_groups_group_id_a687dd10_fk_auth_group_id" for relation "secrets_secretrole_groups" already exists

ERROR: constraint "secrets_secretrole_users_user_id_25be95ad_fk_auth_user_id" for relation "secrets_secretrole_users" already exists

ERROR: constraint "secrets_sessionkey_userkey_id_3ca6176b_fk_secrets_userkey_id" for relation "secrets_sessionkey" already exists

ERROR: constraint "secrets_userkey_user_id_13ada46b_fk_auth_user_id" for relation "secrets_userkey" already exists

ERROR: constraint "tenancy_tenant_group_id_7daef6f4_fk_tenancy_tenantgroup_id" for relation "tenancy_tenant" already exists

ERROR: constraint "users_token_user_id_af964690_fk_auth_user_id" for relation "users_token" already exists

ERROR: constraint "virtualization_clust_group_id_de379828_fk_virtualiz" for relation "virtualization_cluster" already exists

ERROR: constraint "virtualization_clust_type_id_4efafb0a_fk_virtualiz" for relation "virtualization_cluster" already exists

ERROR: constraint "virtualization_virtu_cluster_id_6c9f9047_fk_virtualiz" for relation "virtualization_virtualmachine" already exists

ERROR: constraint "virtualization_virtu_platform_id_a6c5ccb2_fk_dcim_plat" for relation "virtualization_virtualmachine" already exists

ERROR: constraint "virtualization_virtu_primary_ip4_id_942e42ae_fk_ipam_ipad" for relation "virtualization_virtualmachine" already exists

ERROR: constraint "virtualization_virtu_primary_ip6_id_b7904e73_fk_ipam_ipad" for relation "virtualization_virtualmachine" already exists

ERROR: constraint "virtualization_virtu_tenant_id_d00d1d77_fk_tenancy_t" for relation "virtualization_virtualmachine" already exists

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

REVOKE

GRANT

You are now connected to database "postgres" as user "postgres".

SET

COMMENT

CREATE EXTENSION

COMMENT

REVOKE

GRANT

You are now connected to database "template1" as user "postgres".

SET

COMMENT

CREATE EXTENSION

COMMENT

REVOKE

GRANT

Kyler Manseau

unread,

Dec 17, 2018, 11:51:39 AM12/17/18

to NetBox

Did you ever resolve this issue? I am currently running into the same thing

...

Kyler Manseau

unread,

Dec 17, 2018, 3:52:36 PM12/17/18

to NetBox

I was able to solve my issue. I had to create the database dump in a tar format. Then when running pg_restore, I was able to use the --clean flag which then imported the database without any errors

Reply all

Reply to author

Forward

0 new messages