Re: max_connections parameter: too_many_connections error

2019-09-17 Thread Rui DeSousa
> On Sep 17, 2019, at 8:43 AM, Shital A wrote: > > Hello, > > We are working on a payments systems which uses postgreSql 9.6 as backend DB > and blockchain technology. The database is setup in HA in master-standby mode > using pacemaker on Linux 7.6. > > We are new to postgres and need help

RE: max_connections parameter: too_many_connections error

2019-09-17 Thread Scot Kreienkamp
1. How can we decide on optimal value for max_connections for a given setup/server? I checked many posts saying that even 1000 is considered as a very high value but we are hitting the error too_many_connections due to Max_connections value limit. I have one set at 1000 but I usually top out