wiki:PgSchemaPatch

Version 1 (modified by pacopablo, 11 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 [download:pgschemapatch 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)?