How does one recreate a database?

[gytis-ivaskevicius]

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

• Which image of the operator are you using? e.g. ghcr.io/zalando/postgres-operator:v1.11.0
• Where do you run it - cloud or metal? Kubernetes or OpenShift? [AWS K8s ]
• Are you running Postgres Operator in production? [yes]
• Type of issue? [feature request/docs]

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