Re: [HACKERS] Multiple synchronous_standby_names rules

2017-01-11 Thread Michael Paquier
On Thu, Jan 12, 2017 at 9:53 AM, James Sewell wrote: > What is needed to support this is the ability to configure Px with something > like: > > 1 (P1, P2, P3), 1 (D1, D2, D3) > > Would there be any appetite for this - or would it be seen as over > complication of the current rules? There have

[HACKERS] Multiple synchronous_standby_names rules

2017-01-11 Thread James Sewell
Hello, When working with a production (P) and a DR (D) environment it is often a requirement to be able to protect against data loss when promoting within a site, and also when losing A and promoting a master at D. The current synchronous_standby_names do not allow this. In a simple example we c