import database

gistfile1.txt

$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