Database migration Orientdb to PostgreSQL - two questions

post by Will on Apr 19, 2025

Hi,

1 - Because i’m intending to migrate from Orientdb to Postgresql i refer to Migrating to a New Database, but it tells 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

post by Ralf_Schuchardt on Apr 21, 2025

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:

Documentation Reference

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

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

With kind regards,

Ralf

post by mpiggott on Apr 21, 2025

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.

post by Will on Apr 22, 2025

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