Re: Database cluster binary compatibility accross CPU platforms

Thanks for the explanation!
We are still not using ICU, so the reindex (endians - based on what I've
found about Graviton ARM64 cpu are same, but no information about datatype
alignment) will be a pain, so if we really opt for the platform we can give
it a try, but generally I'll expect restoring database from pg_dump taken
backup.

Kind regards Ales Zeleny

čt 27. 8. 2020 v 1:33 odesílatel Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> napsal:

> =?UTF-8?B?QWxlxaEgWmVsZW7DvQ==?= <zeleny(dot)ales(at)gmail(dot)com> writes:
> > is it supported to restore binary backup (pg_basebackup) taken on an
> amd64
> > platform on arm64 while using the same PostgreSQL version?
>
> I wouldn't say it's "supported", but you might get away with it,
> if the endianness and datatype alignment rules are the same.
> The database does do some basic checks on that using known values
> stored in the pg_control file, so it's likely you'd find out
> immediately at startup if any of those things don't match.
>
> What's significantly more risky, and which we do *not* have good
> checks for, is that unless these are different builds of the same
> version of the same operating system, the two platforms may not sort
> strings the same way; resulting in all your text indexes being
> corrupt. You can recover from that by reindexing, but it's hardly
> a painless transition.
>
> regards, tom lane
>