beautypg.com

Point – FUJITSU ServerView Resource Orchestrator Cloud Edition J2X1-7611-03ENZ0 User Manual

Page 106

background image

1.

Create a new backup directory.

[Windows Manager]

> D:

> cd \

> mkdir basebackup\Charging

> E:

> cd \

> mkdir walbackup\Charging

[Linux Manager]

# mkdir /basebackup

# mkdir /walbackup

2.

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

[Windows Manager]

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

>cacls E:\walbackup\Charging /T /E /G rcxctdbchg:F

[Linux Manager]

# chown -R rcxctdbdhg:rcxctdbchg /basebackup

# chown -R rcxctdbdhg:rcxctdbchg /walbackup

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

>xcopy c:\Fujitsu\ROR\RCXCTMG\backup\wal\* E:\walbackup\ /E /H /K /X

[Linux Manager]

# cp -pR /var/opt/FJSVctchg/backup/data/* /basebackup/.

# cp -pR /var/opt/FJSVctchg/backup/wal/* /walbackup/.

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]

- 92 -