Nexus 3 and Postgres

Sonatype Nexus Repository
1

A member of your team had ran into a note stating that we needed to upgrade our Nexus3:3.68.1 from H2 to Postgres. After performing the upgrade we found that the instance was still using H2 and we were getting errors so we rolled back. Looking into Nexus Admin screen we saw h2 was hardcoded and we could not find a way to change that. I later saw other notes that stated that after version 3.77, this was supported not just in the Pro version.

I am just looking for clarification on what database we should be running with Nexus 3 v3.77.1 going forward.

2

I recently migrated from H2 to Postgres and followed these steps

https://help.sonatype.com/en/migrating-to-a-new-database.html

I think we had a similar experience, and then it wasn’t until I found this page:
https://help.sonatype.com/en/install-nexus-repository-with-a-postgresql-database.html#database-configuration

that describe setting env vars to the system start configuration. once I had THAT in place, my Nexus instance began using the Postgres backend. There is an altrenative to set the jdbc information in $data-dir/etc/fabric/nexus-store.properties.

locally we had the issue of first upgrading to the appropriate version - we’re currently on 3.89.1-02 community edition

hope that helps,
joey

3

Originally PostgreSQL was only supported on PRO, I haven’t verified but I believe 3.68.1 is before it was made available to Community Edition.

If you’re a pro user, and having trouble I suggest a support contact file a ticket. If you’re CE user confirm version support in the help documentation.