gistfile1.txt

➜  zweet git:(features/mturk-mvp) ✗ script/bootstrap
Would you like to (re)initialize the database? (y/n) n
Would you like to retrieve a database snapshot from staging? (y/n) y
Creating database snapshot...
Restoring database snapshot...
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 2428; 2606 17793 CONSTRAINT withdrawals_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "withdrawals_pkey" of relation "withdrawals" does not exist
    Command was: ALTER TABLE ONLY public.withdrawals DROP CONSTRAINT withdrawals_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2423; 2606 17791 CONSTRAINT withdrawal_exports_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "withdrawal_exports_pkey" of relation "withdrawal_exports" does not exist
    Command was: ALTER TABLE ONLY public.withdrawal_exports DROP CONSTRAINT withdrawal_exports_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2336; 2606 17735 CONSTRAINT clients_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "clients_pkey" of relation "clients" does not exist
    Command was: ALTER TABLE ONLY public.clients DROP CONSTRAINT clients_pkey;

pg_restore: [archiver (db)] Error from TOC entry 5; 2615 2200 SCHEMA public postgres
pg_restore: [archiver (db)] could not execute query: ERROR:  cannot drop schema public because other objects depend on it
DETAIL:  table accounts depends on schema public
table payment_exports depends on schema public
table payments depends on schema public
HINT:  Use DROP ... CASCADE to drop the dependent objects too.
    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 2336; 2606 17735 CONSTRAINT clients_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "clients_pkey" already exists
    Command was: ALTER TABLE ONLY clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);



pg_restore: [archiver (db)] Error from TOC entry 2423; 2606 17791 CONSTRAINT withdrawal_exports_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "withdrawal_exports_pkey" already exists
    Command was: ALTER TABLE ONLY withdrawal_exports
    ADD CONSTRAINT withdrawal_exports_pkey PRIMARY KEY (id);



pg_restore: [archiver (db)] Error from TOC entry 2428; 2606 17793 CONSTRAINT withdrawals_pkey uji7vm
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "withdrawals_pkey" already exists
    Command was: ALTER TABLE ONLY withdrawals
    ADD CONSTRAINT withdrawals_pkey PRIMARY KEY (id);



WARNING: errors ignored on restore: 8