Re: Increasing max connections

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dave Disser <disser(at)san(dot)rr(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Increasing max connections
Date: 2001-04-14 01:37:16
Message-ID: 9353.987212236@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Dave Disser <disser(at)san(dot)rr(dot)com> writes:
> I'm running 7.0.2 on HPUX 10.20. I'd like to use persistent
> connections from my web server, but find myself with too many backends
> as a result.

> I tried using the -N 96 -B 192 options for postmaster, but the backends seem
> to die mysteriously if I have any more than 32 max backends.

Hm. I've run many more than that on HPUX 10.20 ... possibly you are
running out of swap space or kernel file table slots? Or just plain old
MAXUPRC (processes per user) limit?

The failures might be less mysterious if you look in the postmaster's
logfile (you are not starting it with -S, I hope, else you won't get
any log output).

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message N@ta$ 2001-04-15 23:44:04 DBD and DBI::Pg
Previous Message Tom Lane 2001-04-13 17:08:39 Re: Buggy SELEC ... FROM UPDATE ?