On Thu, Apr 25, 2013 at 1:05 PM, Jeff Ross <jr...@wykids.org> wrote: > I installed a snapshot last night on our server at work and since then I'm > getting an error whenever a user logs in over ssh. > > 013-04-25 13:40:37.284728500 auth.info: sshd[222]: Accepted publickey for > jross from 10.16.31.10 port 51645 ssh2 > 2013-04-25 13:40:37.289644500 user.err: Apr 25 13:40:37 sshd: postgresql: > setting resource limit openfiles: Invalid argument > > The postgresql section of my login.conf is: > > # For PostgreSQL Database > # > postgresql:\ > :maxproc-max=1024:\ > :maxproc-cur=512:\ > :openfiles-cur=1536:\ ... > Is 1536 now too many openfiles?
No. The problem is that you can't set the '-cur' value to greater than the '-max' value, which defaults to 1024. If you want to set both to that same higher value, then say "openfiles=1536". Otherwise, add another line to set 'openfiles-max' to whatever larger value you desire. Philip Guenther