OrientDB to Postgres Migration Guide for Nexus Repository - Sonatype Learn - Sonatype Community

OrientDB to Postgres Migration Guide for Nexus Repository

At Sonatype, we’re well aware that migrations can be frustrating. But with support for OrientDB databases ending early next year, the time to start planning to get off of OrientDB is now. Your options are H2 and Postgres, and out of the two, Sonatype strongly suggests that all enterprise instances of Nexus Repository use Postgres.

To cut down on frustration and give you the smoothest possible migration, we’ve prepared the attached document, which includes complete instructions for migrating from OrientDB to Postgres, along with helpful tips and solutions to some of the most common migration pitfalls. Our hope is that this document jumpstarts your efforts.

If changes are made to the doc, we’ll update the link above so that it always points to the latest-and-greatest.

EDIT

Updated on 1/9/26 with a new, refined look.

Post by jzora on Jun 18, 2025

Whitepaper - OrientDB to PostgreSQL Migration Guide.pdf (428.2 KB)

Post by prateek_dodda on Jun 26, 2025

Hi I have a quick question on this so we are currently using 3.70.4 Nexus Repository Manager OSS instance and planning to migrate from orientdb to postgresql database. Is this possible with the OSS instance?

Post by jzora on Jun 26, 2025

The guide linked above is for customers who have purchased a Nexus Repository Pro license.

OSS users cannot use Postgres as a database option until they move to Community Edition! Check out documentation below.

Because you’re an OSS user, your path to Postgres will be to migrate to H2, upgrade to Java 17, move to Community Edition (3.77.0+), then migrate to Postgres.

Post by prateek_dodda on Jun 27, 2025

missed this part of the documentation. Thank you so much for the response

New & Unread Topics

Topic Replies Views Activity
New Course: Sonatype Guide and MCP Server 2 129 Mar 31
New Course: Intro to SBOM Manager 0 36 Sep 2025
Updated Course: Malware Vs. Vulnerabilities 0 45 Sep 2025
Protection from Recent npm Malware Attacks 1 365 Sep 2025
Error after upgrade to 3.83 NoSuchBeanDefinitionException GroupFacet Qualifier(“groupWriteFacet”) 1 261 Aug 2025