# sven@xxxxxxx / 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@xxxxxxx / 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings