"Wojciech Sobczuk" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
