Re: 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
>
>
> 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 majordomo(at)postgresql(dot)org 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 - jd(at)commandprompt(dot)com - 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 - jd(at)commandprompt(dot)com - http://www.commandprompt.com
>
>