# 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](https://community.sonatype.com/uploads/short-url/pUoyfMI5tAmjugNKukZ2rBkCYNT.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.

* [Nexus Repository Community Edition Onboarding Guide](https://help.sonatype.com/en/ce-onboarding.html)  
* [Upgrading to Nexus Repository 3.71.0 and Beyond](https://help.sonatype.com/en/upgrading-to-nexus-repository-3-71-0-and-beyond.html#nexus-repository-upgrade-when-using-orientdb)

## 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](https://community.sonatype.com/t/new-course-sonatype-guide-and-mcp-server/15978) | [2](https://community.sonatype.com/t/new-course-sonatype-guide-and-mcp-server/15978/1) | 129 | [Mar 31](https://community.sonatype.com/t/new-course-sonatype-guide-and-mcp-server/15978/3) |
| [New Course: Intro to SBOM Manager](https://community.sonatype.com/t/new-course-intro-to-sbom-manager/15561) | [0](https://community.sonatype.com/t/new-course-intro-to-sbom-manager/15561/1) | 36 | [Sep 2025](https://community.sonatype.com/t/new-course-intro-to-sbom-manager/15561/1) |
| [Updated Course: Malware Vs. Vulnerabilities](https://community.sonatype.com/t/updated-course-malware-vs-vulnerabilities/15612) | [0](https://community.sonatype.com/t/updated-course-malware-vs-vulnerabilities/15612/1) | 45 | [Sep 2025](https://community.sonatype.com/t/updated-course-malware-vs-vulnerabilities/15612/1) |
| [Protection from Recent npm Malware Attacks](https://community.sonatype.com/t/protection-from-recent-npm-malware-attacks/15579) | [1](https://community.sonatype.com/t/protection-from-recent-npm-malware-attacks/15579/1) | 365 | [Sep 2025](https://community.sonatype.com/t/protection-from-recent-npm-malware-attacks/15579/2) |
| [Error after upgrade to 3.83 NoSuchBeanDefinitionException GroupFacet Qualifier(“groupWriteFacet”)](https://community.sonatype.com/t/error-after-upgrade-to-3-83-nosuchbeandefinitionexception-groupfacet-qualifier-groupwritefacet/) | [1](https://community.sonatype.com/t/error-after-upgrade-to-3-83-nosuchbeandefinitionexception-groupfacet-qualifier-groupwritefacet/15403/1) | 261 | [Aug 2025](https://community.sonatype.com/t/error-after-upgrade-to-3-83-nosuchbeandefinitionexception-groupfacet-qualifier-groupwritefacet/15403/2) |