[mirrorbrain-commits] [mod_asn] r52 - trunk/docs

Author: poeml
Date: Wed Jul 15 22:10:20 2009
New Revision: 52
URL: http://svn.mirrorbrain.org/viewvc/mod_asn?view=revision&revision=52

Log:
add upgrade notes about PostgreSQL (8.4)

Added:
   trunk/docs/upgrading.rst
Modified:
   trunk/docs/index.rst

Modified: trunk/docs/index.rst
==============================================================================
--- trunk/docs/index.rst	Tue Jul 14 19:40:37 2009	(r51)
+++ trunk/docs/index.rst	Wed Jul 15 22:10:20 2009	(r52)
@@ -20,6 +20,7 @@
    intro
    license
    installation
+   upgrading
    glossary
    changes
 

Added: trunk/docs/upgrading.rst
==============================================================================
--- /dev/null	00:00:00 1970	(empty, because file is newly added)
+++ trunk/docs/upgrading.rst	Wed Jul 15 22:10:20 2009	(r52)
@@ -0,0 +1,34 @@
+Upgrading
+=========
+
+Upgrading PostgreSQL (and the ip4r data type)
+---------------------------------------------
+
+When upgrading PostgreSQL, it is important to look at the version number difference. 
+If the third digit changes, no special procedure is needed (except when the
+release notes explicitely hint about it).
+
+When the first or second digit change, then a dump-and-reload cycle is usually
+needed. 
+
+For instance, when upgrading from 8.3.5 to 8.3.7 nothing needs to be done. When
+upgrading from 8.3.7 to 8.4, you need to dump and reload.
+
+You might want to follow the instructions that your vendor provides. If your
+vendor doesn't provide an upgrade procedure, be warned that the database needs
+to be dumped before upgrading PostgreSQL.
+
+.. warning:: 
+   If your vendor's upgrade procedure automatically saves the previous
+   PostgreSQL binaries in case they are needed later, the procedure might not 
+   take into account that the :file:`ip4r.so` shared object might need to be saved as well.
+   Hence, you might be unable to start the old binaries, when the ip4r shared
+   object has been upgraded already.
+
+Hence, it is recommended that you do a complete dump of the databases before
+upgrading, and load that after upgrading.
+
+
+.. note:: 
+   When upgrading to 8.4, ``ident sameuser`` is no longer a valid value in
+   :file:`pg_hba.conf`. Replace it with ``ident``.


_______________________________________________
mirrorbrain-commits mailing list
Archive: http://mirrorbrain.org/archive/mirrorbrain-commits/

Note: To remove yourself from this list, send a mail with the content
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org