lists <lists01(at)dds(dot)uconn(dot)edu> writes:
> Alvaro Herrera wrote:
>>> this is 7.3.3 (PGDG rpm's) on red hat 7.2
>>
>> Get 7.3.6 and try again. IIRC this is a known bug that was repaired in
>> 7.3.4.
> to get the data back, is it a matter of just upgrading and starting the
> db (ie will it perform recovery)?
Yes. There's nothing wrong with your data, it's just a corner case that
was not correctly handled by the recovery code in 7.3.3.
You could actually use any version 7.3.4-7.3.6, but you might as well go
to 7.3.6 while you're at it.
regards, tom lane