gistfile1.txt

➜  zweet git:(features/mturk-mvp) ✗ mkdir -p tmp/psql
➜  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 2275; 1259 25142 INDEX index_receipts_on_chain_id u89yid
pg_restore: [archiver (db)] could not execute query: ERROR:  index "index_receipts_on_chain_id" does not exist
    Command was: DROP INDEX public.index_receipts_on_chain_id;

pg_restore: [archiver (db)] Error from TOC entry 2265; 2606 17553 CONSTRAINT merchants_pkey u89yid
pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "merchants_pkey" of relation "companies" does not exist
    Command was: ALTER TABLE ONLY public.companies DROP CONSTRAINT merchants_pkey;

pg_restore: [archiver (db)] Error from TOC entry 2335; 2606 24615 CONSTRAINT image_preparation_strategies_pkey u89yid
pg_restore: [archiver (db)] could not execute query: ERROR:  constraint "image_preparation_strategies_pkey" of relation "ocr_image_preprocessing_methods" does not exist
    Command was: ALTER TABLE ONLY public.ocr_image_preprocessing_methods DROP CONSTRAINT image_preparation_strategies_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 clients depends on schema public
table mturk_transcription_jobs depends on schema public
table turkee_imported_assignments depends on schema public
table turkee_studies depends on schema public
table turkee_tasks depends on schema public
table withdrawal_exports depends on schema public
table withdrawals 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;