Re: Questions on Streaming Replication

On Wed, Jul 5, 2017 at 9:03 PM, Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in> wrote:
> 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(dot)ang(at)gmail(dot)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?

They key here is that your postgresql's need to agree on things like
date format etc and be in teh same binary format.

I do know that with linux they don't have to have the same OS
underneath them. Just the same basic postgresql version.

Not sure on windows to linux though. Never done that.