Re: Postfix DBD Help - ReadList.com

2 msg	hash table not matching subdomains
18 msg	Non-delivery problem
3 msg	tracing mail
5 msg	different SMTP ip sender in one instance of pos...
18 msg	Three Postfix Errors
10 msg	Conditional relay to a barracuda spam filter
2 msg	Postfix as honeypot
3 msg	postqueue -p
17 msg	Patch to pas all the recipients of a mail to th...

Postfix DBD Help
\ Linux Addict (16 Nov 2007)
. \ mouss (16 Nov 2007)
. . \ Linux Addict (16 Nov 2007)
. . . \ Dave McGuire (16 Nov 2007)
. . . \ mouss (16 Nov 2007)

4 msg	Send and receive mail on different ports?
3 msg	postfix behind a router
1 msg	postfix to access mail from external host.
4 msg	Three installation/configuration issues
9 msg	Reject SMTP connection if two RBL match
3 msg	Holding Large Emails
9 msg	Monitor Relaying
7 msg	Sender address rejected when sending messages t...
1 msg	Problem using Postfix with LDAP using STARTTLS
7 msg	resources for 'only virtual domains'

Subject:	Re: Postfix DBD Help
Group:	Postfix-users
From:	mouss
Date:	16 Nov 2007

Linux Addict wrote:
>> Linux Addict wrote:
>>> Hi, I have been setting up a multi location Postfix mail relay setup
>>> w/ virtual aliases/domains.
>>>
>>> Each location will have two servers.
>>>
>>> Choosen Berkley DB over mysql for better performance.
>>>
>> "premature optimization is the root of all evil".
>
> Thanks Mouss for reponse!
>
> Powertools are always dangerous!!! Do we really need a RDMBS to just
> store such a simple information?
>

Did I ever said so? My reply is to be understood in the context of your
"... for better performance". If the only reason to avoid mysql is
performance, then the argument doesn't stand unless you _measure_ and
find that mysql would reduce the performances of your system.

>>> Now, I am trying work out a replication b/w sites. All BDB docs seems
>>> to direct at some API way of doing replication. Any ideas?
>>>
>> use rsync to copy the source file and run postmap (via ssh) on each
>> server. if that's too much, use sql/ldap ;-p
>
> Well. This is what I was planning.. rsync over ssh. was wondering if
> there is something better than this..
>

Note also that you need to be careful about ownership, permissions and
remote access control.

>>> And also anyone knows a GUI which can update the aliases of a postfix
>>> setup which uses BDB.
>> maybe webmin has a module for this.
>>
>
> Yep.. Webmin has this on "other" section. But I am not too comfortable
> with running webmin as this internet facing.
>

one of the advantages of an RDBMS is the ability to remotely administer
data without having to play risky games with system access.

That said, it shouldn't be difficult to write a php/perl web UI for file
based DBs, if you setup ownership and permissions correctly, and if you
make sure the webserver can't do unauthorized things (the maps would be
accessible to the webserver, so it's better to have a dedicated
webserver, something like webmin approach). One issue here is that if
the db file is large...

also, if you take this road, then it's better to use cdb!