Re: xlog flus not satisfied

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.

In response to

Browse pgsql-general by date

  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