Changes between Version 3 and Version 4 of TracMultipleProjects/MultipleEnvironmentsSingleDatabase

Timestamp:

Apr 19, 2006, 12:38:29 AM (18 years ago)

Author:

anonymous

Comment:

—

TracMultipleProjects/MultipleEnvironmentsSingleDatabase

@@ -48 +48 @@
 == Possible Alternative ==
 
-Using this as inspiration I also create a different user for each trac project in the postgres database but I then create a schema for each user. Any tables in the database which need to be different for each project stay in the user schema while all the common ones (tickets, etc) stay in the public schema. This has the advantage that initenv and possibly upgrade all work with the caveat that you may need to go in and remove tables from the user schema that get created. I have this mostly working on a standard Centis 4.3 system using trac /trunk (0.1dev). I can now select which parts of trac are per project and which are global.
+Using this as inspiration I also create a different user for each trac project in the postgres database but I then create a schema for each user. Any tables in the database which need to be different for each project stay in the user schema while all the common ones (tickets, etc) stay in the public schema. This has the advantage that initenv and possibly upgrade all work with the caveat that you may need to go in and remove tables from the user schema that get created. I have this mostly working on a standard Centis 4.3 system using trac /trunk (0.1dev). I can now select which parts of trac are per project and which are global. [mailto:greg@max-t.com]