DSource

[Brad Anderson]

Jari-Matti Mäkelä wrote:
> Is there a
> good reason to use Postgres in the first place?
> 

I was getting ready for Digg-type traffic, and I have seen Trac db's stored in
SQLite lock during write (yes, the whole db locks).  So I chose Postgres.  I
have heard of using one database and separating the Trac tables for a project
into different schemas - the problem that was observed separate of dsource's
actually went away doing this.  This is a big task and I don't have a lot of
time right now.  A few weeks ago when I had some time, the problem wasn't as
pronounced...  Murphy.

I have tried some settings in postgresql.conf to limit connection time-outs
and they're not working yet.

Plus, I didn't see nearly the traffic Walter talks about getting on his site,
because the link to dsource is reasonably obscure.  Some of that lack of
traffic was the brief periods when we were down, but I would have seen hits in
the logs, just with errors.

Also, we weren't down for an entire week as the OP suggests.  Apache resets
itself, so we were down no longer than 2 hours at a time, and then were fine
for most likely 12 hrs, until it happened again.

BA