Created
March 9, 2016 17:27
-
-
Save gabeodess/c411dbc2e16970bb4f15 to your computer and use it in GitHub Desktop.
import database
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $cat dump.sql | psql nwmedtech_production | |
| SET | |
| SET | |
| SET | |
| SET | |
| SET | |
| SET | |
| ERROR: database "callcenter" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| You are now connected to database "callcenter" as user "gabeodess". | |
| SET | |
| SET | |
| SET | |
| SET | |
| SET | |
| SET | |
| CREATE EXTENSION | |
| COMMENT | |
| SET | |
| SET | |
| SET | |
| ERROR: relation "active_admin_comments" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "active_admin_comments_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "admin_users" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "admin_users_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "ads" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "ads_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "blocked_numbers" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "blocked_numbers_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "call_centers" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "call_centers_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "calls" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "calls_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "campaigns" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "campaigns_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "mail_sequence_shipments" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "mail_sequence_shipments_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "mail_sequences" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "mail_sequences_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "number_assignments" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "number_assignments_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "paper_trails" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "paper_trails_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "patients" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "patients_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "phone_numbers" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "phone_numbers_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "publications" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "publications_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "reasons" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "reasons_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "recordings" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "recordings_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "schema_migrations" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "transcriptions" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "transcriptions_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "users" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "users_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ERROR: relation "zip_codes" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: relation "zip_codes_id_seq" already exists | |
| ERROR: role "nwmedtech" does not exist | |
| ALTER SEQUENCE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| ALTER TABLE | |
| COPY 0 | |
| setval | |
| -------- | |
| 1 | |
| (1 row) | |
| COPY 0 | |
| setval | |
| -------- | |
| 1 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "ads_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY ads, line 1 | |
| setval | |
| -------- | |
| 16 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "blocked_numbers_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY blocked_numbers, line 1 | |
| setval | |
| -------- | |
| 2 | |
| (1 row) | |
| ERROR: column "zip_code_id" of relation "call_centers" does not exist | |
| invalid command \. | |
| ERROR: syntax error at or near "2" | |
| LINE 1: 2 Denver CO 2015-11-20 00:35:51.086262 2015-11-20 00:35:51.0... | |
| ^ | |
| ERROR: column "outgoing" of relation "calls" does not exist | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \. | |
| ERROR: syntax error at or near "22" | |
| LINE 1: 22 3 7 1 {} 2016-01-05 14:40:07.551069 2016-01-05 14:40:07.5... | |
| ^ | |
| ERROR: column "ad_id" of relation "campaigns" does not exist | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \. | |
| ERROR: syntax error at or near "1" | |
| LINE 1: 1 test campaign #1 2015-11-20 00:43:19.984287 2015-11-20 00:... | |
| ^ | |
| ERROR: duplicate key value violates unique constraint "mail_sequence_shipments_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY mail_sequence_shipments, line 1 | |
| setval | |
| -------- | |
| 6 | |
| (1 row) | |
| ERROR: column "paused_at" of relation "mail_sequences" does not exist | |
| invalid command \N | |
| invalid command \N | |
| invalid command \N | |
| invalid command \. | |
| ERROR: syntax error at or near "1" | |
| LINE 1: 1 1 arthritis sequence1 monthly-mailer 2015-12-08 18:35:54.8... | |
| ^ | |
| ERROR: duplicate key value violates unique constraint "number_assignments_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY number_assignments, line 1 | |
| setval | |
| -------- | |
| 20 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "paper_trails_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY paper_trails, line 1 | |
| setval | |
| -------- | |
| 27 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "patients_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY patients, line 3 | |
| setval | |
| -------- | |
| 8 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "phone_numbers_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY phone_numbers, line 1 | |
| setval | |
| -------- | |
| 11 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "publications_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY publications, line 1 | |
| setval | |
| -------- | |
| 2 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "reasons_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY reasons, line 1 | |
| setval | |
| -------- | |
| 12 | |
| (1 row) | |
| COPY 0 | |
| setval | |
| -------- | |
| 1 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "unique_schema_migrations" | |
| DETAIL: Key (version)=(20151113180549) already exists. | |
| CONTEXT: COPY schema_migrations, line 1 | |
| COPY 0 | |
| setval | |
| -------- | |
| 1 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "users_pkey" | |
| DETAIL: Key (id)=(3) already exists. | |
| CONTEXT: COPY users, line 1 | |
| setval | |
| -------- | |
| 8 | |
| (1 row) | |
| ERROR: duplicate key value violates unique constraint "zip_codes_pkey" | |
| DETAIL: Key (id)=(1) already exists. | |
| CONTEXT: COPY zip_codes, line 1 | |
| setval | |
| -------- | |
| 42741 | |
| (1 row) | |
| ERROR: multiple primary keys for table "active_admin_comments" are not allowed | |
| ERROR: multiple primary keys for table "admin_users" are not allowed | |
| ERROR: multiple primary keys for table "ads" are not allowed | |
| ERROR: multiple primary keys for table "blocked_numbers" are not allowed | |
| ERROR: multiple primary keys for table "call_centers" are not allowed | |
| ERROR: multiple primary keys for table "calls" are not allowed | |
| ERROR: multiple primary keys for table "campaigns" are not allowed | |
| ERROR: multiple primary keys for table "mail_sequence_shipments" are not allowed | |
| ERROR: multiple primary keys for table "mail_sequences" are not allowed | |
| ERROR: multiple primary keys for table "number_assignments" are not allowed | |
| ERROR: multiple primary keys for table "paper_trails" are not allowed | |
| ERROR: multiple primary keys for table "patients" are not allowed | |
| ERROR: multiple primary keys for table "phone_numbers" are not allowed | |
| ERROR: multiple primary keys for table "publications" are not allowed | |
| ERROR: multiple primary keys for table "reasons" are not allowed | |
| ERROR: multiple primary keys for table "recordings" are not allowed | |
| ERROR: multiple primary keys for table "transcriptions" are not allowed | |
| ERROR: multiple primary keys for table "users" are not allowed | |
| ERROR: multiple primary keys for table "zip_codes" are not allowed | |
| ERROR: relation "index_active_admin_comments_on_author_type_and_author_id" already exists | |
| ERROR: relation "index_active_admin_comments_on_namespace" already exists | |
| ERROR: relation "index_active_admin_comments_on_resource_type_and_resource_id" already exists | |
| ERROR: relation "index_admin_users_on_email" already exists | |
| ERROR: relation "index_admin_users_on_reset_password_token" already exists | |
| ERROR: relation "index_blocked_numbers_on_number" already exists | |
| ERROR: relation "index_call_centers_on_address" already exists | |
| ERROR: relation "index_call_centers_on_phone" already exists | |
| ERROR: column "zip_code_id" does not exist | |
| ERROR: relation "index_calls_on_address" already exists | |
| ERROR: relation "index_calls_on_call_center_id" already exists | |
| ERROR: relation "index_calls_on_campaign_id" already exists | |
| ERROR: relation "index_calls_on_editor_id" already exists | |
| ERROR: relation "index_calls_on_patient_id" already exists | |
| ERROR: relation "index_calls_on_reason_id" already exists | |
| ERROR: relation "index_calls_on_twilio" already exists | |
| ERROR: column "twilio_id" does not exist | |
| ERROR: relation "index_calls_on_user_id" already exists | |
| ERROR: column "ad_id" does not exist | |
| ERROR: relation "index_campaigns_on_media_manager_id" already exists | |
| ERROR: column "phone_number_id" does not exist | |
| ERROR: relation "index_campaigns_on_publication_id" already exists | |
| ERROR: relation "index_mail_sequence_shipments_on_mail_sequence_id" already exists | |
| ERROR: relation "index_mail_sequence_shipments_on_package_key" already exists | |
| ERROR: relation "index_mail_sequences_on_call_id" already exists | |
| ERROR: relation "index_number_assignments_on_call_center_id" already exists | |
| ERROR: relation "index_number_assignments_on_phone_number_id" already exists | |
| ERROR: relation "index_paper_trails_on_call_id" already exists | |
| ERROR: relation "index_patients_on_address" already exists | |
| ERROR: relation "index_phone_numbers_on_twilio" already exists | |
| ERROR: relation "index_recordings_on_call_id" already exists | |
| ERROR: relation "index_recordings_on_sid" already exists | |
| ERROR: relation "index_recordings_on_twilio" already exists | |
| ERROR: relation "index_transcriptions_on_recording_sid" already exists | |
| ERROR: relation "index_transcriptions_on_sid" already exists | |
| ERROR: relation "index_transcriptions_on_twilio" already exists | |
| ERROR: relation "index_users_on_email" already exists | |
| ERROR: relation "index_users_on_reset_password_token" already exists | |
| ERROR: relation "index_zip_codes_on_zip" already exists | |
| ERROR: relation "unique_schema_migrations" already exists | |
| ERROR: constraint "fk_rails_0544595bc3" for relation "number_assignments" already exists | |
| ERROR: constraint "fk_rails_09e145e0ac" for relation "calls" already exists | |
| ERROR: constraint "fk_rails_2d645f6f17" for relation "paper_trails" already exists | |
| ERROR: constraint "fk_rails_4e012742ce" for relation "number_assignments" already exists | |
| ERROR: constraint "fk_rails_60a3bd913e" for relation "calls" already exists | |
| ERROR: constraint "fk_rails_658ed11d76" for relation "mail_sequences" already exists | |
| ERROR: constraint "fk_rails_829ac23b9b" for relation "campaigns" already exists | |
| ERROR: column "ad_id" referenced in foreign key constraint does not exist | |
| ERROR: constraint "fk_rails_8e1b2ecfdf" for relation "calls" already exists | |
| ERROR: constraint "fk_rails_97b9222234" for relation "calls" already exists | |
| ERROR: column "phone_number_id" referenced in foreign key constraint does not exist | |
| ERROR: column "zip_code_id" referenced in foreign key constraint does not exist | |
| ERROR: constraint "fk_rails_b7625a607f" for relation "campaigns" already exists | |
| ERROR: constraint "fk_rails_d6bc08fce7" for relation "calls" already exists | |
| ERROR: constraint "fk_rails_d90ec14237" for relation "calls" already exists | |
| ERROR: constraint "fk_rails_fa919fba27" for relation "recordings" already exists | |
| ERROR: constraint "fk_rails_fbbe8ae8e4" for relation "mail_sequence_shipments" already exists | |
| REVOKE | |
| ERROR: role "nwmedtech" does not exist | |
| ERROR: role "nwmedtech" does not exist | |
| GRANT |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment