Too many Open files error for postgres

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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.

Thanks
Geo

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux