Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?

Поиск
Список
Период
Сортировка
От Andrey M. Borodin
Тема Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?
Дата
Msg-id 206B487C-B20E-4140-9C25-C6694CE7D4D4@yandex-team.ru
обсуждение исходный текст
Ответ на Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Fast upgrade of highly available cluster is a vital part of being industry-acceptable solution for any data management system. Because the cluster is required to be highly available.

Without this documented technique upgrade of 1Tb cluster would last many hours, not seconds.
There are industry concerns about scalability beyond tens of terabytes per cluster, but such downtime would significantly lower that boundary.

On 1 Jul 2023, at 01:16, Robert Haas <robertmhaas@gmail.com> wrote:

 If somebody
wants to write a reliable tool for this to ship as part of PostgreSQL,
well and good.

IMV that's a good idea. We could teach pg_upgrade or some new tool to do that reliably. The tricky part is that the tool must stop-start standby remotely...


Best regards, Andrey Borodin.

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Outdated description of PG_CACHE_LINE_SIZE
Следующее
От: "Joel Jacobson"
Дата:
Сообщение: Re: Do we want a hashset type?