Re: BUG #18406: Connection issue after upgrading to postgres16

Dave Cramer <davecramer@postgres.rocks>

From: Dave Cramer <davecramer@postgres.rocks>
To: rajeev.raparthi@gmail.com, pgsql-bugs@lists.postgresql.org
Date: 2024-03-26T19:34:58Z
Lists: pgsql-bugs
On Mon, 25 Mar 2024 at 07:58, PG Bug reporting form <noreply@postgresql.org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      18406
> Logged by:          RAJEEV RAPARTHI
> Email address:      rajeev.raparthi@gmail.com
> PostgreSQL version: 16.0
> Operating system:   Linux
> Description:
>
> Hi Team ,
>
> We recently upgraded our postgres version from 11 to 16 , and we are
> encountering the connection issue after migration sporadically .
>         DriverManagerDataSource dataSource = new
> DriverManagerDataSource(getUrl(), username, getDbPassword());
>         dataSource.setDriverClassName("org.postgresql.Driver");
>
> We are observing the issue as "Caused by:
> org.hibernate.exception.JDBCConnectionException: Unable to acquire JDBC
> Connection [The connection attempt failed.] [n/a]"
>
> We are using db3.t3.small machine which has 2GB of RAM .
>

Do you have any more information?

There isn't enough information here to tell what is going wrong.
Dave Cramer
www.postgres.rocks