hello Ory Community! Currently we have running ory (hydra and kratos) using postgres database for storing data. we want to change this to another database which is cnpg (wich is a postgres cluster operator)
For hydra, I am following the steps:
• Run hydra help chart with the new dsn pointing to the new postgres cluster
• drop and recreate hydra databse on the new postgres cluster
• Take pg_dump from hydra database on postgres cluster
• restore hydra database on a fresh cluster
• restart hydra pods.