postgres-operator icon indicating copy to clipboard operation
postgres-operator copied to clipboard

Published 20 hours ago • verified publisher icon zalando

How does one recreate a database?

Open gytis-ivaskevicius opened this issue 1 year ago • 0 comments

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 :sweat: lots to read, inconvenient to edit

gytis-ivaskevicius avatar Oct 04 '24 14:10 gytis-ivaskevicius