Am Di, den 02.11.2004 schrieb Chris Browne um 0:05: > [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.
_I_ know ;) > What _would_ seem sensible would be to use PG for the data store for > an IMAP server. that is, what dbmail tries to do. > 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... Indeed, looks conceptional perfect. Lets try it. Thanks for the hint! Regards Tino ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
