-----Original Message----- From: Tom Lane [mailto:tgl@xxxxxxxxxxxxx] "Ow Mun Heng" <ow.mun.heng@xxxxxxx> 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
