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

Started by Serkan Bektaşalmost 24 years ago7 messagesgeneral
Jump to latest
#1Serkan Bektaş
sbektas@karincaint.com.tr

Hi all,

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

regards, Serkan Bekta�

#2Doug Fields
dfields-pg-general@pexicom.com
In reply to: Serkan Bektaş (#1)
Re: Is there eny e-mail server that uses postgreSQL

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

#3Rich Shepard
rshepard@appl-ecosys.com
In reply to: Doug Fields (#2)
Re: Is there eny e-mail server that uses postgreSQL

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&gt;

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

In reply to: Rich Shepard (#3)
Re: 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&gt;

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

In reply to: Mathieu Arnold (#4)
Re: Is there eny e-mail server that uses postgreSQL

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

#6Serkan Bektaş
sbektas@karincaint.com.tr
In reply to: Mathieu Arnold (#4)
Re: Is there eny e-mail server that uses postgreSQL

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&gt;

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

#7Doug Fields
dfields-pg-general@pexicom.com
In reply to: Serkan Bektaş (#6)
Re: Is there eny e-mail server that uses postgreSQL

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