Trac supports the following databases:
Database Installation Instructions
Installed out-of-the-box. The default connection string is
More parameters can be added using a connection string like
sqlite:db/trac.db?param1=value¶m2=value. The following parameters are supported:
extensions: Load the extensions, see also TracIni.
timeout: Set timeout to connect the database,
10.0is used by default.
eagercursor pre-fetching all the rows is used by default. It can be turned off by specifying
journal_mode: Set the journal mode to the database (since 1.0.5).
synchronous: Set the synchronous flag (since 1.0.5).
Known issues: see SQLite-related tickets.
- Trac ≥0.9.
- Have a working copy of Postgresql.
- Get the proper database driver for Python: psycopg2 bindings
- Create a database for your Trac environment:
% createdb dbname
- Run trac-admin to create a new Trac environment. When prompted for a Database connection string, use:
Notice that the port number might be different in your Postgresql installation, eg 5433. See postgresql.conf.
Alternatively on UNIX, if the database is a local one, you can use UNIX sockets instead of TCP/IP:
If you are using user Trac without a password to connect through UNIX sockets to database trac and have only one project (hence no need for different schemas), your connections string would be postgres://trac:@/trac
- Note: '?host=…' is optional. Check your postgresql.conf' unix_socket_directory option if you have connection problems.
See #4546 for more details.
See also #2441, which discusses the process of migration from SQLite to Postgresql.
For a Postgresql recipe tested on CentOS4 (Red Hat -EL4) see PostgresqlRecipe.
Finally, see #126 for historical notes.
Known issues: see postgres-related tickets
- Run trac-admin to create a new Trac environment. When prompted for a database connection string, use:
- or when you need more options:
The following parameters are supported since Trac 1.0:
compress: Enable compression (0 or 1)
init_command: Command to run once the connection is created
named_pipe: Use a named pipe to connect on Windows (0 or 1)
read_default_file: Read default client values from the given file (also used for SSL configuration)
read_default_group: Configuration group to use from the default file
unix_socket: Use a Unix socket at the given path to connect
Known issues: see mysql-related tickets.
For Trac ≥ 1.3.2, the TracAdmin
convert_db command allows an environment to be converted between the supported database backends. For Trac < 1.3.2, TracMigratePlugin provides equivalent functionality.
Other databases where support has been requested or where support exists via plugins are: