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

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