Обсуждение: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

Поиск

Список

Период

Сортировка

upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

От

Mariel Cherkassky

Дата:

11 июля 2018 г., 17:38:01

Hi,

I have in my company 3 postgresql nodes(v9.6) that are configured as one primary and 2 slaves. The repmgr tool is reponsible for the replication. I want to upgrade all the nodes to version 10.4. I know that PostgreSQL doesnt support streaming replication between different major versions. Did someone try this kind of upgrade without having any downtime ?

Thanks , Mariel.

Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

От

John Scalia

Дата:

11 июля 2018 г., 19:06:44

You can do this with the pglogical extension. I asked a similar question about a week ago.
—
Jay

Sent from my iPhone

> On Jul 11, 2018, at 10:38 AM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:
>
> Hi,
> I have in my company 3 postgresql nodes(v9.6) that are configured as one primary and 2 slaves. The repmgr tool is
reponsiblefor the replication. I want to upgrade all the nodes to version 10.4. I know that PostgreSQL doesnt support
streamingreplication between different major versions. Did someone try this kind of upgrade without having any downtime
?
>
> Thanks , Mariel.

Вход в личный кабинет

Восстановление пароля

Подтверждение аккаунта

Изменение пароля

Обсуждение: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME

Re: upgrading postgresql cluster(3 nodes) to v10 without DOWNTIME