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 по дате отправления:

Предыдущее
От: "Shulgin, Oleksandr"
Дата:
Сообщение: Re: Add relcreated (timestamp) column to pg_class catalog to record the time an object was created
Следующее
От: Tim Klicks
Дата:
Сообщение: Re: Pgsql troubleshooting & Iscsi