From: | ivan <iv(at)psycho(dot)pl> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: connections problem |
Date: | 2003-12-26 19:13:24 |
Message-ID: | Pine.LNX.4.56.0312262011310.18519@rex.anfa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-12-26 19:14:22 | Re: connections problem |
Previous Message | Martin Marques | 2003-12-26 19:11:54 | Re: Is my MySQL Gaining ? |