Re: Corrupted index on 9.0.3 streaming hot standby

Поиск
Список
Период
Сортировка
От Jakub Ouhrabka
Тема Re: Corrupted index on 9.0.3 streaming hot standby
Дата
Msg-id 4D74E88F.20306@comgate.cz
обсуждение исходный текст
Ответ на Re: Corrupted index on 9.0.3 streaming hot standby  (Robert Haas <robertmhaas@gmail.com>)
Ответы Re: Corrupted index on 9.0.3 streaming hot standby  (Robert Haas <robertmhaas@gmail.com>)
Список 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

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Itagaki Takahiro
Дата:
Сообщение: pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_stat_all_tables.vacuum_count corrupted after pg_stat_reset()