Rod Taylor <pg(at)rbt(dot)ca> writes:
> Secondly, is PostgreSQL smart enough to complain in these cases or will
> it be silent and cause unexpected data corruption later on?
It will catch anything that affects the contents or layout of
pg_control, which includes a fair amount of stuff (endianness,
most of the popular compile options, probably alignment). We
don't really guarantee to catch every possible incompatibility,
however.
> Can you go from Sparc on Solaris to Linux on AMD?
Almost certainly not --- aren't they different endianness?
> How about from UltraSparc IV to UltraSparc III?
Damifino. How much difference is there between those architectures?
regards, tom lane