Thread: Binary compatibility

Binary compatibility

From
Alexander Pyhalov
Date:
Hello.
We have FreeBSD/amd64 PostgreSQL 9.0 server and would like to move data
to Linux/amd64 PostgreSQL 9.0 server. Are databases on these systems
binary compatible? Can I just transfer datafiles or I have to do full
export/import?
--
Best regards,
Alexander Pyhalov,
system administrator of Computer Center of Southern Federal University

Re: Binary compatibility

From
Tom Lane
Date:
Alexander Pyhalov <alp@rsu.ru> writes:
> We have FreeBSD/amd64 PostgreSQL 9.0 server and would like to move data
> to Linux/amd64 PostgreSQL 9.0 server. Are databases on these systems
> binary compatible? Can I just transfer datafiles or I have to do full
> export/import?

If built with same configure options, I'd expect those two to be binary
compatible.  But the wise man will test it before trusting it, no?

            regards, tom lane