On 10/16/13, Olemis Lang <[email protected]> wrote: > On 10/16/13, Ethan Jucovy <[email protected]> wrote: >> On Wed, Oct 16, 2013 at 12:34 AM, Olemis Lang <[email protected]> wrote: >> >>> On 10/15/13, Saint Germain <[email protected]> wrote: >>> > Sorry to have been unclear. I do not wish to migrate from SQLite to >>> > PostgreSQL, I just want to wipe the SQLite database and create a >>> > PostgreSQL database while keeping all the configuration. >>> >>> I do not know , but maybe you'll achieve this by running trac-admin >>> ... upgrade after binding the env to a pristine DB ? >>> >> >> I've had to do this before; there's no clean trac-admin way to do it, > > ... but it should ... > > http://trac.edgewall.org/ticket/11333 > >> but >> it's not too difficult. IIRC running trac-admin upgrade doesn't work in >> this situation, because `upgrade` expects the database to already exist, >> with its schema created, and at least some data present in the system >> table. >> > > you are right ... > >> You can do this with some python code. First, edit your conf/trac.ini >> database setting to point to the desired new database (and create it if >> it's a postgres database). Then open up a python shell and run the >> following code: >> > [...] > > I will transform this into a component and submit a patch to #11333 ... >
Ready ! Patches: https://bitbucket.org/olemis/trac-mq/src/trac_t11333/t11333?at=trac_t11333 Comments: http://trac.edgewall.org/ticket/11333#comment:3 It's basically Ethan's code with minor modifications . Feedback is welcome . -- Regards, Olemis - @olemislc Apache™ Bloodhound contributor http://issues.apache.org/bloodhound http://blood-hound.net Blog ES: http://simelo-es.blogspot.com/ Blog EN: http://simelo-en.blogspot.com/ Featured article: -- You received this message because you are subscribed to the Google Groups "Trac Development" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/trac-dev. For more options, visit https://groups.google.com/groups/opt_out.
