DB connection issue suggestions

2022-05-10 Thread Sudhir Guna
Dear All, We have recently upgraded Postgresql 9.4 standalone server to Postgresql 11.2 with High Availability (2 servers : Master and Standby). While trying to test using ETL applications and reports, we observe that the ETL jobs fails with below error, 2022/05/06 16:27:36 - Error occurred whi

Re: DB connection issue suggestions

2022-05-11 Thread Sudhir Guna
Hi Ranier, Thank you for reviewing this. Yes this is Pentaho and SSRS application. We are currently using postgresql-42.2.4.jar currently. Regards, Guna On Wed, May 11, 2022 at 2:55 AM Ranier Vilela wrote: > > > Em ter., 10 de mai. de 2022 às 14:49, Sudhir Guna < > sudhir.gu

Re: DB connection issue suggestions

2022-05-11 Thread Sudhir Guna
05/10/2022 12:59 PM Sudhir Guna wrote: > > > Dear All, > > We have recently upgraded Postgresql 9.4 standalone server to Postgresql > 11.2 with High Availability (2 servers : Master and Standby). > > While trying to test using ETL applications and reports, we observe that >

Re: DB connection issue suggestions

2022-05-11 Thread Sudhir Guna
database_name, client_addr as client_address, application_name, backend_start, state, state_change from pg_stat_activity; Regards, Guna On Wed, May 11, 2022 at 2:15 AM Justin Pryzby wrote: > On Wed, May 11, 2022 at 12:59:01AM +0800, Sudhir Guna wrote: > > Dear All, > > > > We h

Re: DB connection issue suggestions

2022-05-11 Thread Sudhir Guna
Hi Ranier, We have tried to upgrade the postgresql- 42.3.5 .jarand unfortunately the issue still persists. Regards, Guna On Wed, May 11, 2022 at 9:44 AM Sudhir Guna wrote: > Hi Ranier, > > Thank you for reviewing this. > > Yes this is Pentaho and SSRS application. > > W

Re: DB connection issue suggestions

2022-05-11 Thread Sudhir Guna
node have any impact to this ? [image: image.png] Regards, Guna On Thu, May 12, 2022 at 3:09 AM Justin Pryzby wrote: > On Wed, May 11, 2022 at 09:52:10AM +0800, Sudhir Guna wrote: > > Hi Justin, > > > > Thank you for reviewing. > > > > I have tried to run the belo