Search Postgresql Archives

Re: PG replication across DataCenters

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux