...
| Note |
|---|
The primary cluster will be restarted even if the archive mode is already enabled to update other parameters. |
...
Summary of the end of the DR Cluster creation from the primary. The automatic standby update and the observer components are automatically enabled.
( 1 ) The configuration name along with the time gap between standby cluster and primary cluster.
( 2 ) The status of the primary cluster
( 3 ) The method used to create the standby cluster
( 4 ) The status of the standby cluster
...
Below are the parameters that are modified on the postgresql.conf file
Primary Server:
| Code Block |
|---|
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
# Add settings for extensions here
# Added by Dbvisit StandbyMP
archive_command = '"/usr/dbvisit/standbymp/bin/dbvpgarchive" "-configurationId" "1" "-targetAddr" "centlin72.oraclekiwi.co.nz" "-targetPort" "7890" "-sourceFile" "/u01/PG5432-12/%p" "-targetFile" "/u01/backup/PG5432-12/1/%f" "-localAddr" "" "-localPort" "7890" "-backupFile" "/u01/backup/PG5432-12/1/%f"'
# Added by Dbvisit StandbyMP
archive_mode = 'on'
# Added by Dbvisit StandbyMP
archive_timeout = 60
# Added by Dbvisit StandbyMP
hot_standby = 'off'
# Added by Dbvisit StandbyMP
archive_cleanup_command = '"/usr/pgsql-12/bin/pg_archivecleanup" "/u01/backup/PG5432-12/1" "%r"'
# Added by Dbvisit StandbyMP
data_directory = '/u01/PG5432-12'
# Added by Dbvisit StandbyMP
port = 5432
# Added by Dbvisit StandbyMP
restore_command = '"/usr/dbvisit/standbymp/bin/dbvpgrestore" "-configurationId" "1" "-sourceFile" "/u01/backup/PG5432-12/1/%f" "-targetFile" "%p" "-localAddr" "" "-localPort" "7890"'
|
Standby Server:
| Code Block |
|---|
#------------------------------------------------------------------------------
# CUSTOMIZED OPTIONS
#------------------------------------------------------------------------------
# Add settings for extensions here
# Added by Dbvisit StandbyMP
archive_command = '"/usr/dbvisit/standbymp/bin/dbvpgarchive" "-configurationId" "3" "-targetAddr" "centlin72.oraclekiwi.co.nz" "-targetPort" "7890" "-sourceFile" "/u01/PG5432-12/%p" "-targetFile" "/u01/backup/PG5432-12/3/%f" "-localAddr" "" "-localPort" "7890" "-backupFile" "/u01/backup/PG5432-12/3/%f"'
# Added by Dbvisit StandbyMP
archive_mode = 'off'
# Added by Dbvisit StandbyMP
archive_timeout = 60
# Added by Dbvisit StandbyMP
hot_standby = 'on'
# Added by Dbvisit StandbyMP
archive_cleanup_command = '"/usr/pgsql-12/bin/pg_archivecleanup" "/u01/backup/PG5432-12/3" "%r"'
# Added by Dbvisit StandbyMP
data_directory = '/u01/PG5432-12'
# Added by Dbvisit StandbyMP
port = 5432
# Added by Dbvisit StandbyMP
restore_command = '"/usr/dbvisit/standbymp/bin/dbvpgrestore" "-configurationId" "3" "-sourceFile" "/u01/backup/PG5432-12/3/%f" "-targetFile" "%p" "-localAddr" "" "-localPort" "7890"' |