Postgres Pro
Downloads
Home   >   mailing lists

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

From Bruce Momjian
Subject Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?
Date
Msg-id ZJ9Y0TLJ9xczF5s2@momjian.us
Whole thread Raw
In response to Re: pg_upgrade instructions involving "rsync --size-only" might lead to standby corruption?  (Nikolay Samokhvalov <nik@postgres.ai>)
List pgsql-hackers
Tree view 
On Fri, Jun 30, 2023 at 03:18:03PM -0700, Nikolay Samokhvalov wrote:
> I wonder, if we ensure that standbys are fully caught up before upgrading the
> primary, if we check the latest checkpoint positions, are we good to use "rsync
> --size-only", or there are still some concerns? It seems so to me, but maybe
> I'm missing something.

Yes, I think you are correct.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Only you can decide what is important to you.

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Should we remove db_user_namespace?
Next
From: Bruce Momjian
Date:
Subject: Re: Initdb-time block size specification