On Thu, Oct 31, 2024 at 10:26:01AM -0400, Tom Lane wrote: > I'd be okay with adding it in a form where the default behavior > is to do no additional checking. Whether that's worth maintaining > is hard to say though.
In terms of maintenance, it would be nice if we are able to minimize the code added to the pg_upgrade suite, so as it would be simple to switch this code elsewhere if need be. I'd imagine a couple of new routines, in the lines of: - Dump of a database into an output file given in input, as a routine of Cluster.pm so as it is possible to do dumps from different major versions. Format should be defined in input. - Restore to a database from an input file, also as a routine of Cluster.pm, for the major version argument. - Filter of the dumps for the contents where column ordering is inconsistent up at restore. In a new module. - Comparison of two dumps, with potentially filters applied to them, with diff printed. In a new module. -- Michael
signature.asc
Description: PGP signature
