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 trac-users@googlegroups.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.
