On Fri, Nov 30, 2007 at 10:33:04PM +0100, Bengt Frost wrote: > > Someone out there have any suggestions how use Postfix (and Dovecot) > with PostgreSQL?
Pull the user data from PostgreSQL and generate the files: /etc/sasldb2.db (copy to /var/spool/postfix/etc && postfix reload) /etc/cram-md5.pwd e.g: have a cron driven perl script check for changes to the user tables in the last 15 mins & if so, then generate new files. Stops PostgreSQL becoming a bottleneck when under high load (a spam attack). As your site grows, you can punt the flat files out across your mail farm from your central db/admin box, use rdist or something similar. DB down? DB backing up? No probs as mail still goes through until you are finished. Probably not the answers you are looking for.... -- Craig Skinner | http://www.kepax.co.uk | [EMAIL PROTECTED]
