.. 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 > > > 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 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 memory have you allocated? > >> > >>Sincerely, > >> > >> > >>Joshua D. Drake > >> > >> > >> > >> > >> > >> > >>>im using debain with kernel 2.4.23-pre7, on P4 , (postgres 7.4.1) > >>>what can be wrong ? > >>> > >>> > >>> > >>>---------------------------(end of broadcast)--------------------------- > >>>TIP 3: if posting/reading through Usenet, please send an appropriate > >>> subscribe-nomail command to [EMAIL PROTECTED] so that your > >>> message can get through to the mailing list cleanly > >>> > >>> > >>> > >>> > >>-- > >>Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC > >>Postgresql support, programming, shared hosting and dedicated hosting. > >>+1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com > >> > >> > >> > >> > > > >---------------------------(end of broadcast)--------------------------- > >TIP 7: don't forget to increase your free space map settings > > > > > > -- > Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC - S/JDBC > Postgresql support, programming, shared hosting and dedicated hosting. > +1-503-222-2783 - [EMAIL PROTECTED] - http://www.commandprompt.com > > ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
