PG Upgrade with hardlinks, when to start/stop master and replicas

Поиск
Список
Период
Сортировка
От Martín Fernández
Тема PG Upgrade with hardlinks, when to start/stop master and replicas
Дата
Msg-id 5c6b0bc5828e9f3dde000002@polymail.io
обсуждение исходный текст
Ответы Re: PG Upgrade with hardlinks, when to start/stop master andreplicas  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: PG Upgrade with hardlinks, when to start/stop master and replicas  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Hello everyone!

We are about to upgrade a 6 instance cluster from pg92 to pg10 using pg_upgrade with hardlinks and rsync.

Our preliminary tests are working really good so far but on question has popped up that we feel is really critical because it has an important impact on our failover plan.

After reading the pg_upgrade documentation multiple times, it seems that after running pg_upgrade on the primary instance, we can't start it until we run rsync from the primary to the standby. I'm understanding this from the following section in the pg_upgrade manual page.


```
You will not be running pg_upgrade on the standby servers, but rather rsync on the
           primary. Do not start any servers yet.
```

I'm understanding the `any` as primary and standbys.

On the other hand, we've been doing tests that start the primary instance as soon as pg_upgrade is done. This tests have worked perfectly fine so far. We make the rsync call with the primary instance running and the standby can start later on after rsync is done and we copy the new configuration files.

If what we are doing is wrong, we need to run `rsync` before starting the primary instance, that would mean that the primary and the standby are not usable if pg10 doesn't start correctly in the primary right ? 

I hope my question is clear enough! 

Best,
Martín

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

Предыдущее
От: Hugh Ranalli
Дата:
Сообщение: Re: Channel binding not supported using scram-sha-256 passwords
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: PG Upgrade with hardlinks, when to start/stop master andreplicas