On 04/21/2016 01:05 AM, martin.kamp.jensen@xxxxxxxxxxxxxxxxxxxxxx wrote:
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.
Questions: What is wal_level set to? Why on Node A do you have in recovery.conf?: primary_conninfo = 'host=<Node A IP address>' What exactly are you trying to do? Looks to me you are trying to have multi-master, is that the case?
Best regards, Martin
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
