On Mon, 14 Jul 2003 04:24 pm, Bernie, CTA wrote: > On 14 Jul 2003 at 10:30, Peter Nixon wrote: > > Hi List > > > > I would like to take a quick straw poll. > > > > a) If you use a Database backend for FreeRadius which one do you > > use? > > We are an BSDi / Open BSD environment>>> > > Accounting - Redundant Postgres DB > == to other DBMS such as MySQL, Oracle its: > 1. No license fee > 2. Less Security Vulnerabilities > 3. Easier to replacate > 4. Lends to a Decentralized / Virtually Centralized DBMS > topology, which is better for security applications > 5. Better Transaction Processing Performance > 6. Less overhead > 7. Control of source > 8. Scales well > 9. Faster
Yep. No arguements from me on these :-) For general purpose DB work Postgres pretty much walks all over the competition when you take all these factors into account. I can only imagine needing to pay for a commercial DB if I was handling Terabytes of data. (Postgres happily handles many gigabytes of data per table for me currently) Do you mind telling me what replication system you use (Postgres has several) and how you find it? Are there any gotchas/problems? (I currently run my DBs standalone as I simply don't have the reliability issues with postgres that used to force me to replicate/cluster my MySQL boxes..) TIA -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
