-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
"Ow Mun Heng" <ow.mun.heng@wdc.com> writes:
>> As background, this is a new box mirrored from a separate box via rsync.
>> I've basically copied/rsync the entire postgresql server and data files
>>over
>> to create a mirror copy. After which, I've tried to do the vacuum and
gotten
>> into the above trouble.
>Did you shut down the old postmaster while mirroring its files? I could
>believe seeing this type of problem as a consequence of getting
>out-of-sync copies of different parts of the database.
You've caught me. I'm actually planning to down the master server during
lunch to re-sync it.
Aside : I wonder how pgcluster does it then, cos I thought they use rsync to
do replication.
Thanks. Will report back in couple hours.