Hi all,

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:\
        :datasize-max=1024M:\
        :datasize-cur=256M:\
        :stacksize-cur=16M:

Is 1536 now too many openfiles?

I dropped openfiles-cur to 768 as suggested in the pkg_readme and the error has stopped. I'm sure I had a reason for doubling it way back when because this is a pretty busy postgresql server.

Didn't see anything in the FAQ or in a google search for this error.

Thanks,

Jeff Ross

Reply via email to