Jeff Marder wrote: > I'm wondering what the advantages are to running Trac on Postgres versus > SQLite. Do they outweigh the added administrative overhead? Can anyone > using Postgres with Trac share any insight about their experience? This > may be answered in the wiki, but a quick search didn't turn up anything. > Any input or a link pointing me in the right direction would be appreciated.
I think that the biggest advantage seems to be fewer (none?) database locked errors that occur with SQLite. As far as adminstrative overhead, it's not much. If you have postgresql already installed, they only "administration" that needs to be done is to create a db before running trac-admin. And then on upgrades, you need to specify --no-backup, as trac-admin can't perform it automatically. If you have a heavily used site that changes a lot, then an occasional vacuum of the database will help. The biggest advantage for me is that I already use PostgreSQL in my environment. By putting trac in PostgreSQL using schemas, I can easily have trac access data from my existing infrastructure. -John --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users -~----------~----~----~----~------~----~------~--~---
