In Ubuntu 14.04 server on a JAVA application we are getting Too many Open files error for Postgres (Using Postgresql 9.5).
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
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 100268. 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 not affected because still we are getting "Too many Open files" error.
Also in Server the directories /etc/security/limits.d/ and /etc/security/conf.d/ and empty. So can anyone please guide me.