On Wed, 2006-09-13 at 09:22 -0700, John Hampton wrote: > 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. >
If you're running a recent version of PostgreSQL (>= 8.0 IIRC), just make sure you enable autovacuum and you don't need to worry about this. > 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 -~----------~----~----~----~------~----~------~--~---
