Index: openacs-4/packages/acs-core-docs/www/backup-recovery.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/backup-recovery.html,v diff -u -r1.17 -r1.18 --- openacs-4/packages/acs-core-docs/www/backup-recovery.html 11 Dec 2003 23:08:45 -0000 1.17 +++ openacs-4/packages/acs-core-docs/www/backup-recovery.html 23 Jan 2004 15:09:52 -0000 1.18 @@ -1,8 +1,8 @@ -
By Don Baccus with additions - by Joel Aufrecht
+By Don Baccus with additions + by Joel Aufrecht
The purpose of backup is to enable recovery. Backup and
recovery are always risky; here are some steps that minimize the
chance recovery is necessary:
@@ -112,10 +112,10 @@
-rw-rw-r-x 1 service0 service0 4005995 Feb 21 18:28 /var/lib/aolserver/service0/database-backup/before_upgrade_to_4.6.dmp
[service0@localhost service0]$ exit
[root@localhost root]#
- su - service0
+ su - service0
pg_dump -f /var/lib/aolserver/service0/database-backup/before_upgrade_to_4.6.dmp openacs-dev
ls -al /var/lib/aolserver/service0/database-backup/before_upgrade_to_4.6.dmp
- exit
Back up the file system.�Back up all of the files in the service, including the + exit
Back up the file system.�Back up all of the files in the service, including the database backup file but excluding the auto-generated supervise directory, which is unneccesary and has complicated permissions.
In the tar command,
c create a @@ -156,7 +156,7 @@ [service0@yourserver aolserver]$ chown -R service0.web service0
Restore the database
Oracle.�
Set up a clean Oracle database user and - tablespace with the same names as the ones exported from (more information).
Invoke the import command
imp service0/service0 FILE=/var/lib/aolserver/service0/database-backup/nighty_backup.dmp FULL=Y
Postgres.�
Because of a bug in Postgres backup-recovery, database objects are not guaranteed to be created in the right order. To compensate, we pre-creating some critical items first, which leads to some harmless errors.
[root@yourserver root]# su - postgres + tablespace with the same names as the ones exported from (more information).
Invoke the import command
imp service0/service0 FILE=/var/lib/aolserver/service0/database-backup/nighty_backup.dmp FULL=Y
Postgres.�
Because of a bug in Postgres backup-recovery, database objects are not guaranteed to be created in the right order. To compensate, we pre-creating some critical items first, which leads to some harmless errors.
[root@yourserver root]# su - postgres
[postgres@yourserver pgsql]$ createuser service0
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
@@ -194,14 +194,14 @@
(many lines omitted)
[service0@localhost service0]$ exit
[root@localhost root]#
- su - service0
+ su - service0
cd /var/lib/aolserver/service0
cvs commit -m "last-minute commits before upgrade to 4.6"
cvs tag before_upgrade_to_4_6
- exit
To restore files from a cvs tag such as the one used above:
[root@localhost root]# su - service0 + exit
To restore files from a cvs tag such as the one used above:
[root@localhost root]# su - service0
[service0@localhost service0]$ cd /var/lib/aolserver/service0
[service0@localhost service0]$ cvs up -r current
[service0@localhost service0]$ exit
- su - service0
+ su - service0
cd /var/lib/aolserver/service0
- cvs up -r current