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 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
