Edgewall Software

Opened 13 years ago

Closed 11 years ago

Last modified 4 years ago

#2441 closed enhancement (fixed)

migrate SQLite to PostgreSQL

Reported by: Matthew Good Owned by: Matthew Good
Priority: normal Milestone: 0.11
Component: general Version: 0.9
Severity: minor Keywords: postgresql, documention
Cc: dansan@…, shishz@…, EricJohnson, chibifirli@…, pacopablo@…
Release Notes:
API Changes:


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.

Attachments (0)

Change History (15)

comment:1 Changed 13 years ago by anonymous

Cc: dansan@… added

comment:2 Changed 13 years ago by anonymous

Cc: shishz@… added

comment:3 Changed 12 years ago by EricJohnson <edgewall@…>

Cc: EricJohnson added

comment:4 Changed 12 years ago by chibifirli@…

Cc: chibifirli@… added

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.

comment:5 Changed 12 years ago by 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.

comment:6 Changed 12 years ago by chibifirli@…

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

comment:7 Changed 12 years ago by Christian Boos

Keywords: postgresql added

comment:8 Changed 12 years ago by jgoerzen@…

comment:9 Changed 12 years ago by sid

Should this go into contrib or okay entirely on TracHacks?

comment:10 Changed 12 years ago by pacopablo

Cc: chibifirli@… pacopablo@… added; chibifirli@… removed

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?

comment:11 Changed 12 years ago by Christian Boos

Keywords: documention added
Milestone: 0.11
Severity: normalminor

Yes, TracUpgrade seems to be a good place.

comment:12 Changed 11 years ago by pacopabl

I updated the TracUpgrade page to reference the sqlite2pg script.

comment:13 Changed 11 years ago by osimons

Resolution: fixed
Status: newclosed

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.

comment:14 Changed 7 years ago by 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

comment:15 Changed 4 years ago by Ryan J Ollos


Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Matthew Good.
The resolution will be deleted.
to The owner will be changed from Matthew Good to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.