Re: [GENERAL] Resource temporarily unavailable

2004-10-31 Thread Ben-Nes Michael
> > > > max_connections = 400 > > > > www3:/etc/postgresql# ulimit -a > > max user processes(-u) 256 > > > im totaly bogus, any ideas ? > > > > Well, your allowing postgres to have 400 connection which is at least 400 processes if not a few more. > And you are ulimiting the postgres us

Re: [GENERAL] Resource temporarily unavailable

2004-10-29 Thread Russell Smith
> > max_connections = 400 > > www3:/etc/postgresql# ulimit -a > max user processes(-u) 256 > im totaly bogus, any ideas ? > Well, your allowing postgres to have 400 connection which is at least 400 processes if not a few more. And you are ulimiting the postgres user to 256 proces

Re: [GENERAL] Resource temporarily unavailable

2004-10-27 Thread Tom Lane
"Ben-Nes Michael" <[EMAIL PROTECTED]> writes: > From time to time i get the following error: > could not fork new process for connection: Resource temporarily unavailable This generally means that the kernel has run out of memory. > my conf is: > max_connections = 400 Perhaps that is overly opti