Message-ID: <BLU0-SMTP1190D6847C44E7B703EFA42CFE00@phx.gbl>
Date: Fri, 22 Nov 2013 09:04:16 -0200
From: Edson Richter <edsonrichter@hotmail.com>
Organization: Simkorp =?ISO-8859-1?Q?Inform=E1tica_Ltda?=
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64;
 rv:24.0) Gecko/20100101 Thunderbird/24.1.0
MIME-Version: 1.0
To: pgsql-general@postgresql.org
Subject: Re: PG replication across DataCenters
References: 
 <CAD7Ssm9S__ZQCOq2GEN0G0rrs_4U6aqXiLaX0hh0Ts8JH_LY2w@mail.gmail.com>
In-Reply-To: 
 <CAD7Ssm9S__ZQCOq2GEN0G0rrs_4U6aqXiLaX0hh0Ts8JH_LY2w@mail.gmail.com>
Content-Type: text/plain; charset="ISO-8859-1"; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-general-owner@postgresql.org

Em 22/11/2013 08:43, Kaushal Shriyan escreveu:
> Hi,
>
> 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. Please also help me understand the caveats i 
> need to take care if i implement this setup.
>
> Regards,
>
> Kaushal
We have used asynchronous replication across datacenters with 100% 
success since 9.1. Currently we use 9.2.
Our setup involves a internet tunnel between servers. Servers have about 
2.000km of distance from each other.
The only points you need to take attention is tuning number of 
wal_keep_segments and timeout, and the initial load (that can be huge, 
depends on your data).

Regards,

Edson


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general