| From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Kaushal Shriyan *EXTERN*" <kaushalshriyan(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PG replication across DataCenters |
| Date: | 2013-11-22 10:57:49 |
| Message-ID: | A737B7A37273E048B164557ADEF4A58B17C5ED75@ntex2010i.host.magwien.gv.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs pgsql-general |
Kaushal Shriyan wrote:
> I have read on the web that Postgresql DB supports replication across data centers. Any real life
> usecase examples if it has been implemented by anyone.
Well, we replicate a 1 TB database between two locations.
It is a fairly active OLTP application, but certainly not
pushing the limits of what PostgreSQL can do in transactions
per second.
But I get the impression that replication is widely accepted
and used by now.
> Please also help me understand the caveats i
> need to take care if i implement this setup.
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.
Yours,
Laurenz Albe
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2013-11-22 11:04:16 | Re: PG replication across DataCenters |
| Previous Message | Kaushal Shriyan | 2013-11-22 10:43:40 | PG replication across DataCenters |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edson Richter | 2013-11-22 11:04:16 | Re: PG replication across DataCenters |
| Previous Message | Kaushal Shriyan | 2013-11-22 10:43:40 | PG replication across DataCenters |