Hi Daniel Regarding your question: I followed Jeff sugestions: ________________________________________ >From: [email protected] [mailto:[EMAIL PROTECTED] On >Behalf Of Jeff Marder >Sent: Monday, October 09, 2006 10:14 PM >To: [email protected] >Subject: [Trac] Re: Configuring Trac to use Postgres
>I converted a couple projects from SQLite to PostgreSQL last week and it >went very smoothly. You can find some information on this page: >http://trac.edgewall.org/wiki/PostgresqlRecipe. There was one little hiccup >with the 'All Tickets By Milestone (Including closed)' report, but I found >the solution here: http://trac.edgewall.org/ticket/2123. You'll also want >to tune your PostgreSQL server a bit for performance because there is a >noticeable difference with a default installation. You can find plenty of >resources by Googling, but if you want something quick you can increase >your shared_buffers to 15000 or so. However, on Linux you first have to >increase kernel.shmmax in /etc/sysctl.conf. I set mine to 134217728. You >can find some helpful information on that here: >http://developer.postgresql.org/pgdocs/postgres/kernel-resources.html. If >you're currently using SQLite there's also a great script on http://trac->hacks.org that will convert your database to PostgreSQL. -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Daniel Serodio Sent: Tuesday, October 17, 2006 4:13 PM To: [email protected] Subject: [Trac] Re: 2 databases 1 Trac. Paulo Alexandre Freire wrote: > > Hello all. > > Last message I sent was regarding speed on the database. I've > installed Postgres with all speed up features but no practical > results. The problem was that I had in the ticket's description some > TicketQuery so I changed the reports to not care about description. > Lot faster now. > Would you care to ellaborate on these "speed up features"? TIA, Daniel Serodio > > Now I'm thinking in another possibilities. Is it possible to split the > database in two? (The tickets type requirements in one database and > the ticket type task in the other database). > > Or should I consider split in two different project folder( eg: > /usr/share/trac/aleluia and /usr/share/trac/alleluia_requirements)? In > this case would it be possible to refer in wiki aleluia the tickets > from aleluia_requirements? > > Thanks in advance > > Paulo Freire > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
