From: Om Prakash Jaiswal <op12om@yahoo.co.in>
To: Wei Shan <weishan.ang@gmail.com>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Questions on Streaming Replication
Date: Thu, 6 Jul 2017 03:03:54 +0000 (UTC)
Message-ID: <459341231.6362931.1499310234016@mail.yahoo.com> (raw)
In-Reply-To: <CAFe9ZTqSgyqP8Sd-BnQWs88SHwkpW5NsMypuVUdWbA=L+Fm7FA@mail.gmail.com>
References: <CAFe9ZTqSgyqP8Sd-BnQWs88SHwkpW5NsMypuVUdWbA=L+Fm7FA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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.
RegardsOm PrakashDBA, BangaloreMob: 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: op12om@yahoo.co.in, weishan.ang@gmail.com
Subject: Re: Questions on Streaming Replication
In-Reply-To: <459341231.6362931.1499310234016@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox