Changes between Version 8 and Version 9 of TracModWSGI

Timestamp:

Feb 17, 2008, 1:25:03 AM (16 years ago)

Author:

anonymous

Comment:

—

TracModWSGI

@@ -37 +37 @@
 
 For troubleshooting tips, see the [TracModPython#Troubleshooting mod_python troubleshooting] section, as most Apache-related issues are quite similar.
+
+== Trac with PostgreSQL ==
+
+When using the mod_wsgi adapter with multiple Trac instances and PostgreSQL (or MySQL?) as a database back-end the server can get a lot of open database connections. (and thus PostgreSQL processes)
+
+A workable solution is to disabled connection pooling in Trac. This is done by setting poolable = False in trac.db.postgres_backend on the PostgreSQLConnection class.
+
+But it's not necessary to edit the source of trac, the following lines in trac.wsgi will also work:
+
+{{{
+import trac.db.postgres_backend
+trac.db.postgres_backend.PostgreSQLConnection.poolable = False
+}}}
+
+Now Trac drops the connection after serving a page and the connection count on the database will be kept minimal.