Yes, this is possible. I was able to migrate from a Trac installed
sqlite3 and another using PostgreSQL using something along the lines of:
sqlite3 trac.db .dump > dump.sql
# make some edits (see below)
psql dbname < dump.sql
There are 2 edits I needed to make:
In my case (YMMV) the exported data from sqlite3 had some bad
syntax. I used vi and g/\\''/s//''/g to replace all \\'' with just
'' so psql didn't complain.
The other thing I had to change was to remove the CREATE TABLE and
CREATE INDEX commands from dump.sql. They were wrong (because they
created tables for sqlite3 using different types for some columns)
and I already had the tables anyway.
Doug
On Mar 2, 2006, at 1:05 PM, Dan Crosta wrote:
Is it generally possible or easy to migrate the database behind a trac
environment from SQLite to Postgres? Or possible to export the
information in the current environment, create a new environment (ie
using Postgres) and then import the data? It doesn't sound like that's
what "trac-admin hotcopy" does...
Thanks,
dsc
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac
