Re: BUG #2113: PostgreSQL hangs after running for 2 days

"Wojciech Sobczuk" <wojtek@brandlay.com> writes:
> 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 think we've identified the reason for this:
http://archives.postgresql.org/pgsql-committers/2006-01/msg00287.php

            regards, tom lane