ServerView Resource Orchestrator Cloud Edition V3.0.0 Operation Guide

8.5 Online Backup Settings for Metering

Backup resources that use the PostgreSQL point-in-time recovery (PITR) mechanism (metering resources), which are among the resources that are obtained in online backup of the Management Server, are stored in the directory that has been specified in the settings file, regardless of the storage destination specified by the command.

This section describes how to change the backup destination directory for the online backup of metering resources.
To change the backup destination directory, the files and items in the table shown below must be changed.

File to be Changed	File Name	Item to be Changed
Operational settings file for the database	postgresql.conf	WAL save directory
Operational settings file for online backup	ctmgbackup.properties	WAL save directory
		Backup directory

Stopping the Manager

Stop the manager.

For details on how to start the manager, refer to "7.2 Starting and Stopping the Manager" of the "Setup Guide CE".

Changing the backup destination directory [Windows]

This section describes how to change the backup destination directory, based on the example shown below.

[Windows]

Directory	Type	Directory Path
Backup directory	Before change	C:\Fujitsu\ROR\RCXCTMG\backup\data
	After change	D:\basebackup
WAL save directory	Before change	C:\Fujitsu\ROR\RCXCTMG\backup\wal
	After change	E:\walbackup

[Linux]

Directory	Type	Directory Path
Backup directory	Before change	/var/opt/FJSVctchg/backup/data
	After change	/basebackup
WAL save directory	Before change	/var/opt/FJSVctchg/backup/wal
	After change	/walbackup

1. Create a new backup directory.

   [Windows]

   > D: <RETURN>
   > cd \ <RETURN>
   > mkdir basebackup\Charging <RETURN>
   > E: <RETURN>
   > cd \ <RETURN>
   > mkdir walbackup\Charging <RETURN>

   [Linux]

   # mkdir /basebackup <RETURN>
   # mkdir /walbackup <RETURN>

2. Set access privileges for users connected with the database, for the directory.

   [Windows]

   >cacls D:\basebackup\Charging /T /E /G rcxctdbchg:F <RETURN>
   >cacls E:\walbackup\Charging /T /E /G rcxctdbchg:F <RETURN>

   [Linux]

   # chown -R rcxctdbdhg:rcxctdbchg /basebackup <RETURN>
   # chown -R rcxctdbdhg:rcxctdbchg /walbackup <RETURN>

3. Copy (move) files from the existing directory to the new directory.

   [Windows]

   >xcopy c:\Fujitsu\ROR\RCXCTMG\backup\data\* D:\basebackup\ /E /H /K /X <RETURN>
   >xcopy c:\Fujitsu\ROR\RCXCTMG\backup\wal\* E:\walbackup\ /E /H /K /X <RETURN>

   [Linux]

   # cp -pR /var/opt/FJSVctchg/backup/data/* /basebackup/. <RETURN>
   # cp -pR /var/opt/FJSVctchg/backup/wal/* /walbackup/. <RETURN>

4. Modify the operational settings file for the database.

   Change the settings for the following operational settings file for each database cluster:

   [Windows]

   Installation_folder\RCXCTMG\Charging\pgsql\data\postgresql.conf

   Change as follows:

   • Setting before change

     archive_command = 'copy "%p" "C:\\Fujitsu\\ROR\\RCXCTMG\\backup\\wal\\Charging\\%f"'    # command to use to archive a logfile segment

   • Setting after change

     archive_command = 'copy "%p" "E:\\walbackup\\Charging\\%f"'    # command to use to archive a logfile segment

     Point

     Use "\\" as a delimiter.

   [Linux]

   /var/opt/FJSVctchg/pgsql/data/postgresql.conf

   • Setting before change

     archive_command = 'cp "%p" "/var/opt/FJSVctchg/backup/wal/%f"' # command to use to archive a logfile segment

   • Setting after change

     archive_command = 'copy "%p" "E:\\walbackup\\Charging\\%f"'    # command to use to archive a logfile segment

     Point

     Use "/" as a delimiter.

5. Modify the operational settings file for the online backup.

   Open the following file:

   [Windows]

   Installation_folder\RCXCTMG\bin\conf\ctmgbackup.properties

   Change as follows:

   • Setting before change

     BASE_BACKUP_DIR=C:/Fujitsu/ROR/RCXCTMG/backup/data
     WAL_ARCHIVE_DIR=C:/Fujitsu/ROR/RCXCTMG//backup/wal

   • Setting after change

     BASE_BACKUP_DIR=D:/basebackup
     WAL_ARCHIVE_DIR=E:/walbackup

     Point

     Use "/" as a delimiter.

   [Linux]

   /opt/FJSVctmg/bin/conf/ctmgbackup.properties

   Change as follows:

   • Setting before change

     BASE_BACKUP_DIR=/var/opt/FJSVctchg/backup/data
     WAL_ARCHIVE_DIR=/var/opt/FJSVctchg/backup/wal

   • Setting after change

     BASE_BACKUP_DIR=/basebackup
     WAL_ARCHIVE_DIR=/walbackup

     Point

     Use "/" as a delimiter.

     
     

Start the manager

Start the manager.

Refer to "7.2 Starting and Stopping the Manager" in the "Setup Guide CE" for information on how to start the Manager.