[Bug]: connection to server at "postgres" port 5432 failed

[tlenclos]

Error Message and Logs

After deploying a docker compose app, the coolify instance got a lot of issues with PostgreSQL

SQLSTATE[08006] [7] connection to server at "postgres" (172.18.0.24), port 5432 failed: FATAL: password authentication failed for user "coolify" (Connection: pgsql, SQL: select * from "sessions" where "id" = HgV3zhLurWyiu8k8UJgM2dEmy6JXWRlNg0E1k7uG limit 1)

Steps to Reproduce

I deployed a docker compose app with Nextjs + Postgresql and then got the issue.

All deployed apps are okay but I'm stuck outside of the Coolify instance sadly.
Sometimes on refresh I can do some actions but got a 500 error really fast, either in a modal or full page.

Example Repository URL

No response

Coolify Version

v4.0.0-beta.390

Are you using Coolify Cloud?

No (self-hosted)

Operating System and Version (self-hosted)

Debian GNU/Linux 10 (buster)

Additional Information

No response

[djsisson]

This will happen if your compose has a service with the name postgres and you add it to the coolify network, since there is already an existing service with that name docker dns will alternate between the two

To solve either do not put your project in the coolify network or rename the postgre service in your compose.

You will need to stop the extra postgres container in the coolify network

Run docker ps to get the id you need to stop

[tlenclos]

Thank you so much ! I managed to stop the new project in the UI with a bit of refreshing.

Do you know if there is an issue about validating a docker compose to avoid this issue ?

[andrasbacsai]

Oh, nice catch. I can easily fix this but setting the default DB_HOST for Coolify to be coolify-db and not postgres.

I will test it and add it to the next version if everything works.