From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | Alexandre Barros <alexandre(at)vectorx(dot)com(dot)br> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PostgreSQL 8.0.3 limiting max_connections to 64 ? |
Date: | 2005-08-18 18:02:43 |
Message-ID: | 9430.1124388163@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Alexandre Barros <alexandre(at)vectorx(dot)com(dot)br> writes:
> [ can't get more than 64 connections ]
Have you looked into the postmaster log (stderr or syslog output) to
see if any error conditions are being reported?
It occurs to me that the postmaster might be running in an account that
has a max-number-of-user-processes limit. On machines where such limits
are enforced, 70 or so is a pretty common value, so that would fit with
your experience. I can't tell you exactly how to check or change that
limit, because it's different on different variants of Unix, but it's
something to look into. If this is the problem, you'd be seeing "fork
failed" messages in the postmaster log.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Bill Moseley | 2005-08-18 18:06:23 | Re: Waiting on a transaction |
Previous Message | Peter Fein | 2005-08-18 17:36:26 | Timing out connections? |