Re: [HACKERS] connections problem

from log : LOG: could not fork new process for connection: Resource temporarily unavailable LOG: could not fork checkpoint process: Resource temporarily unavailable ulimit -a : core file size(blocks, -c) 0 data seg size (kbytes, -d) unlimited file size (block

Re: [HACKERS] connections problem

ivan <[EMAIL PROTECTED]> writes: > the error is : could not fork new process for connection: Resource > temporarily unavailable We could have saved some time if you'd spelled out the full error message to begin with. This is undoubtedly a kernel-imposed restriction you are running into. I'm not s

Re: [HACKERS] connections problem

> ivan <[EMAIL PROTECTED]> writes: >>> i need to connect to by my database more then 100 connections, >>> but after ~20-30 conn, postmaster says me "Resource temporarily >>> unavailable", what are this resource ? > ulimit -u = 256 , > it's ok, ? Mph. Well, that doesn't seem to be the problem, u

Re: [HACKERS] connections problem

ulimit -u = 256 , it's ok, ? On Fri, 26 Dec 2003, Tom Lane wrote: > ivan <[EMAIL PROTECTED]> writes: > > i need to connect to by my database more then 100 connections, > > but after ~20-30 conn, postmaster says me "Resource temporarily > > unavailable", what are this resource ? > > First bet is

Re: [HACKERS] connections problem

.. many others stuf ... the error is : could not fork new process for connection: Resource temporarily unavailable On Fri, 26 Dec 2003, Joshua D. Drake wrote: > Hello, > > Perhaps you have too many open files? What else is running on this > machine? > > Sincerely, > > Joshua D. Drake > > >

Re: [HACKERS] connections problem

Hello, Perhaps you have too many open files? What else is running on this machine? Sincerely, Joshua D. Drake ivan wrote: max_connections=200 shared_buffers=2000 ram = 500M + 300M swap hdd = infinite On Fri, 26 Dec 2003, Joshua D. Drake wrote: hi i need to connect to by my database more

Re: [HACKERS] connections problem

ivan <[EMAIL PROTECTED]> writes: > i need to connect to by my database more then 100 connections, > but after ~20-30 conn, postmaster says me "Resource temporarily > unavailable", what are this resource ? First bet is that you are running into a maximum-number-of-processes- per-user limit imposed

Re: [HACKERS] connections problem

max_connections=200 shared_buffers=2000 ram = 500M + 300M swap hdd = infinite On Fri, 26 Dec 2003, Joshua D. Drake wrote: > > >hi > > > >i need to connect to by my database more then 100 connections, > >but after ~20-30 conn, postmaster says me "Resource temporarily > > > > > >unavailable", wh

Re: [HACKERS] connections problem

hi i need to connect to by my database more then 100 connections, but after ~20-30 conn, postmaster says me "Resource temporarily unavailable", what are this resource ? We need more info. What does your postgresql.conf say about max_connections? How much ram do you have? How much shared mem

[HACKERS] connections problem

hi i need to connect to by my database more then 100 connections, but after ~20-30 conn, postmaster says me "Resource temporarily unavailable", what are this resource ? im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1) what can be wrong ? ---(end of bro