Обсуждение: Is there eny e-mail server that uses postgreSQL as backend server for mailboxes&users

Hi all,

Is there eny e-mail server that uses postgreSQL as backend server for
mailboxes&users

regards, Serkan Bektaş

----- Original Message -----
From: "Serkan Bektaş"

>
> Hi all,
>
> Is there eny e-mail server that uses postgreSQL as backend server for
> mailboxes&users
>

try  http://blue-labs.org/clue/sendmail.php

hth,

    Marin

----
"...what you brought from your past, is of no use in your present. When
you must choose a new path, do not bring old experiences with you.
Those who strike out afresh, but who attempt to retain a little of the
old life, end up torn apart by their own memories. "

>Is there eny e-mail server that uses postgreSQL as backend server for
>mailboxes&users

I use Exim

www.exim.org

Very easy, very quick.

Doug

On Thu, 16 May 2002, Doug Fields wrote:

> >Is there eny e-mail server that uses postgreSQL as backend server for
> >mailboxes&users
>
> I use Exim

  Postfix works with postgres, too. <http://www.postfix.org>

Rich

Dr. Richard B. Shepard, President

                       Applied Ecosystem Services, Inc. (TM)
            2404 SW 22nd Street | Troutdale, OR 97060-1247 | U.S.A.
 + 1 503-667-4517 (voice) | + 1 503-667-8863 (fax) | rshepard@appl-ecosys.com
                         http://www.appl-ecosys.com

--On jeudi 16 mai 2002 09:35 -0700 Rich Shepard <rshepard@appl-ecosys.com>
wrote:

> On Thu, 16 May 2002, Doug Fields wrote:
>
>> > Is there eny e-mail server that uses postgreSQL as backend server for
>> > mailboxes&users
>>
>> I use Exim
>
>   Postfix works with postgres, too. <http://www.postfix.org>

yup, I've been maintaining this patch for 2 years now, you can find linux
rpms, it's also in the freebsd ports tree.

--
Mathieu Arnold

I looked at some patches, but I couldn't find enough description.

I want to know ;
* Can we use PostgreSQL to store user data and do authentication?
* Can we use PostgreSQL to store all e-mails (Inboxes & Sent Items)

I want to use this data to create reports about e-mails
 e.g. : Customer Contacts Reports

I'm using freebsd4.4&sendmail

What do you suggest ?

Thank you for your help

regards, Serkan Bektas




-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org]On Behalf Of Mathieu Arnold
Sent: Friday, May 17, 2002 9:00 AM
To: Rich Shepard; Doug Fields
Cc: Serkan Bektaþ; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Is there eny e-mail server that uses postgreSQL



--On jeudi 16 mai 2002 09:35 -0700 Rich Shepard <rshepard@appl-ecosys.com>
wrote:

> On Thu, 16 May 2002, Doug Fields wrote:
>
>> > Is there eny e-mail server that uses postgreSQL as backend server for
>> > mailboxes&users
>>
>> I use Exim
>
>   Postfix works with postgres, too. <http://www.postfix.org>

yup, I've been maintaining this patch for 2 years now, you can find linux
rpms, it's also in the freebsd ports tree.

--
Mathieu Arnold

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

--On samedi 18 mai 2002 16:42 +0300 Serkan Bektaþ
<sbektas@karincaint.com.tr> wrote:

>
> I looked at some patches, but I couldn't find enough description.
>
> I want to know ;
> * Can we use PostgreSQL to store user data and do authentication?
> * Can we use PostgreSQL to store all e-mails (Inboxes & Sent Items)
>
> I want to use this data to create reports about e-mails
>  e.g. : Customer Contacts Reports
>
> I'm using freebsd4.4&sendmail
>
> What do you suggest ?

I don't know why you want to store everything into a database, but it is
IMHO not a good idea. If you still want to do it, have a look at :
http://www.dbmail.org/
It should work with postgresql.

--
Mathieu Arnold

>I looked at some patches, but I couldn't find enough description.
>
>I want to know ;
>* Can we use PostgreSQL to store user data and do authentication?

As I mentioned earlier, you can use Exim (www.exim.org) to do this. It has
a built in PostgreSQL connector, and you can use it's
super-ultra-mega-configurable configuration file to do almost anything you
want. For example, I use Exim to retrieve "virtual" user information (users
without /etc/password info) and then feed it into "maildir" compatible
formats for retrieval by IMAP server software.

>* Can we use PostgreSQL to store all e-mails (Inboxes & Sent Items)

You can do whatever you want, but chances are you will have to write your
own "local delivery" software if you want to do this - although someone
else had a suggestion.

Cheers,

Doug