Re: [GENERAL] Streaming Replication limitations - Mailing list pgsql-admin

From Jeff Davis
Subject Re: [GENERAL] Streaming Replication limitations
Date
Msg-id 1302823846.7584.2.camel@jdavis-ux.asterdata.local
Whole thread Raw
In response to Re: Streaming Replication limitations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: Version String
Next
From: "Greg Sabino Mullane"
Date:
Subject: Re: Version String