Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B51C01337BFC; Wed, 13 Apr 2011 15:32:18 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 26987-01-9; Wed, 13 Apr 2011 18:32:09 +0000 (UTC) X-Greylist: delayed 00:05:35.409182 by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mr2.symcor.com (mr2.symcor.com [205.189.242.12]) by mail.postgresql.org (Postfix) with ESMTP id 52A631337BE4; Wed, 13 Apr 2011 15:28:46 -0300 (ADT) X-IronPort-AV: E=Sophos;i="4.64,205,1301889600"; d="scan'208";a="4011642" Content-Type: multipart/mixed; boundary="===============1821006698==" MIME-Version: 1.0 Received: from tofrno01.symprod.com ([10.249.230.151]) by mr2.symcor.com with ESMTP; 13 Apr 2011 14:16:27 -0400 In-Reply-To: <9304.1302718017@sss.pgh.pa.us> References: <1302717319.8788.4.camel@lenovo01-laptop03.gunduz.org> <9304.1302718017@sss.pgh.pa.us> To: Tom Lane Cc: =?ISO-8859-1?Q?Devrim_G=DCND=DCZ?= , pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, pgsql-general@postgresql.org, raghu ram MIME-Version: 1.0 Subject: Re: Streaming Replication limitations X-KeepSent: 38E95CE7:72F908E5-85257871:006560EC; type=4; name=$KeepSent X-Mailer: Lotus Notes Release 8.5 FP1 June 17, 2009 Message-ID: From: AShved@symcor.com Date: Wed, 13 Apr 2011 14:28:46 -0400 X-MIMETrack: Serialize by Router on Prod01/Server/SYM(Release 8.5.1FP5|September 29, 2010) at 04/13/2011 02:28:46 PM, Serialize complete at 04/13/2011 02:28:46 PM X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=2.41 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FS_REPLICA=3.599, HTML_MESSAGE=0.001, SARE_SPEC_REPLICA=0.72, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: ** X-Archive-Number: 201104/131 X-Sequence-Number: 37312 --===============1821006698== MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="=_alternative 006582BC85257871_=" --=_alternative 006582BC85257871_= Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable just hit me what if we use pg=5Fstandby and convert archive logs from one=20 notation to the other. and after apply them to our standby. can this=20 work? Andrew Shved DBA, Symcor Inc, Delivery Support Services ( Phone: 905-273-1433 ( BlackBerry: 416-803-2675 * Email: ashved@symcor.com=20 From: Tom Lane To: Devrim G=DCND=DCZ Cc: raghu ram , pgsql-admin@postgresql.org,=20 pgsql-general@postgresql.org Date: 04/13/2011 02:14 PM Subject: Re: [ADMIN] Streaming Replication limitations Sent by: pgsql-admin-owner@postgresql.org Devrim =3D?ISO-8859-1?Q?G=3DDCND=3DDCZ?=3D writes: > On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote: >> Is there any limitations to configure streaming replication between >> different operating systems i.e solaris 64 bit to RHEL 64 bit.=20 > It won't work. As long as it's the same machine architecture, it probably will ... but if "solaris" here really means "sparc" then I agree. Short answer is to test the case you have in mind and see. regards, tom lane --=20 Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin --=_alternative 006582BC85257871_= Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: quoted-printable just hit me what if we use pg=5Fstandby = and convert archive logs from one notation to the other.  and after apply them to our standby. can this work?
Andrew Shved
DBA, Symcor Inc, Delivery Support Services
( Phone: 905-273-1433
(
BlackBerry: 416-803-2675
* Email: ashved@symcor.com



From: Tom Lane <tgl@sss.pgh.pa.us>
To: Devrim G=DCND=DCZ <devrim@gunduz.= org>
Cc: raghu ram <raghuchennuru@gmail.co= m>, pgsql-admin@postgresql.org, pgsql-general@postgresql.org
Date: 04/13/2011 02:14 PM
Subject: Re: [ADMIN] Streaming Replication li= mitations
Sent by: pgsql-admin-owner@postgresql.org





Devrim =3D?ISO-8859-1?Q?G=3DDCND=3DDCZ?=3D <devri= m@gunduz.org> writes:
> On Wed, 2011-04-13 at 23:23 +0530, raghu ram wrote:
>> Is there any limitations to configure streaming replication betwee= n
>> different operating systems i.e solaris 64 bit to RHEL 64 bit.

> It won't work.

As long as it's the same machine architecture, it probably will ...
but if "solaris" here really means "sparc" then I agree= .

Short answer is to test the case you have in mind and see.

                                                  regards, tom lane

--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
= http://www.postgresql.org/mailpref/pgsql-admin

--=_alternative 006582BC85257871_=-- --===============1821006698== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline CONFIDENTIALITY WARNING = This communication, including any attachments, is for the exclusive use of = addressee and may contain proprietary and/or confidential information. If y= ou are not the intended recipient, any use, copying, disclosure, disseminat= ion or distribution is strictly prohibited. If you are not the intended rec= ipient, please notify the sender immediately by return e-mail, delete this = communication and destroy all copies. AVERTISSEMENT RELATIF =C3=80 LA CONFIDENTIALIT=C3=89 = Ce message, ainsi que les pi=C3=A8ces qui y sont jointes, est destin=C3=A9 = =C3=A0 l=E2=80=99usage exclusif de la personne =C3=A0 laquelle il s=E2=80= =99adresse et peut contenir de l=E2=80=99information personnelle ou confide= ntielle. Si le lecteur de ce message n=E2=80=99en est pas le destinataire, = nous l=E2=80=99avisons par la pr=C3=A9sente que toute diffusion, distributi= on, reproduction ou utilisation de son contenu est strictement interdite. V= euillez avertir sur-le-champ l=E2=80=99exp=C3=A9diteur par retour de courri= er =C3=A9lectronique et supprimez ce message ainsi que toutes les pi=C3=A8c= es jointes. --===============1821006698==--