RE: Possible corrupt index? - Mailing list pgsql-general

From Zahir Lalani
Subject RE: Possible corrupt index?
Date
Msg-id AM0PR06MB400498ED0A781F3568367FB0A7250@AM0PR06MB4004.eurprd06.prod.outlook.com
Whole thread Raw
In response to Re: Possible corrupt index?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Possible corrupt index?  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
>I am not following above.
>What is running version 10?

Production is 9.6, others are 10 (as we are testing). Prod has always been fine, its been running for 2 years without a
hitch.This issue has only occurred recently
 

>Did you restore a dump from a version 10 onto a >version 9.6 machine?

No - as I said, I don’t believe it’s a version issue as its been fine for 2 years.

> 
>> What does:
>> SHOW lc_collate;
> 
> en_US.UTF-8

>The above is the same for all the servers?

The upgraded 10 servers are en_GB.UTF_8. The current prod 9.6 is as above


Z

pgsql-general by date:

Previous
From: Julie Nishimura
Date:
Subject: Re: text search configuration missing while migration from 8.3 to 9.4
Next
From: Tim Kane
Date:
Subject: Re: Alter domain type / avoiding table rewrite