PostgreSQL Schema Support

• Wahoo! The PgSchemaPatch was accepted into trunk as of 3249

Description

Patch provides the ability to use a schema for each trac site instead of a full database instance

Bugs/Feature Requests

Existing bugs and feature requests for PgSchemaPatch are here.

If you have any issues, create a new ticket.

Download

Download the zipped source from here.

Source

You can check out PgSchemaPatch from here using Subversion, or browse the source with Trac.

Example

Simply apply the patch:

cd path/to/trac/src/trac-0.9.5
patch -p0 < pgschemapatch-0.9.5.patch
python setup.py install

Then when creating a new site, append the schema name to the PostgreSQL DB URIs in the example below:

trac-admin initenv new_proj postgres://myuser@localhost/mydb?schema=my_schema /var/svn/new_proj /usr/share/trac/templates

Author/Contributors

Author: pacopablo
Contributors: