In Ubuntu 14.04 server on a JAVA Application we are getting Too many Open files error for postgres.
We set the following in /etc/security/limits.conf
* soft nofile 16384
* hard nofile 16384
root soft nofile 16384
root hard nofile 16384
postgres soft nofile 16384
postgres hard nofile 16384
Also set the following in /etc/sysctl.conf
kern.maxfiles=20480
kern.maxfilesperproc=18000
Also please see the following results while running as postgres user:
-> ulimit -Hn
16384
-> ulimit -Sn
16384
-> cat /proc/sys/fs/file-max
100268
After restarting the server and checking the ulimit for postgres its 16384 But while checking the limit for opened files under postgres process its still 1024 and 4096
# cat /proc/1072/limits
Max open files 1024 4096 files
When we restart postgres services it got changed to
#cat /proc/1759/limits
Max open files 16384 16384 files
But it seems its snot affected because still we are getting Too many Open files error. So can anyone please guide me.
We set the following in /etc/security/limits.conf
* soft nofile 16384
* hard nofile 16384
root soft nofile 16384
root hard nofile 16384
postgres soft nofile 16384
postgres hard nofile 16384
Also set the following in /etc/sysctl.conf
kern.maxfiles=20480
kern.maxfilesperproc=18000
Also please see the following results while running as postgres user:
-> ulimit -Hn
16384
-> ulimit -Sn
16384
-> cat /proc/sys/fs/file-max
100268
After restarting the server and checking the ulimit for postgres its 16384 But while checking the limit for opened files under postgres process its still 1024 and 4096
# cat /proc/1072/limits
Max open files 1024 4096 files
When we restart postgres services it got changed to
#cat /proc/1759/limits
Max open files 16384 16384 files
But it seems its snot affected because still we are getting Too many Open files error. So can anyone please guide me.
Thanks