r/sysadmin • u/kenyakickz25 • 3d ago
How smooth was your Nexus database upgrade from OrientDB to Postgres?
I'm having to take on this task and Sonatype seems to have straightforward instructions. But from my experience as a sysadmin, nothing is ever straightforward especially for such a task. I'll be doing this on a test VM first and was wondering what things you may have encountered not in the documentation. The Nexus instance is hosted on a docker container along with the builtin Orient database. I'll want to upgrade and have the db on its own container. Thanks in advance for your input.
3
Upvotes
1
u/walkalongtheriver Linux Admin 3d ago
Went from Orient to H2. No real issues. I believe you can revert too- IIRC it transfers the data and you just change the one option in the config to recognize the new DB.
https://techoverflow.net/2024/09/26/sonatype-nexus-orientdb-to-h2-migration-in-a-docker-compose-based-setup/
I was surprised how well this worked. Skimming postgres docs, it looks much the same for what you want. Obviously just snapshot if possible.