From: | "Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)com> |
---|---|
To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: xlog flus not satisfied |
Date: | 2009-08-11 03:11:35 |
Message-ID: | D1109E8B2FB53A45BDB60F8145905CE9032B1BFD@wdmyexbe03.my.asia.wdc.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
"Ow Mun Heng" <ow(dot)mun(dot)heng(at)wdc(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Juan Backson | 2009-08-11 04:02:44 | Re: PQstatus does not seem to work |
Previous Message | Tom Lane | 2009-08-11 03:08:50 | Re: xlog flus not satisfied |