From 539b3dcb2622b135e1791151f4676c49823b6ee7 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Sat, 2 Jul 2016 11:22:35 -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 59909059f17..fbda1a45163 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.39.5