On 4/25/13 2:43 PM, Philip Guenther wrote:
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
Ah--that makes perfect sense! Thanks Philip!
