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

BUG #18406: Connection issue after upgrading to postgres16

From
PG Bug reporting form
Date:
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 .


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

From
Dave Cramer
Date:


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