[GENERAL] Postgres warm standby in production

2016-03-31 Thread Dmitry Mordovin
Dear friends! Anybody use Postgres 9.5 warm standby in production? Which schemes you use? My setup: - 2 DB servers (master and slave) - 4 APP servers (tomcat) Each tomcat server have JDBC connect to master and prepared config for slave. Business task permit switch between DB server on APP s

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
Just word of month, Thank you Simon for detailed explanation current status of BDR and PostgreSQL. BR, Dmitry On 12/14/2015 09:31 PM, Simon Riggs wrote: On 14 December 2015 at 15:55, Dmitry Mordovin <mailto:d.mordo...@dwide.com>> wrote: Hello All! As I heard, PostgreSQ

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin wrote: Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). Huh -- that may be so. But if it is, it contradicts the BDR documentation: http://bdr-project.org/docs/stable/install-requirements.html

[GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. In official docs very small information about how to configure servers. Could anyone