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...



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

* Eric <ericg (AT) conceptid (DOT) ca> [2004-10-27 14:14:25 -0400]:

This looks informative:

http://qmail-sql.digibel.be/

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

On Thu, 28 Oct 2004 04:14 am, Eric wrote:
also look at http://www.dbmail.org/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Hi,

Am Sa, den 30.10.2004 schrieb Russell Smith um 8:02:
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.

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

We were able to put something together fairly easily in Perl
which has excellent (if you like perl) facilities for dealing
with multi-part mime etc...

Sorry it was for a customer so we can't provide source. However
I know it only took us about 3 days and it has been in place for
2 years without issue.

Sincerely,

Joshua D. Drake



--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd (AT) commandprompt (DOT) com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL



---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

On Wed, 2004-10-27 at 14:14 -0400, Eric wrote:
We use QMail for our vhosting and it works quite well. We have plans to
move the storage into PostgreSQL at some point.

This is on the QMail.org site:

ftp://ftp.tummy.com/pub/tummy/Mail2DB/

You will

hth,

-Robby


--
/***************************************
* Robby Russell | Owner.Developer.Geek
* PLANET ARGON | www.planetargon.com
* Portland, OR | robby (AT) planetargon (DOT) com
* 503.351.4730 | blog.planetargon.com
* PHP/PostgreSQL Hosting & Development
* --- Now supporting PHP5 ---
****************************************/

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.6 (GNU/Linux)

iD8DBQBBg8oO0QaQZBaqXgwRAioUAJ4v0opG2zWyBcPw0pU5zp FRWAUakwCgntY/
+ldTPAT5+4fwNyFEGS42uVc=
=4vuc
-----END PGP SIGNATURE-----

Hi,

Am Sa, den 30.10.2004 schrieb Joshua D. Drake um 18:25:
Thx, even with python the email/mime/multipart handling is no
issue. The problem comes with IMAP _server_ support. Client
libs are available too. Does your solution provide IMAP
access with ordinary mail clients?

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

tino (AT) wildenhain (DOT) de (Tino Wildenhain) writes:
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.

Am Di, den 02.11.2004 schrieb Chris Browne um 0:05:
_I_ know

that is, what dbmail tries to do.

Indeed, looks conceptional perfect. Lets try it.
Thanks for the hint!

Regards
Tino


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend