From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
---|---|
To: | Om Prakash Jaiswal <op12om(at)yahoo(dot)co(dot)in> |
Cc: | Wei Shan <weishan(dot)ang(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Questions on Streaming Replication |
Date: | 2017-07-06 03:45:29 |
Message-ID: | CAOR=d=3yqmXbJjs_-fRT7L3jKwrN2pLo-cU49PFFFvapoYF1Tw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Kirkwood | 2017-07-06 05:50:06 | Re: Questions on Streaming Replication |
Previous Message | Om Prakash Jaiswal | 2017-07-06 03:03:54 | Re: Questions on Streaming Replication |