ServerView Resource Orchestrator Cloud Edition V3.1.0 Operation Guide

10.1.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 admin 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 stop the manager, refer to "2.1 Starting and Stopping the Manager".

Changing the Backup Destination Directory

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

[Windows Manager]

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 Manager]

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 Manager]

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

   [Linux Manager]

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

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

   [Windows Manager]

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

   [Linux Manager]

   # 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 Manager]

   >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 Manager]

   # 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 Manager]

   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 Manager]

   /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 Manager]

   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 Manager]

   /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.

For details on how to start the manager, refer to "2.1 Starting and Stopping the Manager".