pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedStreaming Replication limitations
9+ messages / 7 participants
[nested] [flat]
* Streaming Replication limitations
@ 2011-04-13 17:53 raghu ram <raghuchennuru@gmail.com>
0 siblings, 2 replies; 9+ messages in thread
From: raghu ram @ 2011-04-13 17:53 UTC (permalink / raw)
To: pgsql-admin; pgsql-general@postgresql.org
Hi,
Is there any limitations to configure streaming replication between
different operating systems i.e solaris 64 bit to RHEL 64 bit.
--Raghu Ram
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 17:55 Devrim GÜNDÜZ <devrim@gunduz.org>
parent: raghu ram <raghuchennuru@gmail.com>
1 sibling, 1 reply; 9+ messages in thread
From: Devrim GÜNDÜZ @ 2011-04-13 17:55 UTC (permalink / raw)
To: raghu ram <raghuchennuru@gmail.com>; +Cc: pgsql-admin; pgsql-general@postgresql.org
Hi,
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.
It won't work.
Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Attachments:
signature.asc (application/pgp-signature, 197B) download
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [GENERAL] Streaming Replication limitations
@ 2011-04-13 18:04 Andrew Sullivan <ajs@crankycanuck.ca>
parent: raghu ram <raghuchennuru@gmail.com>
1 sibling, 0 replies; 9+ messages in thread
From: Andrew Sullivan @ 2011-04-13 18:04 UTC (permalink / raw)
To: pgsql-general@postgresql.org; pgsql-admin
On Wed, Apr 13, 2011 at 11:23:24PM +0530, raghu ram wrote:
> Hi,
>
> Is there any limitations to configure streaming replication between
> different operating systems i.e solaris 64 bit to RHEL 64 bit.
I personally wouldn't be willing to use anything except identical
binaries for the back end, and those two platforms are binary
incompatible. The manual actually warns about this.
A
--
Andrew Sullivan
ajs@crankycanuck.ca
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 18:06 Tom Lane <tgl@sss.pgh.pa.us>
parent: Devrim GÜNDÜZ <devrim@gunduz.org>
0 siblings, 3 replies; 9+ messages in thread
From: Tom Lane @ 2011-04-13 18:06 UTC (permalink / raw)
To: Devrim GÜNDÜZ <devrim@gunduz.org>; +Cc: raghu ram <raghuchennuru@gmail.com>; pgsql-admin; pgsql-general@postgresql.org
Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> 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.
> 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
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 18:23 AShved@symcor.com
parent: Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 9+ messages in thread
From: AShved@symcor.com @ 2011-04-13 18:23 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, pgsql-general@postgresql.org, raghu ram <raghuchennuru@gmail.com>
since your onine logs are in different endian notation. I do not see how
it would work. Sony may be an option in this case.
Andrew Shved
From:
Tom Lane <tgl@sss.pgh.pa.us>
To:
Devrim GÜNDÜZ <devrim@gunduz.org>
Cc:
raghu ram <raghuchennuru@gmail.com>, pgsql-admin@postgresql.org,
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 =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> 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.
> 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
CONFIDENTIALITY WARNING
This communication, including any attachments, is for the exclusive use of addressee and may contain proprietary and/or confidential information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage exclusif de la personne à laquelle il s’adresse et peut contenir de l’information personnelle ou confidentielle. Si le lecteur de ce message n’en est pas le destinataire, nous l’avisons par la présente que toute diffusion, distribution, reproduction ou utilisation de son contenu est strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier électronique et supprimez ce message ainsi que toutes les pièces jointes.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 18:28 AShved@symcor.com
parent: Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 9+ messages in thread
From: AShved@symcor.com @ 2011-04-13 18:28 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; pgsql-admin@postgresql.org, pgsql-admin-owner@postgresql.org, pgsql-general@postgresql.org, raghu ram <raghuchennuru@gmail.com>
just hit me what if we use pg_standby 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ÜNDÜZ <devrim@gunduz.org>
Cc:
raghu ram <raghuchennuru@gmail.com>, pgsql-admin@postgresql.org,
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 =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> 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.
> 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
CONFIDENTIALITY WARNING
This communication, including any attachments, is for the exclusive use of addressee and may contain proprietary and/or confidential information. If you are not the intended recipient, any use, copying, disclosure, dissemination or distribution is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this communication and destroy all copies.
AVERTISSEMENT RELATIF À LA CONFIDENTIALITÉ
Ce message, ainsi que les pièces qui y sont jointes, est destiné à l’usage exclusif de la personne à laquelle il s’adresse et peut contenir de l’information personnelle ou confidentielle. Si le lecteur de ce message n’en est pas le destinataire, nous l’avisons par la présente que toute diffusion, distribution, reproduction ou utilisation de son contenu est strictement interdite. Veuillez avertir sur-le-champ l’expéditeur par retour de courrier électronique et supprimez ce message ainsi que toutes les pièces jointes.
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 18:34 Simon Riggs <simon@2ndQuadrant.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 1 reply; 9+ messages in thread
From: Simon Riggs @ 2011-04-13 18:34 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; raghu ram <raghuchennuru@gmail.com>; pgsql-admin; pgsql-general <pgsql-general@postgresql.org>
2011/4/13 Tom Lane <tgl@sss.pgh.pa.us>:
> Devrim =?ISO-8859-1?Q?G=DCND=DCZ?= <devrim@gunduz.org> 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.
>
>> 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.
That's the long answer, not least because the absence of a failure in
a test is not conclusive proof that it won't fail at some point in the
future while in production.
The short answer is "don't do it".
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: Streaming Replication limitations
@ 2011-04-13 18:42 Tom Lane <tgl@sss.pgh.pa.us>
parent: Simon Riggs <simon@2ndQuadrant.com>
0 siblings, 1 reply; 9+ messages in thread
From: Tom Lane @ 2011-04-13 18:42 UTC (permalink / raw)
To: Simon Riggs <simon@2ndQuadrant.com>; +Cc: Devrim GÜNDÜZ <devrim@gunduz.org>; raghu ram <raghuchennuru@gmail.com>; pgsql-admin; pgsql-general <pgsql-general@postgresql.org>
Simon Riggs <simon@2ndQuadrant.com> writes:
> 2011/4/13 Tom Lane <tgl@sss.pgh.pa.us>:
>> Short answer is to test the case you have in mind and see.
> That's the long answer, not least because the absence of a failure in
> a test is not conclusive proof that it won't fail at some point in the
> future while in production.
Not really. Every known source of incompatibility (endianness,
alignment, float format, etc) is checked at postmaster startup via
entries in pg_control. If you get the slave postmaster to start at all,
it will probably work, though certainly more extensive testing than that
would be advisable.
> The short answer is "don't do it".
DBAs are paid to be incredibly paranoid, and from that mindset this
answer makes sense. But there's a big difference between "it won't work"
and "I'm afraid to risk my paycheck on this because there might possibly
be some problem that no one knows about yet". Let's be perfectly clear
that this is a question of the second case not the first.
regards, tom lane
^ permalink raw reply [nested|flat] 9+ messages in thread
* Re: [GENERAL] Streaming Replication limitations
@ 2011-04-14 23:30 Jeff Davis <pgsql@j-davis.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 9+ messages in thread
From: Jeff Davis @ 2011-04-14 23:30 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: Simon Riggs <simon@2ndQuadrant.com>; Devrim GÜNDÜZ <devrim@gunduz.org>; raghu ram <raghuchennuru@gmail.com>; pgsql-admin; pgsql-general <pgsql-general@postgresql.org>
On Wed, 2011-04-13 at 14:42 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > 2011/4/13 Tom Lane <tgl@sss.pgh.pa.us>:
> >> Short answer is to test the case you have in mind and see.
>
> > That's the long answer, not least because the absence of a failure in
> > a test is not conclusive proof that it won't fail at some point in the
> > future while in production.
>
> Not really. Every known source of incompatibility (endianness,
> alignment, float format, etc) is checked at postmaster startup via
> entries in pg_control.
I seem to remember that Mac and Linux have a different notion of what
en_US collation means (I couldn't find any standard anywhere to say that
one was right and the other was wrong). So, that risks index corruption.
Regards,
Jeff Davis
^ permalink raw reply [nested|flat] 9+ messages in thread
end of thread, other threads:[~2011-04-14 23:30 UTC | newest]
Thread overview: 9+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-04-13 17:53 Streaming Replication limitations raghu ram <raghuchennuru@gmail.com>
2011-04-13 17:55 ` Devrim GÜNDÜZ <devrim@gunduz.org>
2011-04-13 18:06 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-04-13 18:23 ` AShved@symcor.com
2011-04-13 18:28 ` AShved@symcor.com
2011-04-13 18:34 ` Simon Riggs <simon@2ndQuadrant.com>
2011-04-13 18:42 ` Tom Lane <tgl@sss.pgh.pa.us>
2011-04-14 23:30 ` Jeff Davis <pgsql@j-davis.com>
2011-04-13 18:04 ` Andrew Sullivan <ajs@crankycanuck.ca>
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