Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc> writes:
> ERROR: could not access status of transaction 0
> DETAIL: could not create file
> /var/databases/postgres/data/pg_subtrans/57DA<<: File exists
> and seems to be generated in backend/access/transam/slru.c
> it looks like we got those(with changing filenames) about 5 times during
> the last 2 months mostly during low-utilisation times (on this
> particular database - not on the server itself).
Hm ... can you check exactly what set of filenames exists in
pg_subtrans/ when this happens? Is it always referencing pg_subtrans/,
or are there similar complains about pg_clog/ ?
regards, tom lane