Upgrading Postgresql from v11.7 to v14.8 Locally - department-of-veterans-affairs/caseflow GitHub Wiki

Caseflow Edition

eFolder Express Edition

Remove the Existing Postgres Volume

  1. First, stop all active Caseflow containers
    1. make down or make down-m1 depending on your system
  2. Optional: Remove the appeals-db container if it's still showing as active
    1. docker rm appeals-db
  3. Remove the volume used to house Caseflow's Postgresql data files
    1. docker-compose down --volumes
  4. Optional: Explicitly remove the volume if it still persists
    1. docker volume rm caseflow_postgresdata

Recreating the Postgres Database

  1. Ensure you're checked out to a branch with the Postgres image set to v14 in your docker-compose files (ex: postgres-14-demo-test)
  2. Restart your containers
    1. make up or make up-m1
  3. Reinitialize your database schema:
    1. bundle exec rake db:create db:schema:load
  4. Reseed your database
    1. make reset