TechOverflow Logo
TechOverflow

Sonatype Nexus migration from built-in OrientDB to PostgreSQL in separate container

Note: This post is mostly just a collection of commands I’ve tried. I am not 100% sure what the correct way to do this is, but this worked out for me in the end. Ensure to backup your data before trying!

Based on the official Sonatype migration instructions and our 5-minute Nexus configuration but adapted for Docker.

Ensure Nexus is running in version 3.70.0 and add depends_on to the Nexus service in docker-compose.yml:

nexus_postgres_migration.yml
 nexus:
    image: sonatype/nexus3:3.70.0
    # ...
    depends_on:
      - postgres

Add config for Postgres to .env

example.sh
POSTGRES_DB=nexus
POSTGRES_USER=nexus
POSTGRES_PASSWORD=ahyath1thaem4Aedaemeoph5Aadohb

Add datastore config to nexus_data/etc/nexus.properties:

example.ini
nexus.datastore.enabled=true

Add PostgreSQL connection string to nexus_data/etc/fabric/nexus-store.properties:

example.ini
username=nexus
password=ahyath1thaem4Aedaemeoph5Aadohb
jdbcUrl=jdbc\:postgresql\://postgres\:5432/nexus

Add PostgreSQL container

example.yml
services:
  postgres:
    image: postgres
    restart: unless-stopped
    volumes:
      - ./pg_data:/var/lib/postgresql/data
    environment:
      - POSTGRES_PASSWORD=${POSTGRES_PASSWORD}
      - POSTGRES_DB=${POSTGRES_DB}
      - POSTGRES_USER=${POSTGRES_USER}

Download migrator into mapped data directory

example.sh
cd nexus_data
wget https://download.sonatype.com/nexus/nxrm3-migrator/nexus-db-migrator-3.72.0-01.jar
cd ..

Run migrator

example.sh
docker-compose run nexus /bin/bash -c 'java -Xmx16G -Xms16G -XX:+UseG1GC -XX:MaxDirectMemorySize=28672M -jar /nexus-data/nexus-db-migrator-* --migration_type=postgres --db_url="jdbc:postgresql://postgres:5432/nexus?user=nexus&password=ahyath1thaem4Aedaemeoph5Aadohb"'
Check out similar posts by category: Docker