public inbox for [email protected]
help / color / mirror / Atom feedFrom: Andrey M. Borodin <[email protected]>
To: Robert Haas <[email protected]>
Cc: Bruce Momjian <[email protected]>
Cc: Nikolay Samokhvalov <[email protected]>
Cc: pgsql-hackers <[email protected]>
Cc: Stephen Frost <[email protected]>
Subject: Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?
Date: Sat, 1 Jul 2023 14:02:23 +0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+TgmoYQXT1L9dbAP1246xoYZ0VXd5M+HwMgzJK6MGosZ5_UZg@mail.gmail.com>
References: <CAM527d8heqkjG5VrvjU3Xjsqxg41ufUyabD9QZccdAxnpbRH-Q@mail.gmail.com>
<CA+TgmoaHby8skVd1CMbpzadDPYr+zVNtwApD0V61PUNvhwOCGA@mail.gmail.com>
<[email protected]>
<CA+TgmoYQXT1L9dbAP1246xoYZ0VXd5M+HwMgzJK6MGosZ5_UZg@mail.gmail.com>
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 <[email protected]> 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.
view thread (3+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox