From: Jeff Davis <pgsql@j-davis.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Simon Riggs <simon@2ndQuadrant.com>
Cc: Devrim GÜNDÜZ <devrim@gunduz.org>
Cc: raghu ram <raghuchennuru@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Cc: pgsql-general <pgsql-general@postgresql.org>
Subject: Re: [GENERAL] Streaming Replication limitations
Date: Thu, 14 Apr 2011 16:30:46 -0700
Message-ID: <1302823846.7584.2.camel@jdavis-ux.asterdata.local> (raw)
In-Reply-To: <10017.1302720177@sss.pgh.pa.us>
References: <BANLkTimp9PFZ-j7HRShYUWn55JgJ7h+hXA@mail.gmail.com>
<1302717319.8788.4.camel@lenovo01-laptop03.gunduz.org>
<9304.1302718017@sss.pgh.pa.us>
<BANLkTikL+0V+ZFToy3o66o02=rxEq47=mA@mail.gmail.com>
<10017.1302720177@sss.pgh.pa.us>
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
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: pgsql@j-davis.com, tgl@sss.pgh.pa.us, simon@2ndQuadrant.com, devrim@gunduz.org, raghuchennuru@gmail.com, pgsql-general@postgresql.org
Subject: Re: [GENERAL] Streaming Replication limitations
In-Reply-To: <1302823846.7584.2.camel@jdavis-ux.asterdata.local>
* 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