Re: [Trac] PostgreSQL - a straw poll
On 10/20/2010 12:57 AM, Andy Baker wrote: Hi All, I'm looking into switching from sqlite to postgreSQL as our backend. I'm assuming this shouldn't be an issue, but does anyone have any good/bad experiences to share? I recently did a similar migration, using Postgres 0.11.6. The core Trac code went over fine, but our custom queries all needed to be ported (there were a lot of SQLite-ism's, specifically as related to datetime type functions). Further, many of our plugins needed to be updated, as there were subtle variations in the SQL (quotes around arguments being different, etc.). In all, I like PostgreSQL less than SQLite. It reminds me of my brief brush with Oracle - a lot of the meta-syntax is obscure, it's annoyingly picky about stupid things such as how to quote strings, and it just feels slightly wrong. That said, it does work, and we noticed a complete evaporation of our issues relating to people fighting over the database. SQLite and MySQL are much less annoying to work with... I mean, until MySQL corrupts its tables because MyISAM is still the default on most package installs (I'm looking at you, Ubuntu 10.04). -- Matthew Caron Build Engineer Sixnet | www.sixnet.com O +1 518 877 5173 Ext. 138 F +1 518 602 9209 matt.ca...@sixnet.com -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] PostgreSQL - a straw poll
We use postgresql for 2 internal tracs on 0.12, one is pretty large (6,000 tickets; at least 50 ticket updates per workday and hundreds of wiki pages). The only issues we've had have been occasional plugins that have like one or two lines of SQL that's invalid for Postgresql. We also had one semi-frustrating error message that's since been fixed, http://trac.edgewall.org/ticket/9400. Otherwise it's been a very satisfying experience. I have a bunch of trac instances running with pgsql, one with 4300 tickets, 100 users and 32K svn changesets. It has basically worked fine, with two kinds of minor hiccups in plugins: lack of begin/end (for transactions) interaction with autocommit sloppy use of types in sql both were easy to resolve and most plugins seem ok with pgsql now. pgpgpxPGxBaKD.pgp Description: PGP signature
Re: [Trac] PostgreSQL - a straw poll
We use postgresql for 2 internal tracs on 0.12, one is pretty large (6,000 tickets; at least 50 ticket updates per workday and hundreds of wiki pages). The only issues we've had have been occasional plugins that have like one or two lines of SQL that's invalid for Postgresql. We also had one semi-frustrating error message that's since been fixed, http://trac.edgewall.org/ticket/9400. Otherwise it's been a very satisfying experience. On Wed, Oct 20, 2010 at 4:28 AM, Cooke, Mark wrote: >> I'm looking into switching from sqlite to postgreSQL as our >> backend. I'm assuming this shouldn't be an issue, but does >> anyone have any good/bad experiences to share? >> >> Ideally I'd like to hear from people using bleeding edge 0.12 >> saying "yep, works just fine" :-) >> > We're still on 0.11 and I started with postgreSQL so did not convert but > I have moved from trial desktop to server with no issues at all. We're > (now) on Windows Server 2003 if that's relevant. > > ~ mark c > > -- > You received this message because you are subscribed to the Google Groups > "Trac Users" group. > To post to this group, send email to trac-us...@googlegroups.com. > To unsubscribe from this group, send email to > trac-users+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/trac-users?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
RE: [Trac] PostgreSQL - a straw poll
> I'm looking into switching from sqlite to postgreSQL as our > backend. I'm assuming this shouldn't be an issue, but does > anyone have any good/bad experiences to share? > > Ideally I'd like to hear from people using bleeding edge 0.12 > saying "yep, works just fine" :-) > We're still on 0.11 and I started with postgreSQL so did not convert but I have moved from trial desktop to server with no issues at all. We're (now) on Windows Server 2003 if that's relevant. ~ mark c -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
Re: [Trac] PostgreSQL - a straw poll
Hi, Although my Tracs are not heavily used I use PostgreSQL as my backend and I do not experience any problems (Debian Squeeze AMD64) . The installation procedure as described works as described (http://trac.edgewall.org/wiki/DatabaseBackend). -- Met vriendelijke groeten, Joost Kraaijeveld Askesis B.V. Molukkenstraat 14 6524NB Nijmegen tel: 024-3888063 / 06-51855277 fax: 024-3608416 web: www.askesis.nl signature.asc Description: This is a digitally signed message part
[Trac] PostgreSQL - a straw poll
Hi All, I'm looking into switching from sqlite to postgreSQL as our backend. I'm assuming this shouldn't be an issue, but does anyone have any good/bad experiences to share? Ideally I'd like to hear from people using bleeding edge 0.12 saying "yep, works just fine" :-) Cheers Andy -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to trac-us...@googlegroups.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.
