On Mon, Mar 7, 2011 at 9:15 AM, Jakub Ouhrabka
wrote:
> 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 tim
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 t
On Thu, Mar 3, 2011 at 11:39 AM, Jakub Ouhrabka
wrote:
> Hi Robert,
>
>> If there hasn't been a system crash on the standby, then it's harder
>> to explain. It'd be interesting to compare the disk blocks in the
>> index on the standby with the disk blocks in the index on the master
>> and figure
Hi Robert,
> If there hasn't been a system crash on the standby, then it's harder
> to explain. It'd be interesting to compare the disk blocks in the
> index on the standby with the disk blocks in the index on the master
> and figure out which ones are different and in what way. pg_filedump
> m
2011/2/25 Jakub Ouhrabka :
> Hi,
>
> we've found that we have corrupted index on 9.0.3 streaming hot standby.
> Master works ok. There is one more non-streaming standby which is ok as
> well. Platform is 64bit Linux.
>
> Database cluster and this database were created on 9.0.2 and than upgraded
> t
Hi,
Do you still have the WAL files?
what do you mean exactly? We don't have full history of WAL files from
creation of hot streaming standby. They are recycled. We have set of WAL
files from the point we discovered the corrupted index and stopped the
cluster. But it was probably days after
Excerpts from Jakub Ouhrabka's message of vie feb 25 08:20:33 -0300 2011:
> For details about corrupted index see below. The table and index in
> question are mostly read-only (several queries per second) writes happen
> only few times a day.
>
> We've backed up whole cluster and recreated it.
Hi,
we've found that we have corrupted index on 9.0.3 streaming hot standby.
Master works ok. There is one more non-streaming standby which is ok as
well. Platform is 64bit Linux.
Database cluster and this database were created on 9.0.2 and than
upgraded to 9.0.3. We are not aware of any cra
