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@xxxxxxxxxxxxx>: > > Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
