Oozie is currently configured with embedded derby database. To be able to safely take backups and as it is recommended as well, I would like to use PostgreSQL. If I now change the database for oozie through CM, Do I lose my workflows and coordinators?
If yes, what is the safe way to do it with least amount of effort. I obviously don't want to create all of those workflows again.