A (as of yet) unofficial and very useful feature of trac is to import tickets from... well, anything by providing a CSV-importer script. However, it didn't work with PostgreSQL as backend - turns out, it uses double-quotes around string literals in its SQL-statements - something that PostgreSQL frowns upon... after modifying all statements to use l33t single-quotes all works like a charm. You can find a patched version of the script here on my site, since the official wiki currently doesn't accept attachments from unwashed strangers such as myself ;-) (Hmmm... another good usecase for captchas...)