Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Some thoughts about multi-server sync rep configurations - Mailing list pgsql-hackers

From Craig Ringer
Subject Re: [HACKERS] Some thoughts about multi-server sync rep configurations
Date
Msg-id CAMsr+YG2u4FZC6QyYj5bz3Yq_jRWior_xcw1krhcKAAj5D5EGg@mail.gmail.com
Whole thread Raw
In response to [HACKERS] Some thoughts about multi-server sync rep configurations  (Thomas Munro <thomas.munro@enterprisedb.com>)
Responses Re: [HACKERS] Some thoughts about multi-server sync rep configurations
List pgsql-hackers
Tree view 
On 28 December 2016 at 08:14, Thomas Munro
<thomas.munro@enterprisedb.com> wrote:

> 3.  No server must allow a transaction to be visible that hasn't been
> flushed on N standby servers.  We already prevent that on the primary

Only if the primary doesn't restart. We don't persist the xact masking
used by sync rep at the moment.

I suspect that solving that is probably tied to solving it on standbys.

-- Craig Ringer                   http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services

pgsql-hackers by date:

Previous
From: Craig Ringer
Date:
Subject: Re: [HACKERS] BUG: pg_stat_statements query normalization issues withcombined queries
Next
From: Peter Eisentraut
Date:
Subject: [HACKERS] Add doc advice about systemd RemoveIPC