Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> We ran out of disk space on our main server, and now I've freed up
> space, we cannot start postgres!
> Jan 23 12:18:51 canaveral postgres[563]: [7-1] PANIC: could not access
> status of transaction 14286850
> Jan 23 12:18:51 canaveral postgres[563]: [7-2] DETAIL: could not read
> from file "/usr/local/pgsql/data/pg_clog/000D" at offset 163840:
> Undefined error: 0
I'd suggest extending that file with 8K of zeroes (might need more than
that, but probably not).
regards, tom lane