...
Few points to remember when creating a HOT DR cluster using the WAL Archive method.
...
( 2 ) The standby is run as a HOT standby, so the databases of the cluster are accessible to the user as a read-only databases.
( 3 ) The method used for creating the DR cluster is “WAL file Archiving”.
...
| 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.
...
| 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"' |
WAL File Shipping (Hot Standby)
This method of creating the standby is specific to Dbvisit. The wal files from primary are copied to standby at regular intervals and applied on standby.
( 1 ) The data file locations on the standby server. This could be a different location than that of the primary server
( 2 ) The option to create a Hot standby. This will enable the customers to use the standby cluster for reporting purposes , since the cluster databases will be opened in read only.
( 3 ) The method used to create the standby (WAL File Shipping)
( 4 ) The base backup location for both primary and standby. This location is used for taking backup of the primary cluster and then copy to the location provided on the standby cluster.
( 5 ) The custom backup location for copying the wal files on the priamry and then copy to the location provided onthe standby server.
...