Re: Invalid data read from synchronously replicated hot standby
| От | martin.kamp.jensen@schneider-electric.com |
|---|---|
| Тема | Re: Invalid data read from synchronously replicated hot standby |
| Дата | |
| Msg-id | OF35E7AA48.A41D13C3-ONC1257FA1.002DD281-C1257FA1.002E2577@schneider-electric.com обсуждение исходный текст |
| Ответ на | Re: Invalid data read from synchronously replicated hot standby (Adrian Klaver <adrian.klaver@aklaver.com>) |
| Список | pgsql-general |
Adrian Klaver <adrian.klaver@aklaver.com> wrote on 04/21/2016 16:03:55:
> From: Adrian Klaver <adrian.klaver@aklaver.com>
> To: Martin Kamp Jensen/DK/Schneider@Europe, pgsql-general@postgresql.org
> Date: 04/21/2016 16:09
> Subject: Re: [GENERAL] Invalid data read from synchronously
> replicated hot standby
>
> On 04/21/2016 01:05 AM, martin.kamp.jensen@schneider-electric.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?
wal_level = hot_standby
>
> 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?
Eh, that's a mistake in the document. Probably because of a leftover recovery.done file. We only have Node A as master. I have updated the document.
I have been trying to reproduce the issue with a simple setup but so far without any luck.
>
> >
> > Best regards,
> > Martin
>
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> ______________________________________________________________________
В списке pgsql-general по дате отправления: