Edgewall Software

Opened 18 years ago

Closed 16 years ago

Last modified 9 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@… Branch:
Release Notes:
API Changes:
Internal 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 by anonymous, 18 years ago

Cc: dansan@… added

comment:2 by anonymous, 18 years ago

Cc: shishz@… added

comment:3 by EricJohnson <edgewall@…>, 18 years ago

Cc: EricJohnson added

comment:4 by chibifirli@…, 18 years ago

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 by anonymous, 18 years ago

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 by chibifirli@…, 18 years ago

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

comment:7 by Christian Boos, 18 years ago

Keywords: postgresql added

comment:8 by jgoerzen@…, 18 years ago

comment:9 by sid, 17 years ago

Should this go into contrib or okay entirely on TracHacks?

comment:10 by pacopablo, 17 years ago

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 by Christian Boos, 17 years ago

Keywords: documention added
Milestone: 0.11
Severity: normalminor

Yes, TracUpgrade seems to be a good place.

comment:12 by pacopabl, 17 years ago

I updated the TracUpgrade page to reference the sqlite2pg script.

comment:13 by osimons, 16 years ago

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 by anonymous, 13 years ago

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 by Ryan J Ollos, 9 years ago

Keywords: postgresql documention → postgresql, documention

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Matthew Good.
The resolution will be deleted. Next status will be 'reopened'.
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.