Re: Corrupted index on 9.0.3 streaming hot standby

From: Jakub Ouhrabka <jakub(dot)ouhrabka(at)comgate(dot)cz>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: Re: Corrupted index on 9.0.3 streaming hot standby
Date: 2011-03-07 14:15:43
Message-ID: 4D74E88F.20306@comgate.cz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

for the archives: the root cause is locale. Both linux/debian servers
were set to the same locale (cs_CZ.UTF-8) but there is slightly
different definition of this locale on those systems - once numbers are
before letters and another time numbers are after letters. Then the
index appears to be broken...

So definitely it's not a postgresql bug. It'd be nice if there are some
safeguards against this mismatch, although I don't know how to do it...

Sorry for the noise.

Kuba

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-03-07 15:38:03 Re: pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()
Previous Message Itagaki Takahiro 2011-03-07 11:44:45 pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()