= PostgreSQL Schema Support = {{{ #!NewsFlash '''News''' * Wahoo! The PgSchemaPatch was accepted into trunk as of [T:changeset:3249 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 [report:9?COMPONENT=PgSchemaPatch here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=PgSchemaPatch&owner=pacopablo new ticket]. == Download == Download the zipped source from [download:pgschemapatch here]. == Source == You can check out PgSchemaPatch from [http://trac-hacks.org/svn/pgschemapatch here] using Subversion, or [source:pgschemapatch 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:''' [wiki:pacopablo] [[BR]] '''Contributors:''' [[TagIt(patch,pacopablo,beta,0.9)]]