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
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>
  File "./sqlite2pg", line 331, in main
  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
  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
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!


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


You received this message because you are subscribed to the Google Groups "Trac 
Users" group.
To post to this group, send email to trac-users@googlegroups.com.
To unsubscribe from this group, send email to 
For more options, visit this group at 

Reply via email to