Re: PG replication across DataCenters - Mailing list pgsql-general

From Kaushal Shriyan
Subject Re: PG replication across DataCenters
Date
Msg-id CAD7Ssm-JLz1nM1zd_dgVGWWMB+Bq=3QCWWigaZV7xu+_mQ_qWQ@mail.gmail.com
Whole thread Raw
In response to Re: PG replication across DataCenters  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: PG replication across DataCenters  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general



On Fri, Nov 22, 2013 at 6:14 PM, Albe Laurenz <laurenz.albe@wien.gv.at> wrote:
Torsten Förtsch wrote:
>> Don't use synchronous replication if you have a high transaction
>> rate and a noticable network latency between the sites.
>>
>> Wait for the next bugfix release, since a nasty bug has just
>> been discovered.
>
> Can you please explain or provide a pointer for more information?

If you mean the bug I mentioned, see this thread:
http://www.postgresql.org/message-id/20131119142001.GA10498@alap2.anarazel.de

Yours,
Laurenz Albe

Hi,

I am not sure i understand the difference between async and sync replication and on what scenarios i should use async or sync replication. Does it mean if it is within same DC then sync replication is the best and if it is across DC replication async is better than sync. Please help me understand.

Regards,

Kaushal

pgsql-general by date:

Previous
From: Albe Laurenz
Date:
Subject: Re: PG replication across DataCenters
Next
From: "Janek Sendrowski"
Date:
Subject: include all the postgres libraries (C)