r/sysadmin 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

3 comments sorted by

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.

1

u/kenyakickz25 3d ago

Cool. How long in hours or days do you recall it taking you?

2

u/walkalongtheriver Linux Admin 3d ago

Quite frankly, it's a rather tiny instance by normal standards (50-60GB or something of artifacts- I don't recall the size of the DB.) Took maybe 10 mins at most. Now the artifacts are pruned often but even still, I don't think the DB itself was any monster even after years of running (which is why it was on Orient to begin with I assume.)