Nexus repository pro connection with PostgreSQL

post by muhammad.zeeshan on Aug 20, 2021

I am trying to make a connection nexus repository with PostgreSQL but connection fails every time

Error: 2021-08-20 17:25:04,563+0500 ERROR [FelixStartLevel] *SYSTEM com.zaxxer.hikari.pool.HikariPool - nexus - Exception during pool initialization.

org.postgresql.util.PSQLException: The connection attempt failed.

I have tried the EKS use-case mentioned in nexus documentation it’s not showing any error but Postgres not attach with nexus

is there any resources or guideline for Postgres connection with nexus repo pro?

post by dsawa on Aug 20, 2021

Hi Muhammad,

You can find information on how to configure your Nexus Repository database connection in our documentation: Configuring Nexus Repository Pro for H2 or PostgreSQL

Please let us know if you still have any problems.

post by muhammad.zeeshan on Aug 20, 2021

Thanks @dsawa article was very helpful

I have successfully connected nexus with RDS PostgreSQL. but the issue I’m facing, I am trying to connect two EC2 Sonatype with the same PostgreSQL. but the data upload from EC2-A is not visible to EC2-B until I don’t restart the nexus

in simple I’m trying to make an active-active approach.

post by dsawa on Aug 20, 2021

Unfortunately that is correct, because active-active deployment model is not supported yet. We are designing a new active-active model that will be available in the future.

post by muhammad.zeeshan on Aug 20, 2021

Oh sure waiting for this feature

Thanks for the help