Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file

Поиск
Список
Период
Сортировка
От Amit Bondwal
Тема Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Дата
Msg-id CAJ=k2iGp-8nD0DKksZRQRzd41fTzriEyA_x3iq0Lbdy2YNOcig@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-general
Дерево обсуждения
Michael, Thanks for your reply, I found the issue, the person who setup OS mix up some 64 and 32 bit package. I am starting it again.

Thanks again.

On Fri, Aug 21, 2015 at 5:12 PM, Michael Paquier <michael.paquier@gmail.com> wrote:


On Fri, Aug 21, 2015 at 7:56 PM, Amit Bondwal <bondwal.amit@gmail.com> wrote:
2015-08-21 15:35:03 IST [21507-2] DETAIL:  The primary's identifier is 6185381639353264094, the standby's identifier is 6185382953613258663.

It gives the error "database system identifier differs between the primary and standby".

This means that you are trying to use a standby that has been set up using the base backup from the node of another cluster (be it either standby or master node), different than the node you are trying to connect to. This error just reports the incompatibility.
--
Michael

В списке pgsql-general по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Re: Postgresql 9.3 hotstandby replication error, icorrect checksome in control file
Следующее
От: Laurent Laborde
Дата:
Сообщение: Re: hot backup with zfs ?