zalando / postgres-operator

Postgres operator creates and manages PostgreSQL clusters running in Kubernetes
https://postgres-operator.readthedocs.io/
MIT License
4.37k stars 980 forks source link

How does one recreate a database? #2769

Open gytis-ivaskevicius opened 1 month ago

gytis-ivaskevicius commented 1 month ago

How does one recreate a database? We are semi-often required to recreate the database, how does one drop database and force the operator to recreate it? As of right now if one drops the DB, it takes a while to pickup the changes. Alternatively, one may drop the DB and restart the leader (if I recall correctly it forces the operator to recreate the DB)

As of right now we just drop tables/types which is bothersome

Sidenote: This is an awful issue template :sweat: lots to read, inconvenient to edit