Postgres Pro
Downloads
Home   >   mailing lists

Re: Corrupted index on 9.0.3 streaming hot standby - Mailing list pgsql-bugs

From Jakub Ouhrabka
Subject Re: Corrupted index on 9.0.3 streaming hot standby
Date
Msg-id 4D74E88F.20306@comgate.cz
Whole thread Raw
In response to Re: Corrupted index on 9.0.3 streaming hot standby  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: Corrupted index on 9.0.3 streaming hot standby  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Itagaki Takahiro
Date:
Subject: pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()
Next
From: Tom Lane
Date:
Subject: Re: pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()