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

From: <poeml_at_mirrorbrain.org>
Date: Wed, 15 Jul 2009 22:10:21 +0200
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

add upgrade notes about PostgreSQL (8.4)


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)
_at_@ -20,6 +20,7 @@
+   upgrading

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)
_at_@ -0,0 +1,34 @@
+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
+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
to the address mirrorbrain-commits-request_at_mirrorbrain.org
Received on Wed Jul 15 2009 - 20:10:22 GMT

This archive was generated by hypermail 2.3.0 : Mon Feb 20 2012 - 23:47:04 GMT