Hi, Posting this to the list as #trac on freenode doesn't seem to want to let me speak (authenticated etc.. so don't know what's up!)
I'm handling a database migration from sqlite to postgres, however using the script (1) leads me to this error -------------- trac:~/work/sqlitetopgscript/0.10# ./sqlite2pg -e /home/sahana/trac -p 'postgres://xxxx:xxxxx@localhost/trac' /usr/local/lib/python2.6/dist-packages/TracScreenshots-0.8dev- py2.6.egg/tracscreenshots/core.py:13: DeprecationWarning: the sets module is deprecated import sets Traceback (most recent call last): File "./sqlite2pg", line 335, in <module> sys.exit(main(sys.argv[1:])) File "./sqlite2pg", line 331, in main Main(opts) File "./sqlite2pg", line 244, in Main pgenv = getPostgreSQLEnvironment(opts) File "./sqlite2pg", line 209, in getPostgreSQLEnvironment cnx = env.get_db_cnx() File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/ trac/env.py", line 328, in get_db_cnx return get_read_db(self) File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/ trac/db/api.py", line 90, in get_read_db return _transaction_local.db or DatabaseManager(env).get_connection() File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/ trac/db/api.py", line 150, in get_connection connector, args = self.get_connector() File "/usr/local/lib/python2.6/dist-packages/Trac-0.12.1-py2.6.egg/ trac/db/api.py", line 192, in get_connector scheme=scheme)) trac.core.TracError: Unsupported database type "postgres" ---------------- We've migrated from an older version also, but the initial migration work seems to have worked ok for sqlite We ran.. trac-admin /home/xxx/trac upgrade trac-admin /home/xxx/trac wiki upgrade trac-admin /home/xxx/trac repository resync '*' I have the relevant modules installed from what I can see. Would appreciate any pointers! Running: Debian Squeeze ii python2.6 2.6.6-8+b1 An interactive high-level object-oriented language (version 2. ii python-psycopg2 2.2.1-1 Python module for PostgreSQL ii postgresql-8.4 8.4.5-0squeeze2 object-relational SQL database, version 8.4 server Thanks Joel -- You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to email@example.com. To unsubscribe from this group, send email to trac-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/trac-users?hl=en.