Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1dSxB2-0005mF-Bk for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jul 2017 03:10:01 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1dSxB1-0006Mz-QF for pgsql-admin@arkaria.postgresql.org; Thu, 06 Jul 2017 03:09:59 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dSx9F-00039H-Oc for pgsql-admin@postgresql.org; Thu, 06 Jul 2017 03:08:10 +0000 Received: from sonic309-48.consmr.mail.sg3.yahoo.com ([106.10.244.111]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1dSx9C-0001QB-PA for pgsql-admin@postgresql.org; Thu, 06 Jul 2017 03:08:09 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.co.in; s=s2048; t=1499310481; bh=9JztnOn78hLw9PARUHL3TpAccbYtRcmYxI381ZL9zP8=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject; b=sOpGC2SroykXn5k65bAfyAx+jb8FOk30jQ+tUgrbdXzjHUVZnGFxxC4rEF/YN3+NBF7x43ZopkuubP0JJ4njHL/jTjlrd48ahZm2fdXvNeb9OYvku3MvaZaS82C4fqERC62um1OReDEOQ4tVVTjir5yBuUd0xGyQGCSDMHAFnd8ARzFJU2vcKSBXTQHwRhEcMLWeDaO3elLLDtobwEw6jaHkNCEXBCzjb3Of6KZBFwU+fyMbM2M5+k4cU+qn61Eg8B1MuBYddT+RbLW0QDDWSiGV7+F2ok/MQSiqcYof/HqfgEhDhdoJKg/hYxSW72UaWbfwjZ//z4a1lSGfkhUt/A== X-YMail-OSG: z6Bm9uIVM1nPTllOYE071sma9y2ew2wRQ4TWvVEftGBOqj.meFTPHDsmr1opgZm hL2tNAs79mLZ6C3fZHZLv3meMwm5QZGM0p8KS0zVKp52IuM7v50sR20b3VP9HO.9GSOTiS1l_gJJ iM.Glqm8yIWQ5NKGG1sKb_aAmpAE..u2wOGJv8BJne6YhI6AIviyF9kKZnQ0RZpg7SfGTXnBAGS7 ENB7tiRQwTY.IXDpm7uiUn4jdSDBHHv62LCmweIkFg2o2ukN6FYI0P5VkEex.jdk2V5WgWaBvvSN uHr5DoGgO2MiDLh6lBRyE6Tv9Yqi5SzYD9cifBoPAO1y2FbNu43nUbGi9IL.Y5a9HFCOKQ.fVK97 hMtngUCt5ehDqeQIIqC5YVh2G9aI0YH.nAucrWVTemTRi1OKf5ps6eyDBk_t8syfLIoTWduA3wd5 9k755PEsLoPQG_YTSGyen2qw1hhLLknz1XcnevJY1awqMMBF0EVErF9_Y86y9Anfs.2v0Coqn8GN AIs.593jpDJ3HNZ.xB5Fx7EBOFbkYbC_dTRLKpck- Received: from sonic.gate.mail.ne1.yahoo.com by sonic309.consmr.mail.sg3.yahoo.com with HTTP; Thu, 6 Jul 2017 03:08:01 +0000 Date: Thu, 6 Jul 2017 03:03:54 +0000 (UTC) From: Om Prakash Jaiswal Reply-To: Om Prakash Jaiswal To: Wei Shan , pgsql-admin Message-ID: <459341231.6362931.1499310234016@mail.yahoo.com> In-Reply-To: References: Subject: Re: Questions on Streaming Replication MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6362930_1369886585.1499310234013" X-Mailer: WebService/1.1.9978 YahooMailNeo Mozilla/5.0 (X11; Linux x86_64; rv:50.0) Gecko/20100101 Firefox/50.0 Content-Length: 3901 List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org ------=_Part_6362930_1369886585.1499310234013 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Replication is possible between two OS.You can use BUCARDO Asynchronous rep= lication system. Which follow TCP/IP standard protocol,It does not matter w= hich=C2=A0 OS you are using. Only nature and signature(Table name and data = type) should match. It may be some other tools like slony, rubyrep=C2=A0 also work. Because the= y also use TCP/IP protocol.Although Bucardo I have used across two operatin= g system RHEL 6(32bit) and RHEL7(64bit). It is working. RegardsOm PrakashDBA, BangaloreMob: 9035635787 =20 On Thursday, 6 July 2017 5:01 AM, Wei Shan wrot= e: =20 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! --=20 Regards, Ang Wei Shan =20 ------=_Part_6362930_1369886585.1499310234013 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
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 w= ork. 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: 903563578= 7


On Thursday, 6 July 2017 5:01 AM, Wei Shan <weishan.ang@gmail.com= > wrote:


Hi all!

Is it poss= ible setup streaming replication between different OS?

=
For example, between RHEL6 and RHEL7. I understand that it is not poss= ible 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!
=

--
Rega= rds,
Ang Wei Shan


------=_Part_6362930_1369886585.1499310234013--