On 2023-Apr-07, Julien Rouhaud wrote: > That being said, I have a hard time believing that we could actually preserve > physical replication slots. I don't think that pg_upgrade final state is > fully > reproducible: not all object oids are preserved, and the various pg_restore > are run in parallel so you're very likely to end up with small physical > differences that would be incompatible with physical replication. Even if we > could make it totally reproducible, it would probably be at the cost of making > pg_upgrade orders of magnitude slower. And since many people are already > complaining that it's too slow, that doesn't seem like something we would > want.
A point on preserving physical replication slots: because we change WAL format from one major version to the next (adding new messages or changing format for other messages), we can't currently rely on physical slots working across different major versions. So IMO, for now don't bother with physical replication slot preservation, but do keep the option name as specific to logical slots. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
