aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2016-07-02 11:22:36 -0400
committerBruce Momjian <bruce@momjian.us>2016-07-02 11:22:36 -0400
commit2dc7da91054ee5135fae35fafe60bf2803d4d836 (patch)
treec56f4c1a7970238d73b7334b2f0735ad6c6d0fee
parentb25d87f91d39eb8aff259766141ddd2d2d374b41 (diff)
downloadpostgresql-2dc7da91054ee5135fae35fafe60bf2803d4d836.tar.gz
postgresql-2dc7da91054ee5135fae35fafe60bf2803d4d836.zip
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
-rw-r--r--doc/src/sgml/runtime.sgml9
1 files changed, 9 insertions, 0 deletions
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml
index b620ee76b50..310e2840119 100644
--- a/doc/src/sgml/runtime.sgml
+++ b/doc/src/sgml/runtime.sgml
@@ -183,6 +183,15 @@ postgres$ <userinput>initdb -D /usr/local/pgsql/data</userinput>
locale setting. For details see <xref linkend="multibyte">.
</para>
+ <para>
+ Non<literal>C</> and and non-<literal>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
+ <application>pg_upgrade</> run.
+ </para>
+
<sect2 id="creating-cluster-mount-points">
<title>Use of Secondary File Systems</title>