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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Yan Chunlu <springrider(at)gmail(dot)com>
Cc: Tomas Vondra <tv(at)fuzzy(dot)cz>, Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, Martin Pitt <mpitt(at)debian(dot)org>
Subject: Re: streaming replication does not work across datacenter with 20ms latency?
Date: 2011-07-25 16:08:15
Message-ID: 10174.1311610095@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Yan Chunlu 2011-07-25 16:17:42 Re: streaming replication does not work across datacenter with 20ms latency?
Previous Message Chris Travers 2011-07-25 15:45:55 Re: unable to find function to encrypt text using 3des algorithm with 3 independent keys