wiki:PgSchemaPatch

Version 1 (modified by pacopablo, 9 years ago) (diff)

New hack PgSchemaPatch, created by pacopablo

PostgreSQL Schema Support

Description

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

More info can be found at: http://embassy.asylumware.com/projects/trac/wiki/Patches/Schema

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

Adds an additional parameter to trac-admin initenv if using PostgreSQL.

Simply apply the patch:

cd path/to/trac/src/trac-0.9.3
patch -p1 < trac-0.9.3-schema.patch
python setup.py install

Then when creating a new site, if you enter a PostgreSQL database string, you will be prompted with which schema to use. trac-admin will take care of creating the schema.

trac-admin initenv new_proj postgres://myuser@localhost/mydb proj_schema /var/svn/new_proj /usr/share/trac/templates

Author/Contributors

Author: pacopablo
Contributors:

TagIt(patch,pacopablo,beta,0.9)?