Re: Physical replication from x86_64 to ARM64

2021-09-15 Thread Dmitry Dolgov
> On Tue, Sep 14, 2021 at 08:07:19AM -0700, Andres Freund wrote: > > >Yeah. As far as the hardware goes, if you have the same endianness, > >struct alignment rules, and floating-point format [1], then physical > >replication ought to work. Where things get far stickier is if the > >operating syst

Re: Physical replication from x86_64 to ARM64

2021-09-14 Thread Andres Freund
Hi, On September 14, 2021 7:11:25 AM PDT, Tom Lane wrote: >Aleksander Alekseev writes: >>> 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 p

Re: Physical replication from x86_64 to ARM64

2021-09-14 Thread Tom Lane
Aleksander Alekseev writes: >> 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 201

Re: Physical replication from x86_64 to ARM64

2021-09-14 Thread Aleksander Alekseev
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

Physical replication from x86_64 to ARM64

2021-09-14 Thread Jan Mußler
Fellow Postgres Admins and Developers, With the arrival of ARM compute nodes on AWS and an existing fleet of Postgres clusters running on x86_64 nodes the question arises how to migrate existing Postgres clusters to ARM64 nodes, ideally with zero downtime, as one is used to. Initial experiments s