Edgewall Software

Ticket #2441 (closed enhancement: fixed)

Opened 3 years ago

Last modified 10 months ago

migrate SQLite to PostgreSQL

Reported by: mgood Owned by: mgood
Priority: normal Milestone: 0.11
Component: general Version: 0.9
Severity: minor Keywords: postgresql documention
Cc: dansan@…, shishz@…, EricJohnson, chibifirli@…, pacopablo@…

Description

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

Change History

Changed 3 years ago by anonymous

  • cc dansan@… added

Changed 3 years ago by anonymous

  • cc shishz@… added

Changed 2 years ago by EricJohnson <edgewall@…>

  • cc EricJohnson added

Changed 2 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.

Changed 2 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.

Changed 2 years ago by chibifirli@…

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

Changed 2 years ago by cboos

  • keywords postgresql added

Changed 2 years ago by jgoerzen@…

Changed 2 years ago by sid

Should this go into contrib or okay entirely on TracHacks?

Changed 23 months 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?

Changed 21 months ago by cboos

  • keywords documention added
  • severity changed from normal to minor
  • milestone set to 0.11

Yes, TracUpgrade seems to be a good place.

Changed 17 months ago by pacopabl

I updated the TracUpgrade page to reference the sqlite2pg script.

Changed 10 months ago by osimons

  • status changed from new to closed
  • resolution set to fixed
  • milestone changed from 0.11.1 to 0.11

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.

Add/Change #2441 (migrate SQLite to PostgreSQL)

Author



Change Properties
<Author field>
Action
as closed
Next status will be 'reopened'
to The owner will change from mgood. Next status will be 'closed'
 
Note: See TracTickets for help on using tickets.