Re: Disaster!

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