Re: xlog flus not satisfied
От | Ow Mun Heng |
---|---|
Тема | Re: xlog flus not satisfied |
Дата | |
Msg-id | D1109E8B2FB53A45BDB60F8145905CE9032B1BFD@wdmyexbe03.my.asia.wdc.com обсуждение исходный текст |
Ответ на | Re: xlog flus not satisfied (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-general |
-----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.
В списке pgsql-general по дате отправления: