3,765
回編集
差分
→schedulesテーブル
差分を削除する
=# delete from schedules where client_id in (132, 212, 537, 550, 2697, 2843, 2844, 2845, 2846, 2848, 2849, 2850, 2861, 3049, 3050, 3076, 20081, 22584, 22585, 22599, 22653, 22657, 22697, 22887, 22892, 23073, 23976, 33056, 33057, 33058, 33059, 33062, 33063, 33064, 33065, 33066, 33068, 33069, 33070, 33077, 33078, 33079, 33081); 改めてリストア コピーする <nowiki>jq@MacBook-Pro tep5 % pg_dump --username=jq --table schedules update_heroku > ../new_schedules.sqljq@MacBook-Pro tep5 % psql --username=jq tep5_development < ../new_schedules.sql SETSETSETSETSET set_config ------------ (1 row) SETSETSETSETSETSETERROR: relation "schedules" already existsALTER TABLEERROR: relation "schedules_id_seq" already existsALTER TABLEALTER SEQUENCEALTER TABLECOPY 3701 setval -------- 4603(1 row) ERROR: multiple primary keys for table "schedules" are not allowedERROR: relation "index_schedules_on_client_id" already existsERROR: relation "index_schedules_on_content" already existsERROR: relation "index_schedules_on_datetime" already existsERROR: relation "index_schedules_on_ie_id" already existsERROR: relation "index_schedules_on_jiin_id" already existsERROR: relation "index_schedules_on_user_id" already exists</nowiki>
=== ダンプ ここまで形を整えたデータベースをバックアップしとく ===