[EMAIL PROTECTED] (Tino Wildenhain) writes: > Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02: >> On Thu, 28 Oct 2004 04:14 am, Eric wrote: >> > Is there something to interface postgreSQL with QMail to store mails in >> > pgsql instead of using mbox or maildir? >> > >> > Or maybe it's not a good idea to do that? >> > >> > I think there is some adavantages... >> >> also look at http://www.dbmail.org/ > > Do you know anything else? dbmail seems too much mysql > centric while at least providing access to postgresql > which is a pro. The storage of mails in big chunks > seems less then ideal and you need clever views to > get local part and host seperately.
I seriously question the merits of interfacing qmail with PostgreSQL; qmail is "merely" an MTA, and is basically where mail would get _queued_ until it is delivered to someone's 'mailbox.' qmail isn't a 'mailbox manager,' so using PG as the data store for qmail just doesn't seem sensible. What _would_ seem sensible would be to use PG for the data store for an IMAP server. The most relevant one would seem to be Decimail: <http://decimail.org/> Decimail... * Is an IMAP / SMTP email server. * Uses a PostgreSQL database to store the messages. * Defines mailboxes using SQL queries. The way it handles mailboxes is very interesting... -- let name="cbbrowne" and tld="cbbrowne.com" in String.concat "@" [name;tld];; http://www.ntlug.org/~cbbrowne/linuxxian.html A VAX is virtually a computer, but not quite. ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match