[SAC] Trac and Postgres vs. SQLite DB

[christopher.schmidt at nokia.com]

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 at 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 at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/sac