[mirrorbrain-commits] r7760 - trunk/docs

Author: poeml
Date: Wed Aug 12 20:21:50 2009
New Revision: 7760
URL: http://svn.mirrorbrain.org/viewvc/mirrorbrain?view=revision&revision=7760

Log:
docs: add notes for further upgrade instructions (details about
upgrading PostgreSQL). Commented and to be worked on.

Modified:
   trunk/docs/upgrading.rst

Modified: trunk/docs/upgrading.rst
==============================================================================
--- trunk/docs/upgrading.rst	Wed Aug 12 20:15:38 2009	(r7759)
+++ trunk/docs/upgrading.rst	Wed Aug 12 20:21:50 2009	(r7760)
@@ -37,3 +37,123 @@
 .. note:: 
    When upgrading to 8.4, ``ident sameuser`` is no longer a valid value in
    :file:`pg_hba.conf`. Replace it with ``ident``.
+
+
+
+.. 
+   Notes for upgrade walkthrough
+   
+   root_at_doozer ~ # rccron stop
+   Shutting down CRON daemon                                             done
+   root_at_doozer ~ # su - postgres
+   postgres_at_doozer:~> pg_dumpall > SAVE
+   postgres_at_doozer:~> 
+   
+   
+   root_at_doozer ~ # rcpostgresql stop
+   Shutting down PostgreSQLserver stopped                                done
+   
+   
+     >>>> Run the update here <<<<
+   
+   
+   root_at_doozer ~ # old /var/lib/pgsql/data 
+   moving /var/lib/pgsql/data to /var/lib/pgsql/data-20090728
+   root_at_doozer ~ # rcpostgresql start
+   Initializing the PostgreSQL database at location /var/lib/pgsql/data  done
+   Starting PostgreSQL                                                   done
+   root_at_doozer ~ # 
+   
+   
+   postgres_at_doozer:~> psql template1 -f SAVE
+   [...]
+   
+   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
+   
+   
+   
+   
+   
+   root_at_doozer ~ # rcapache2 reload
+   Reload httpd2 (graceful restart)                                      done
+   root_at_doozer ~ # rccron start
+   Starting CRON daemon                                                  done
+   
+   
+   
+   
+   
+   mirrordb:
+   cron stop on batavia510
+   cron stop on mirrordb
+   repopusher stop
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   
+   using a temporary PostgreSQL daemon:
+   
+ ..
+    # mkdir /space/pgsql-tmp
+    # chown postgres:postgres /space/pgsql-tmp
+    # su - postgres   
+ ..
+   postgres_at_mirrordb:~> 
+   
+   
+   postgres_at_mirrordb:~> initdb /space/pgsql-tmp/data
+   The files belonging to this database system will be owned by user "postgres".
+   This user must also own the server process.
+   
+   The database cluster will be initialized with locale en_US.UTF-8.
+   The default database encoding has accordingly been set to UTF8.
+   The default text search configuration will be set to "english".
+   
+   creating directory /space/pgsql-tmp/data ... ok
+   creating subdirectories ... ok
+   selecting default max_connections ... 100
+   selecting default shared_buffers/max_fsm_pages ... 32MB/204800
+   creating configuration files ... ok
+   creating template1 database in /space/pgsql-tmp/data/base/1 ... ok
+   initializing pg_authid ... ok
+   initializing dependencies ... ok
+   creating system views ... ok
+   loading system objects' descriptions ... ok
+   creating conversions ... ok
+   creating dictionaries ... ok
+   setting privileges on built-in objects ... ok
+   creating information schema ... ok
+   vacuuming database template1 ... ok
+   copying template1 to template0 ... ok
+   copying template1 to postgres ... ok
+   
+   WARNING: enabling "trust" authentication for local connections
+   You can change this by editing pg_hba.conf or using the -A option the
+   next time you run initdb.
+   
+   Success. You can now start the database server using:
+   
+       postgres -D /space/pgsql-tmp/data
+   or
+       pg_ctl -D /space/pgsql-tmp/data -l logfile start
+   
+   postgres_at_mirrordb:~> 
+


_______________________________________________
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