Re: DB connection issue suggestions

Hi Justin, Yes , I have checked pg_stat_activity from both the master node and the standby node server and the total rows of the connection doesn't even exceed 10. Sorry the OS is Red Hat Enterprise Linux Server 7.5 (Maipo). Does the streaming replication between the master and standby node have

Re: DB connection issue suggestions

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 below query and could see only less than 5 > connections active when I get this error. The total rows I see is only 10 > including idle and active sessions for this o

Re: DB connection issue suggestions

Em qua., 11 de mai. de 2022 às 04:18, Sudhir Guna escreveu: > Hi MichaelDBA, > > Thank you for reviewing. > > I had validated the show max_connections and its 1000. > I think that you are wasting resources with this configuration. Try enabling Connection Pool at Pentaho configuration. And set the

Re: DB connection issue suggestions

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. > > We are currently using po

Re: DB connection issue suggestions

Hi Justin, Thank you for reviewing. I have tried to run the below query and could see only less than 5 connections active when I get this error. The total rows I see is only 10 including idle and active sessions for this output. select pid as process_id, usename as username, datname as database_

Re: DB connection issue suggestions

Hi MichaelDBA, Thank you for reviewing. I had validated the show max_connections and its 1000. [image: image.png] Regards, Guna On Wed, May 11, 2022 at 2:13 AM MichaelDBA Vitale wrote: > Please show output of "show max_connections" to validate your assumptions. > > On 05/10/2022 12:59 PM Su

Re: DB connection issue suggestions

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.guna...@gmail.com>