Hey, thanks for the reply. On Thu, Aug 31, 2023 at 6:50 PM David Steele <da...@pgmasters.net> wrote: > pg_subtrans, at least, can be ignored since it is excluded from the > backup and not required for recovery.
I agree... > Welcome to the club! Thanks for the welcome, but being a member feels *terrible*. :-) > I do not. My conclusion back then was that validating a physical > comparison would be nearly impossible without changes to Postgres to > make the primary and standby match via replication. Which, by the way, I > still think would be a great idea. In principle, at least. Replay is > already a major bottleneck and anything that makes it slower will likely > not be very popular. Fair point. But maybe the bigger issue is the work involved. I don't think zeroing the hole in all cases would likely be that expensive, but finding everything that can cause the standby to diverge from the primary and fixing all of it sounds like an unpleasant amount of effort. Still, it's good to know that I'm not missing something obvious. > No objections to 0001/0002. Cool. -- Robert Haas EDB: http://www.enterprisedb.com
