From 7ff79fa42578ba711c73bfd6bf712f828bf479e1 Mon Sep 17 00:00:00 2001
From: Bruce Momjian <bruce@momjian.us>
Date: Tue, 25 May 2010 14:50:56 +0000
Subject: [PATCH] Add pg_upgrade docs about binary compatibility, per Robert
 Haas.

---
 doc/src/sgml/pgupgrade.sgml | 17 +++++++++++++----
 1 file changed, 13 insertions(+), 4 deletions(-)

diff --git a/doc/src/sgml/pgupgrade.sgml b/doc/src/sgml/pgupgrade.sgml
index 0b9b5c3cc9..e5c054c137 100644
--- a/doc/src/sgml/pgupgrade.sgml
+++ b/doc/src/sgml/pgupgrade.sgml
@@ -1,4 +1,4 @@
-<!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.10 2010/05/24 17:43:39 momjian Exp $ -->
+<!-- $PostgreSQL: pgsql/doc/src/sgml/pgupgrade.sgml,v 1.11 2010/05/25 14:50:56 momjian Exp $ -->
 
 <sect1 id="pgupgrade">
  <title>pg_upgrade</title>
@@ -16,6 +16,16 @@
   9.0.1 -> 9.0.4.
  </para>
 
+ <para>
+  <application>pg_upgrade</> works because, though new features are
+  regularly added to Postgres major releases, the internal data storage
+  format rarely changes.  <application>pg_upgrade</> does its best to
+  make sure the old and new clusters are binary-compatible, e.g.  by
+  checking for compatible compile-time settings.  It is important that
+  any external modules are also binary compatibile, though this cannot
+  be checked by <application>pg_upgrade</>.
+ </para>
+
  <sect2>
   <title>Supported Versions</title>
 
@@ -440,7 +450,6 @@ psql --username postgres --file script.sql postgres
   <sect2>
   <title>Limitations in migrating <emphasis>from</> PostgreSQL 8.3</title>
  
- 
   <para>
    Upgrading from PostgreSQL 8.3 has additional restrictions not present
    when upgrading from later PostgreSQL releases.  For example,
@@ -502,8 +511,8 @@ psql --username postgres --file script.sql postgres
    For Windows users, note that due to different integer datetimes settings
    used by the one-click installer and the MSI installer, it is only
    possible to upgrade from version 8.3 of the one-click distribution to
-   version 8.4 of the one-click distribution. It is not possible to upgrade
-   from the MSI installer to the one-click installer.
+   version 8.4 or later of the one-click distribution. It is not
+   possible to upgrade from the MSI installer to the one-click installer.
   </para>
  
   <para>  
-- 
2.40.0