[mirrorbrain-commits] r7766 - /trunk/docs/upgrading.rst

From: <poeml_at_mirrorbrain.org>
Date: Thu, 20 Aug 2009 10:24:44 -0000
Author: poeml
Date: Thu Aug 20 12:24:42 2009
New Revision: 7766

URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?rev=7766&view=rev
docs: when upgrading PostgreSQL, change the order of the taken steps so that
postgresql.conf is adjusted first, before the dump is loaded into the new
database. Might be faster.


Modified: trunk/docs/upgrading.rst
URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain/trunk/docs/upgrading.rst?rev=7766&r1=7765&r2=7766&view=diff
--- trunk/docs/upgrading.rst (original)
+++ trunk/docs/upgrading.rst Thu Aug 20 12:24:42 2009
_at_@ -66,8 +66,7 @@
 At this point, you would upgrade the PostgreSQL software.
-Next, the :file:`data` directory is moved away, a new one created, and the dump
-loaded into it::
+Next, the :file:`data` directory is moved away, a new one created::
    root_at_doozer ~ # old /var/lib/pgsql/data 
    moving /var/lib/pgsql/data to /var/lib/pgsql/data-20090728
_at_@ -76,18 +75,19 @@
    Starting PostgreSQL                                                   done
    root_at_doozer ~ # 
-   root_at_doozer ~ # su - postgres
-   postgres_at_doozer:~> psql template1 -f SAVE
-   [...]
 Now, the authentication setup and the configuration need to be migrated from
 the old install to the new one::
+   root_at_doozer ~ # su - postgres
    postgres_at_doozer:~> cp data/pg_hba.conf data/pg_hba.conf.orig
    postgres_at_doozer:~> cp data/postgresql.conf data/postgresql.conf.orig
    postgres_at_doozer:~> vi -d data-20090728/pg_hba.conf data/pg_hba.conf 
    postgres_at_doozer:~> vi -d data-20090728/postgresql.conf data/postgresql.conf
+Then, load the dump into the new database::
+   postgres_at_doozer:~> psql template1 -f SAVE
+   [...]
 Finally, restart PostgreSQL, Apache and cron::   

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 Thu Aug 20 2009 - 10:24:47 GMT

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