Database migration Orientdb to PostgreSQL - two questions

Sonatype Nexus Repository
, ,
1

Hi,

1 - Because i’m intending to migrate from Orientdb to Postgresql i refer to Migrating to a New Database, but it tell us only to migrate to an external database. I’m wondering… is it possible to migrate to an internal postgresql database? So the data remains on the same server .

2 - When an external database is the only option, am i able to install Postgresql on a Windows server and connect this to a Nexus instance on a Linux machine?

Thanks in advance.

With regards, Will

2

IMHO there is no difference running Nexus with databases hosted on the same or different servers, as long as your server is good enough to handle both services. The documentation even mentions PostgreSQL running on the same host:

https://help.sonatype.com/en/install-nexus-repository-with-postgresql.html#UUID-53952e66-a199-d697-995f-422ebf084c98_bridgehead-idm23476372161804

  • database-host
    The database server address (e.g., localhost or an IP address).

Of course could also run PostgreSQL on Windows, if needed.

With kind regards,
Ralf

1 Like
3

External is a reference to the database being out of process (as opposed to in-process for OrientDB and H2) as opposed to host related.

You can run Nexus on the same host if you choose, but note if you’re using the official Docker image that does not contain PostgreSQL.

4

Hi Ralf,

So , if i use the url of our Nexus server in the JDBC-property and put it in nexus-store.properties then it is sufficient?
Thank you.

Regards, Will