Thread: Binary compatibility
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
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