Re: Physical replication from x86_64 to ARM64 - Mailing list pgsql-hackers

From Aleksander Alekseev
Subject Re: Physical replication from x86_64 to ARM64
Date
Msg-id CAJ7c6TPUGRe1PKM8BBWrDM=TA7oJ0rV5CKC_dMwo51F+j3c=vg@mail.gmail.com
Whole thread Raw
In response to Physical replication from x86_64 to ARM64  (Jan Mußler <jan.mussler@zalando.de>)
Responses Re: Physical replication from x86_64 to ARM64  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi Jan,

> Initial experiments show no observable problems when copying PGDATA or in fact using physical streaming replication between the two CPU architectures.

That's an interesting result. The topic of physical replication compatibility interested me much back in 2017 and I raised this question on PGCon [1]. As I recall the compatibility is not guaranteed, nor tested, and not going to be, because the community doesn't have resources for this. The consensus was that to migrate without downtime the user has to use logical replication. Thus what you observe should be considered a hack, and if something will go wrong, you are on your own.

Of course, there is a possibility that something has changed in the past four years. I'm sure somebody on the mailing list will correct me in this case.


--
Best regards,
Aleksander Alekseev

pgsql-hackers by date:

Previous
From: Rajkumar Raghuwanshi
Date:
Subject: Getting ERROR "subplan "SubPlan 1" was not initialized" in EXISTS subplan when using for list partition.
Next
From: Daniel Gustafsson
Date:
Subject: Re: Small documentation improvement for ALTER SUBSCRIPTION