| 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: | Whole Thread | Raw Message | 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 |