public inbox for [email protected]  
help / color / mirror / Atom feed
From: Bruce Momjian <[email protected]>
To: Alvaro Herrera <[email protected]>
Cc: PostgreSQL-documentation <[email protected]>
Subject: Re: Pg_upgrade and collation
Date: Tue, 28 Jun 2016 17:21:51 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>
	<[email protected]>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>

On Mon, Jun 20, 2016 at 11:16:36AM -0400, Bruce Momjian wrote:
> In looking at the docs, it seems it would go in the Backup section
> somewhere:
> 
> 	https://www.postgresql.org/docs/9.6/static/backup.html
> 
> Seems it would apply to both of these backup sections:
> 
> 	24.2. File System Level Backup
> 	24.3. Continuous Archiving and Point-in-Time Recovery (PITR)
> 
> and also here:
> 
> 	25.2. Log-Shipping Standby Servers
> 
> It seems odd to put it in all of these places, but where can we
> centrally put it?

In looking at the docs, I found that the section "Creating a Database
Cluster", which covers initdb and collations, as the best place to put
this warning.  Patch attached.

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+                     Ancient Roman grave inscription +


-- 
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs


Attachments:

  [text/x-diff] collation.diff (875B, 2-collation.diff)
  download | inline diff:
diff --git a/doc/src/sgml/runtime.sgml b/doc/src/sgml/runtime.sgml
new file mode 100644
index 4a0e35a..6d39ce7
*** a/doc/src/sgml/runtime.sgml
--- b/doc/src/sgml/runtime.sgml
*************** postgres$ <userinput>initdb -D /usr/loca
*** 183,188 ****
--- 183,197 ----
     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>
  


view thread (15+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Pg_upgrade and collation
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox