Re: replication

Hello,

One of my customers tells me he did a replication with the master on a debian 10

and the slave on a debian 12, both with a pg13.20, one on a pgdg110+1, the other a pgdg120.1

is this a good idea ??? (I don't think so...)

Sorry I dont quite get the pgdg110 vs pgdg120 distinction I guess they each support a different release of debian, but using the same architecture (e.g. amd64), same on disk structure structure , same PostgreSQL major version is a minimum for physical replication and you are 100% safe with that.

In order to be more flexible your client might want to try logical replication which lifts any of the restrictions mentioned above (if applicable) and even allows near zero-time upgrades.

thanks,

Marc MILLAS

Senior Architect

+33607850334