From b54f7a9ac9646845138f6851fdf3097e22daa383 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 2 Jul 2016 11:22:36 -0400 Subject: [PATCH] doc: mention dependency on collation libraries Document that index storage is dependent on the operating system's collation library ordering, and any change in that ordering can create invalid indexes. Discussion: 20160617154311.GB19359@momjian.us Backpatch-through: 9.1 --- doc/src/sgml/runtime.sgml | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml index 4a0e35a5eb..6d39ce7f22 100644 --- a/doc/src/sgml/runtime.sgml +++ b/doc/src/sgml/runtime.sgml @@ -183,6 +183,15 @@ postgres$ initdb -D /usr/local/pgsql/data locale setting. For details see . + + NonC and and non-POSIX locales rely on the + operating system's collation library for character set ordering. + This controls the ordering of keys stored in indexes. For this reason, + a cluster cannot switch to an incompatible collation library version, + either through snapshot restore, binary streaming replication, or + pg_upgrade run. + + Use of Secondary File Systems -- 2.40.0