BUG #2113: PostgreSQL hangs after running for 2 days

The following bug has been logged online:

Bug reference:      2113
Logged by:          Wojciech Sobczuk
Email address:      wojtek@brandlay.com
PostgreSQL version: 8.0.3
Operating system:   FreeBSD 5.4-RELEASE-p1
Description:        PostgreSQL hangs after running for 2 days
Details:

I have a 16GB database which is very busy (100 requests per second).  After
running for some time (sometimes 2 days sometimes longer sometimes shorter)
postgres hangs.  Last time it happened I got the following error in the
log:

    ERROR:  could not access status of transaction 0
    DETAIL:  could not create file "/opt/pgdata/pg_subtrans/6E75": File
exists
    STATEMENT:  SET DATESTYLE TO 'ISO'
    WARNING:  StartTransaction while in START state

I'm running postgres on 3 RAID 1 arrays, with various tables scattered over
the arrays (using tablespaces) for more speed.  The space usage for those
arrays is less than 16% so it is not a space issue.  The machine never
reboots/hangs/etc. so it seems to be a postgres issue.  If you have further
questions please let me know.

Regards