Обсуждение: Replication between different architectures

Dear Experts,

Is replication going to work from an x86-64 master to an
arm64 replica?

These are AWS EC2 instances, both 64-bit. I may eventually move
them all to ARM, but have a mix of architectures temporarily.
What could possibly go wrong ?!

(If it does fail, will I notice before it's too late?)


Thanks, Phil.

On Wed, Oct 13, 2021 at 05:09:36PM +0100, Phil Endecott wrote:
> Is replication going to work from an x86-64 master to an
> arm64 replica?

Hi,
tested, works well.

Best regards,

depesz

"Phil Endecott" <spam_from_pgsql_lists@chezphil.org> writes:
> Is replication going to work from an x86-64 master to an
> arm64 replica?

The hard part of this is usually whether the operating systems
are identical.  If they have different locale data, you may find
that indexes on text columns appear out-of-order and therefore
corrupt on the replica.  See

https://wiki.postgresql.org/wiki/Locale_data_changes

            regards, tom lane

Tom Lane wrote:
> "Phil Endecott" <spam_from_pgsql_lists@chezphil.org> writes:
>> Is replication going to work from an x86-64 master to an
>> arm64 replica?
>
> The hard part of this is usually whether the operating systems
> are identical.  If they have different locale data, you may find
> that indexes on text columns appear out-of-order and therefore
> corrupt on the replica.  See

Thanks Tom. All these systems are currently running Debian 11;
I dealt with the glibc locale issue a while ago.


Regards, Phil.