Replication is possible between two OS.
You can use BUCARDO Asynchronous replication system. Which follow TCP/IP standard protocol,
It does not matter which OS you are using. Only nature and signature(Table name and data type) should match.
It may be some other tools like slony, rubyrep also work. Because they also use TCP/IP protocol.
Although Bucardo I have used across two operating system RHEL 6(32bit) and RHEL7(64bit). It is working.
Regards
Om Prakash
DBA, Bangalore
Mob: 9035635787
On Thursday, 6 July 2017 5:01 AM, Wei Shan <weishan.ang@gmail.com> wrote:
Hi all!
Is it possible setup streaming replication between different OS?
For example, between RHEL6 and RHEL7. I understand that it is not possible between Windows and Linux.I need to migrate a PostgreSQL instance to a new host, while upgrading the OS if possible.
Has anyone done this before?
Thanks in advance!