Re: streaming replication does not work across datacenter with 20ms latency? - Mailing list pgsql-general

From Yan Chunlu
Subject Re: streaming replication does not work across datacenter with 20ms latency?
Date
Msg-id CAOA66tH=bWQN5xOOkDB3dKMDAOup9NOO_9vK5=-_ub-uDfaoyA@mail.gmail.com
Whole thread Raw
In response to streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
List pgsql-general
how about 4.3.2?

 I have gcc 4.3.2 compiled postgresql 9.0.4 as slave, is that okay
that I turn the slave into master?  so the switch will be a lot more
smooth.

On Tue, Jul 26, 2011 at 12:08 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> Yan Chunlu <springrider@gmail.com> writes:
>> oh god...thanks a lot for the tip. I did actually lost some data, the
>> master server has crashed two times. every time it comes back, the
>> index were broken. I need to reindex it. I have already set fsync=on.
>>   just thought it was normal behavior....
>
> Uh, no.
>
>> about gcc version, only 4.6.0 effected?    4.6.1 is okay? then I could
>> compile my own version with 4.6.1
>
> It's supposed to be fixed in 4.6.1 according to
> http://gcc.gnu.org/bugzilla/show_bug.cgi?id=49390
>
> Personally I'd use 4.6.1 *and* apply the Postgres patch.
>
>                        regards, tom lane
>

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Tom Lane
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?