Re: streaming replication does not work across datacenter with 20ms latency?

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Yan Chunlu <springrider(at)gmail(dot)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
>