On Thu, Apr 24, 2025 at 04:51:08PM +0200, Álvaro Herrera wrote:
> On 2025-Apr-24, Bruce Momjian wrote:
>
> > Do we think most people are _not_ going to use pg_upgrade now that we
> > are defaulting to checksums being enabled by default in PG 18? And if
> > so, do we think we are ever going to have a storage-format-changing
> > release where pg_upgrade cannot be used?
>
> Peter E posted a patch that allowed pg_upgrade to migrate (rewrite)
> files from non-checksummed to checksummed, but he appears to have given
> up on it for this release given an apparent lack of interest.
> https://postgr.es/m/57957aca-3eae-4106-afb2-3008122b9950@eisentraut.org
Yeah, I saw that, and I think we could do something similar for TDE if
we ever had it. I think we are suggesting people just do offline
addition of checksums rather than trying to do something fancy with
pg_upgrade.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Do not let urgent matters crowd out time for investment in the future.