Index: openacs-4/packages/acs-core-docs/www/snapshot-backup.html =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-core-docs/www/snapshot-backup.html,v diff -u -r1.15.2.1 -r1.15.2.2 --- openacs-4/packages/acs-core-docs/www/snapshot-backup.html 2 Mar 2019 19:30:06 -0000 1.15.2.1 +++ openacs-4/packages/acs-core-docs/www/snapshot-backup.html 3 Sep 2021 09:15:28 -0000 1.15.2.2 @@ -6,7 +6,7 @@ database to a file within the file tree. Then, you back up the file tree. All of the information needed to rebuild the site, including the AOLserver config files, is then in tree for regular - file system backup.
Back up the database to a file.
+ filesystem backup.
Back up the database to a file.
Download the backup script. Save the file export-oracle.txt as
/var/tmp/export-oracle.txt
@@ -73,7 +73,7 @@ su - $OPENACS_SERVICE_NAME pg_dump -f /var/lib/aolserver/$OPENACS_SERVICE_NAME/database-backup/before_upgrade_to_4.6.dmp openacs-dev ls -al /var/lib/aolserver/$OPENACS_SERVICE_NAME/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 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,
c
create a
@@ -119,7 +119,7 @@
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER
[postgres ~]$ exit
-
Because of a bug in Postgres backup-recovery, database objects are not guaranteed to be created in the right order. In practice, running the OpenACS initialization script is always sufficient to 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 pre-created from the OpenACS initialization script, which can be ignored.
[root root]# su - $OPENACS_SERVICE_NAME
+
Because of a bug in Postgres backup-recovery, database objects are not guaranteed to be created in the right order. In practice, running the OpenACS initialization script is always sufficient to 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_SERVICE_NAME ~]$createdb $OPENACS_SERVICE_NAME
CREATE DATABASE [$OPENACS_SERVICE_NAME ~]$psql -f /var/lib/aolserver/$OPENACS_SERVICE_NAME/packages/acs-kernel/sql/postgresql/postgresql.sql $OPENACS_SERVICE_NAME