Re: [ADMIN] Questions on Streaming Replication - Mailing list pgsql-admin

From Om Prakash Jaiswal
Subject Re: [ADMIN] Questions on Streaming Replication
Date
Msg-id 459341231.6362931.1499310234016@mail.yahoo.com
Whole thread Raw
In response to [ADMIN] Questions on Streaming Replication  (Wei Shan <weishan.ang@gmail.com>)
Responses Re: [ADMIN] Questions on Streaming Replication  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-admin
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!

--
Regards,
Ang Wei Shan


pgsql-admin by date:

Previous
From: Ashish Tiwari
Date:
Subject: Re: [ADMIN] Questions on Streaming Replication
Next
From: Scott Marlowe
Date:
Subject: Re: [ADMIN] Questions on Streaming Replication