PostgreSQL backend: a waste of time?

[David Chait]

Rob,
    This may be unfesable for the immediate future, however it is not such a
bad idea for the long term. Especially if it could be made to work with
enterprise quality commercial databases. All of these replication problems
that have been going back and forth, and file system incompatibilities go
away. In addition it would add a lot of fault tollerance by allowing for
multiple front end machines as well as multiple database replicates.

-David

_____________________________________________________________

David Chait
Sys Admin  - Facilities Operations
333 Bonair Siding Road #107
Stanford CA, 94305
davidc at bonair.stanford.edu

----- Original Message -----
From: "Rob Siemborski" <rjs3 at andrew.cmu.edu>
To: "Nuno Silva" <nuno.silva at sectium.com>
Cc: "Nicola Ranaldo" <ranaldo at unina.it>; <info-cyrus at lists.andrew.cmu.edu>;
<Valery.Brasseur at atosorigin.com>
Sent: Friday, November 29, 2002 9:55 PM
Subject: Re: PostgreSQL backend: a waste of time?


> On Sat, 30 Nov 2002, Nuno Silva wrote:
>
> > I'm not 100% sure, but I suppose that one can virtualize the
> > connections. What I mean is: imapd (or pop3d or lmtpd...) wants to write
> > something -> ask the daemon and the daemon will choose a free connection
> > and commit those changes. This is the "one operation simple case".
> > Some of the DBs that cyrus maintains appear to be this simple (the
> > mailboxes file).
>
> Well, actually the mailboxes list requires transactions as well.
>
> > Other cyrus' DBs seem to require transactions (seen and delivery DB's)..
> > This makes it harder to manage with a single daemon connecting to a
> > RDBMS with onky a few connections.
> > CMU people or Ken: comments? :)
>
> All cyrusdb backends need to support transactions.
>
> That being said, I really think that using an RDBMS for the simple
> key/value pairings that cyrus needs is really unnecessary and reeks of "I
> want to use a buzzword" more than being a real solution.
>
> -Rob
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Rob Siemborski * Andrew Systems Group * Cyert Hall 207 * 412-268-7456
> Research Systems Programmer * /usr/contributed Gatekeeper
>
>
>