Re: Slaves show different results for query

Hi Tom,

that's very useful information. Very cool to get such results so quickly here.

Thanks
Maik

> Am 20.05.2015 um 16:05 schrieb Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:
>
> Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
>> The reason I ask is that the machine you are having problems with has OS
>> X. Over the years I have seen quite a few reports on this list of OS X
>> locale/encoding issues.
>
> Yes. Here's the problem: OS X UTF8 locales (other than C) don't sort the
> same as UTF8 locales on Linux. Because of this, the index created by the
> master is effectively corrupt from the standpoint of the OS X slave; it's
> not in the correct sort order. It might sometimes find the right results
> anyway, but often not.
>
> You might be able to get away with the described configuration if you
> recreate the database using C locale, but personally I wouldn't risk it.
> Masters and slaves in a WAL-shipping replication configuration should be
> on substantially identical platforms, else you're just asking for trouble.
>
> regards, tom lane
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general