Index: openacs-4/packages/acs-core-docs/www/snapshot-backup.adp =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/snapshot-backup.adp,v diff -u -r1.4.2.6 -r1.4.2.7 --- openacs-4/packages/acs-core-docs/www/snapshot-backup.adp 13 Jul 2023 12:43:22 -0000 1.4.2.6 +++ openacs-4/packages/acs-core-docs/www/snapshot-backup.adp 2 Sep 2024 09:40:23 -0000 1.4.2.7 @@ -2,10 +2,14 @@ {/doc/acs-core-docs/ {ACS Core Documentation}} {Manual backup and recovery} Manual backup and recovery +

@@ -17,8 +21,7 @@ the information needed to rebuild the site, including the AOLserver config files, is then in tree for regular filesystem backup.

  1. -

    Back up the database to a -file. 

      +

      Back up the database to a file. 

      • Oracle.  @@ -27,15 +30,13 @@ /var/tmp/export-oracle.txt

      • Login as root. The following commands will install the export -script:

        -[joeuser ~]$ su -
+script:
        [joeuser ~]$ su -
 [root ~]# cp /var/tmp/export-oracle.txt /usr/sbin/export-oracle
 [root ~]# chmod 700 /usr/sbin/export-oracle

      • Setup the export directory; this is the directory where backups -will be stored. We recommend the directory /ora8/m02/oracle-exports.

        -[root ~]# mkdir /ora8/m02/oracle-exports
+will be stored. We recommend the directory /ora8/m02/oracle-exports.
        [root ~]# mkdir /ora8/m02/oracle-exports
 [root ~]# chown oracle:dba /ora8/m02/oracle-exports
 [root ~]# chmod 770 /ora8/m02/oracle-exports
 
        
@@ -46,8 +47,7 @@
 their correct values. If you want to use a directory other than
 /ora8/m02/oracle-exports, you also
 need to change the exportdir
-setting.
        Test the export procedure by running the command:
        -[root ~]# /usr/sbin/export-oracle
+setting.
        Test the export procedure by running the command:
        [root ~]# /usr/sbin/export-oracle
 mv: /ora8/m02/oracle-exports/oraexport-service_name.dmp.gz: No such file or directory
 
 Export: Release 8.1.6.1.0 - Production on Sun Jun 11 18:07:45 2000
@@ -82,16 +82,14 @@
   . exporting dimensions
   . exporting post-schema procedural objects and actions
   . exporting statistics
-Export terminated successfully without warnings.
-
        
+Export terminated successfully without warnings.

    • PostgreSQL. Create a backup file and verify that it was created and has a reasonable -size (several megabytes).

      -[root root]# su - $OPENACS_SERVICE_NAME
+size (several megabytes).
      [root root]# su - $OPENACS_SERVICE_NAME
 [$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ pg_dump -f /var/lib/aolserver/$OPENACS_SERVICE_NAME/database-backup/before_upgrade_to_4.6.dmp $OPENACS_SERVICE_NAME
 
 [$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ ls -al /var/lib/aolserver/$OPENACS_SERVICE_NAME/database-backup/before_upgrade_to_4.6.dmp 
@@ -107,8 +105,8 @@

  2. -Back up the filesystem. Back up all -of the files in the service, including the database backup file but +Back up the filesystem. Back up all of the +files in the service, including the database backup file but excluding the auto-generated supervise directory, which is unnecessary and has complicated permissions.

    In the tar command,

    • @@ -126,19 +124,16 @@ correct extensions.

    • The last clause, /var/lib/aolserver/$OPENACS_SERVICE_NAME/, specifies the starting point for backup. Tar defaults to recursive backup.

      • -
    -[root root]# su - $OPENACS_SERVICE_NAME
+
[root root]# su - $OPENACS_SERVICE_NAME
 
 [$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ tar -cpsz --exclude /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/daemontools/supervise \
    --file /var/tmp/$OPENACS_SERVICE_NAME-backup.tar.gz /var/lib/aolserver/$OPENACS_SERVICE_NAME/
 tar: Removing leading `/' from member names
-[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$
-
+[$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$

  • Suffer a catastrophic failure on your production -system. (We'll simulate this step)

    -[root root]# svc -d /service/$OPENACS_SERVICE_NAME
+system. (We'll simulate this step)
    [root root]# svc -d /service/$OPENACS_SERVICE_NAME
 [root root]# mv /var/lib/aolserver/$OPENACS_SERVICE_NAME/ /var/lib/aolserver/$OPENACS_SERVICE_NAME.lost
 [root root]# rm /service/$OPENACS_SERVICE_NAME
 rm: remove symbolic link `/service/$OPENACS_SERVICE_NAME'? y
@@ -154,8 +149,7 @@
 DROP USER
 [postgres pgsql]$ exit
 logout
-[root root]#
-
    
+[root root]#

  • Recovery.  @@ -165,8 +159,7 @@ install material (OS CDs, OpenACS tarball and supporting software) and repeating the install guide. Recreate the service user ($OPENACS_SERVICE_NAME).

  • -

    Restore the OpenACS files and database backup file.

    -[root root]# su - $OPENACS_SERVICE_NAME
+
    Restore the OpenACS files and database backup file.
    [root root]# su - $OPENACS_SERVICE_NAME
 
 [$OPENACS_SERVICE_NAME $OPENACS_SERVICE_NAME]$ cd /var/lib/aolserver
 [$OPENACS_SERVICE_NAME aolserver]$ tar xzf /var/tmp/$OPENACS_SERVICE_NAME-backup.tar.gz
@@ -186,9 +179,8 @@

  • -Postgres. If -the database user does not already exist, create it.

    -[root root]# su - postgres
+Postgres. If the
+database user does not already exist, create it.
    [root root]# su - postgres
 [postgres ~]$ createuser $OPENACS_SERVICE_NAME
 
 Shall the new user be allowed to create databases? (y/n) y
@@ -201,8 +193,7 @@
 create any out-of-order database objects. Next, restore the
 database from the dump file. The restoration will show some error
 messages at the beginning for objects that were precreated from the
-OpenACS initialization script, which can be ignored.
    -[root root]# su - $OPENACS_SERVICE_NAME
+OpenACS initialization script, which can be ignored.
    [root root]# su - $OPENACS_SERVICE_NAME
 
 [$OPENACS_SERVICE_NAME ~]$ createdb $OPENACS_SERVICE_NAME
 
@@ -213,13 +204,11 @@
 (many lines omitted)
 [$OPENACS_SERVICE_NAME ~]$ exit
 [postgres ~]$ exit
-logout
-
    
+logout
  • -

    Activate the service

    -[root root]# ln -s /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/daemontools /service/$OPENACS_SERVICE_NAME
+
    Activate the service
    [root root]# ln -s /var/lib/aolserver/$OPENACS_SERVICE_NAME/etc/daemontools /service/$OPENACS_SERVICE_NAME
 
 [root root]# sleep 10
 [root root]# svgroup web /service/$OPENACS_SERVICE_NAME