Invalid data read from synchronously replicated hot standby

From: martin(dot)kamp(dot)jensen(at)schneider-electric(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Invalid data read from synchronously replicated hot standby
Date: 2016-04-21 08:05:01
Message-ID: OF432D0315.B1FA563D-ONC1257F9C.002AC170-C1257F9C.002C6CD1@schneider-electric.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

We are getting invalid data when reading from a synchronously replicated
hot standby node in a 2-node setup. To better understand the situation, we
have created a document that provides an overview. We are hoping that
someone might be able to confirm whether or not the setup makes sense,
i.e., whether we are using PostgreSQL correctly and experiencing a bug, or
if we are using PostgreSQL incorrectly.

Link to document that contains a step-by-step description of the
situation:
https://docs.google.com/document/d/1MuX8rq1gKw_WZ-HVflqxFslvXNTRGKa77A4NHto4ue0/edit?usp=sharing

If the setup is sane (and expected to work), we will work on setting up a
minimal reproduce that avoids our complete system. We are thinking that a
scripted Ansible/Vagrant setup makes sense.

Best regards,
Martin

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sachin Kotwal 2016-04-21 09:23:02 Re: error while installing auto_explain contrib module
Previous Message Ihnat Peter | TSS Group a.s. 2016-04-21 07:51:40 Background worker with Listen