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

Author: poeml
Date: Thu Aug 20 12:24:42 2009
New Revision: 7766

URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?rev=7766&view=rev
Log:
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

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
 	unsubscribe
to the address mirrorbrain-commits-request_at_mirrorbrain.org