Re: Postfix/Maildrop and too many connections issues - Mailing list pgsql-general

From Roman Neuhauser
Subject Re: Postfix/Maildrop and too many connections issues
Date
Msg-id 20050627135554.GB38502@isis.sigpipe.cz
Whole thread Raw
In response to Re: Postfix/Maildrop and too many connections issues  (Sven Willenberger <sven@dmv.com>)
List pgsql-general
# sven@dmv.com / 2005-06-23 17:25:03 -0400:
> On Thu, 2005-06-23 at 03:39 +0000, Karl O. Pinc wrote:
> > On 06/22/2005 08:23:43 AM, Sven Willenberger wrote:
> > > On Wed, 2005-06-22 at 01:30 +0200, Roman Neuhauser wrote:
> > > > # sven@dmv.com / 2005-06-21 15:00:12 -0400:
> > > > > We have a system set up whereby postfix and maildrop gather
> > > > > user info from a pg database (7.4.2 on FreeBSD 5.2.1) to do
> > > > > local mail acceptance and delivery. I have configured max
> > > > > connections at 512 but I find that this is not enough and I
> > > > > get "connection limit exceeded for non-superusers" errors. I
> > > > > see upon ps ax that there are hundreds of idle connections
> > > > > (state I).

    [...]

> I just realized however that once postifx looks up the user in
> transport it hands the mail off to maildrop which then has to do its
> own db lookup for the home directory, etc and I cannot see how I would
> configure this to use proxymap.

    *That* is where something like
    http://pgpool.projects.postgresql.org/ would be useful.

> Well at least I have consolidated some of the lookups ...

    True.

--
How many Vietnam vets does it take to screw in a light bulb?
You don't know, man.  You don't KNOW.
Cause you weren't THERE.             http://bash.org/?255991

pgsql-general by date:

Previous
From: "Zlatko Matic"
Date:
Subject: Re: automating backup ?
Next
From: Douglas McNaught
Date:
Subject: Re: Tablespaces across same raid...