From: | Sven Willenberger <sven(at)dmv(dot)com> |
---|---|
To: | "Karl O(dot) Pinc" <kop(at)meme(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Postfix/Maildrop and too many connections issues |
Date: | 2005-06-23 21:25:03 |
Message-ID: | 1119561903.16492.34.camel@lanshark.dmv.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)dmv(dot)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).
> > > >
> > > > Is there any way on the server end to close these connections (the
> > > > process is apparently for postfix and then maildrop to open a
> > > > connection, run one select statement, and supposedly close the
> > > > connection).
> > >
> > > You are barking up the wrong software. See proxymap(8). (It's
> > > mentioned in http://www.postfix.org/PGSQL_README.html)
> > >
> > Thanks for the tip ... edited my main.cf so that transport,aliases,
> > etc
> > use proxymap so this should help somewhat. Apparently in version 2.2.
> > it
> > is safe to use for UIDs/maildirs/paths etc so I may have to make the
> > upgrade leap.
>
> I _believe_ 2.2 is safe to _configure_, but the various daemons
> will do lookups directly without going through proxymap. So
> there's no "extra" help, you still need to limit the number
> of these running daemons. (Although maybe they eache cache
> the connection themselves reducing the number of opens and
> closes? ?)
>
> That's how I read the docs.
>
I guess my understanding was that whichever portions in main.cf I would
prefix with proxy: would send their requests through proxymap. 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. Well at least I have consolidated some of the
lookups ...
Sven
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Darley | 2005-06-23 22:13:04 | Re: Perl DBI issue |
Previous Message | SCassidy | 2005-06-23 19:50:00 | Re: setting up PostgreSQL on Linux RHL9 to allow ODBC |