From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | martin(dot)kamp(dot)jensen(at)schneider-electric(dot)com, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Invalid data read from synchronously replicated hot standby |
Date: | 2016-04-21 14:03:55 |
Message-ID: | 5718DDCB.30301@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 04/21/2016 01:05 AM, martin(dot)kamp(dot)jensen(at)schneider-electric(dot)com 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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Karsten Hilbert | 2016-04-21 14:08:37 | Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created |
Previous Message | Tom Lane | 2016-04-21 13:57:03 | Re: Is it possible to call Postgres directly? |