From: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
---|---|
To: | ivan <iv(at)psycho(dot)pl> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: connections problem |
Date: | 2003-12-26 19:17:55 |
Message-ID: | 3FEC8963.50800@commandprompt.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | markw | 2003-12-26 19:19:21 | DBT-2 PostgreSQL on STP w/ LVM2 |
Previous Message | Joshua D. Drake | 2003-12-26 19:15:55 | Re: Is my MySQL Gaining ? |