Ict Security wrote: > i have two identical Postgresql 9.6.1 and i need, to test an > application, to reach connection above 1024. > > I setup 2400 as max_connections
Ugh. Don't. Use a connection pool. > I raised file-max kernel limit to 65535 > I increased shared_buffers > I also increased the value in semaphores in both > And i added this in limits.conf: > * - nofile 999999 > > But - and it is really strange - in machine nr. 1 i can start > thousands of connections while in machine nr. 2 after 1024 connections > Postgres does not accept anything else. What is the error message in the log? What do you see in /proc/12345/limits and /proc/12345/cgroup (assuming that your postmaster PID is 12345)? Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
