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 ... [...] > > I've thought about packaging it into a plugin's trac-admin command or > submitting a core patch, but I had assumed nobody else would ever need it. > :-) > ... if you do not beat me and get it done first ;) [...] -- 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.
