Drop database roles before recreating the database
Table of Contents
This page is a capture in the next bucket of the product backlog — a pre-sprint idea, not yet pulled into a sprint as a story.
What
(One paragraph: the idea.)
Why
(Motivation, problem being solved, related context.)
References
See also
recreate_database.sh drops and re-creates the database but does not drop roles first. On re-run, CREATE ROLE fails with "role already exists" for any role that survived the drop. Add a DROP ROLE IF EXISTS block at the top of the setup sequence, before CREATE DATABASE, to ensure a clean slate.