Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 58AEE2E012B
	for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed, 13 Feb 2008 19:18:30 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 32444-03 for <pgsql-docs-postgresql.org@postgresql.org>;
	Wed, 13 Feb 2008 19:18:21 -0400 (AST)
Received: from momjian.us (momjian.us [70.90.9.53])
	by postgresql.org (Postfix) with ESMTP id DB78B2E0129
	for <pgsql-docs@postgresql.org>; Wed, 13 Feb 2008 19:18:26 -0400 (AST)
Received: (from bruce@localhost) by momjian.us (8.11.6/8.11.6) id m1DMivY05840
	for pgsql-docs@postgresql.org; Wed, 13 Feb 2008 17:44:57 -0500 (EST)
From: Bruce Momjian <bruce@momjian.us>
Message-Id: <200802132244.m1DMivY05840@momjian.us>
Subject: Migration section added
To: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Date: Wed, 13 Feb 2008 17:44:57 -0500 (EST)
X-Mailer: ELM [version 2.4ME+ PL124 (25)]
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="ELM1202942697-21754-0_"
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/16
X-Sequence-Number: 4810


--ELM1202942697-21754-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset="US-ASCII"

I have added the attached text to the migration section.  It outlines
some of the areas that typically change between major releases.  I am
hopeful it will help people in testing migrations.

-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://postgres.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

--ELM1202942697-21754-0_
Content-Transfer-Encoding: 7bit
Content-Type: text/x-diff
Content-Disposition: inline; filename="/rtmp/diff"

Index: doc/src/sgml/backup.sgml
===================================================================
RCS file: /cvsroot/pgsql/doc/src/sgml/backup.sgml,v
retrieving revision 2.113
diff -c -c -r2.113 backup.sgml
*** doc/src/sgml/backup.sgml	23 Jan 2008 20:21:37 -0000	2.113
--- doc/src/sgml/backup.sgml	13 Feb 2008 22:42:41 -0000
***************
*** 1910,1922 ****
    </para>
  
    <para>
-    In practice you probably want to test your client
-    applications on the new setup before switching over completely.
-    This is another reason for setting up concurrent installations
-    of old and new versions.
-   </para>
- 
-   <para>
     If you cannot or do not want to run two servers in parallel, you can
     do the backup step before installing the new version, bring down
     the server, move the old version out of the way, install the new
--- 1910,1915 ----
***************
*** 1955,1959 ****
--- 1948,2015 ----
      moving an installation like this will not work.)
     </para>
    </note>
+ 
+   <para>
+    In practice you probably want to test your client applications on the
+    new version before switching over completely.  This is another reason
+    for setting up concurrent installations of old and new versions.  When
+    testing a <productname>PostgreSQL</> major upgrade, consider the
+    following categories of possible changes:
+   </para>
+ 
+   <variablelist>
+ 
+    <varlistentry>
+     <term>Administration</term>
+     <listitem>
+      <para>
+       The capabilities available for administrators to monitor and control
+       the server often change and improve in each major release.
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+    <varlistentry>
+     <term>SQL</term>
+     <listitem>
+      <para>
+       Typically this includes new SQL command capabilities and not changes
+       in behavior, unless specifically mentioned in the release notes.
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+    <varlistentry>
+     <term>Library API</term>
+     <listitem>
+      <para>
+       Typically libraries like <application>libpq</> only add new
+       functionality, again unless mentioned in the release notes.
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+    <varlistentry>
+     <term>System Catalogs</term>
+     <listitem>
+      <para>
+       System catalog changes usually only affect database management tools.
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+    <varlistentry>
+     <term>Server C-language API</term>
+     <listitem>
+      <para>
+       This involved changes in the backend function API, which is written
+       in the C programming language.  Such changes effect code that
+       references backend functions deep inside the server.
+      </para>
+     </listitem>
+    </varlistentry>
+ 
+   </variablelist>
+ 
   </sect1>
  </chapter>

--ELM1202942697-21754-0_--