migrate SQLite to PostgreSQL

[mgood]

We should provide a script for converting existing Trac projects from SQLite to PostgreSQL. Dumping the SQLite database and loading it from PostgreSQL is close to working, but there are some issues as noted in #2439.

[chibifirli@…]

Would anyone be so kind to tell me where I could find the script? It's not really important whether it really works yet or not, but I need to migrate a few SQLite3 databases to PostgreSQL. I have time to spare to get the script working.

[anonymous]

There is no script. It needs to be written. You can look at the history of TracUpgrade for the process that does not work.

[chibifirli@…]

okay, thank you.
I'll write it myself then :).

[jgoerzen@…]

There is a script here: ​http://trac-hacks.org/wiki/SqliteToPgScript

[sid]

Should this go into contrib or okay entirely on TracHacks?

[pacopablo]

I'm fine with this being included wherever. Perhaps the only thing that is really needed is better documentation on t.e.o pointing to the script on t-h.o

Any suggestions as to where said documentation should go? TracUpgrade?

[cboos]

Yes, TracUpgrade seems to be a good place.

[pacopabl]

I updated the TracUpgrade page to reference the sqlite2pg script.

[osimons]

With TracUpgrade updated as it is, I can't see anything left open in this ticket from what was agreed as needed tasks.

As that page is one of the default pages, I'm closing it as 'fixed' for 0.11.

[anonymous]

The script no longer appears to work (sqlite2pg), at least on Ubuntu Lucid with PG9.0 and psycopg 2.0.13-2ubuntu2. See ​https://trac-hacks.org/ticket/9098 (ticket submitted by me, if you need contact info). Others have had the same problem too, e.g.: ​http://www.mail-archive.com/trac-users@googlegroups.com/msg20555.html