Re: Possible corrupt index?

On 4/17/19 12:42 AM, Zahir Lalani wrote:
>> 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
ahitch. This issue has only occurred recently
 

Any changes occur between the time it worked and the time it did not?
Say a crash, change in schema, new data added and so on.

Per below the version 10 servers use en_GB.UTF_8 and the production one 
en_US.UTF-8.

Why the difference?

And did the production used to be en_GB.UTF_8?

Have you logged into the production instance using psql and tried the 
queries to see if they work?

> 
>> 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
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com