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

From Tom Lane
Subject Re: streaming replication does not work across datacenter with 20ms latency?
Date
Msg-id 10174.1311610095@sss.pgh.pa.us
Whole thread Raw
In response to streaming replication does not work across datacenter with 20ms latency?  (Yan Chunlu <springrider@gmail.com>)
List pgsql-general
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: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Next
From: Yan Chunlu
Date:
Subject: Re: streaming replication does not work across datacenter with 20ms latency?