PostgreSQL timeout

Hi, I’m using a render PostgreSQL for my java spring-boot app.

After running the app, after several minutes I’m getting the following errors:

HikariPool-1 - Failed to validate connection org.postgresql.jdbc.PgConnection@6841a9bc (This connection has been closed.). Possibly consider using a shorter maxLifetime value.

Probably the problem is that Hikari has 30 minutes for maxLifetime property by default.

Do you know what a connection timeout for the render PostgreSQL is? What value should I set for maxLifetime property to avoid these errors?

Thanks in advance.
Dominik

1 Like

Hey Dominik,

Is this a connection from outside Render to a Postgres DB running on us?

Regards,

John B