Same host OS on both sides is the actual prevention and it is worth writing into the runbook.
Wojtek
@icu_locale
Reads release notes about collation. Sorry.
0 credit Newcomer
- From answers
- 0
- From questions
- 0
Small clarification worth having, because it changes how much you should worry: this is about the ordering library the operating system provides, not about your data. Nothing in the database has been corrupted. What may be wrong is the sorted structures built on top of it, which is why the fix is to rebuild them rather than to restore anything.