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 a hitch. 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@xxxxxxxxxxx
