Howard / Chris,
I'd like to create a Trac instance for GeoMoose. The standard procedure
suggests creating a new Postgres db for each project. However, I have
a recollection that each apache/trac instances is keeping a db connection
open to each db and it seems to me that adding more databases to this
cross product may be counter productive.
Do you guys have any advice on whether to follow the standard procedure
or if we might be better just using the default sqlite db for relatively low
activity new projects?
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Software Developer
I'm not aware of us having run into any problems now with our current setup.
Specifically, we have a lower set of apache children running, and they restart
every n requests, which resets the connection.
sqlite has given us enough problems that if I was going to do something, it
would probably be to look into whether trac can work in a prefix inside a single
db, and use that solution instead.
-- Chris
On Dec 21, 2011, at 4:30 PM, ext Frank Warmerdam wrote:
Howard / Chris,
I'd like to create a Trac instance for GeoMoose. The standard procedure
suggests creating a new Postgres db for each project. However, I have
a recollection that each apache/trac instances is keeping a db connection
open to each db and it seems to me that adding more databases to this
cross product may be counter productive.
Do you guys have any advice on whether to follow the standard procedure
or if we might be better just using the default sqlite db for relatively low
activity new projects?
Best regards,
--
---------------------------------------+--------------------------------------
I set the clouds in motion - turn up | Frank Warmerdam, warmerdam@pobox.com
light and sound - activate the windows | http://pobox.com/~warmerdam
and watch the world go round - Rush | Geospatial Software Developer
_______________________________________________
Sac mailing list
Sac@lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/sac