This section explains the content of the file and parameters set on the standby server. After editing postgresql.conf file, start the instance.
The content for the parameters specified in postgresql.conf file is shown in the table below.
Table B.2 postgresql.conf fileParameter | Value set | Explanation |
|---|
synchronous_standby_names | 'primaryServerName' | Use single quotation marks (') to enclose the name that will identify the primary server. Any name can be specified. This name will be required to rebuild the original primary server as the new standby server after the primary server was switched. The value specified for this parameter must also be specified in the --standby-names parameter when the mc_ctl command is executed in setup mode. Do not change this parameter while Mirroring Controller is running. |
backup_destination | Backup data storage destination directory | Specify the name of the backup data storage directory. Set the permissions so that only the instance administrator user can access the specified directory. Specify the same full path on all servers so that the backup data of other servers can be used to perform recovery. |
archive_command | 'installDir/bin/pgx_xlogcopy.cmd "%p" "backupDataStorageDestinationDirectory/archived_xlog/%f"' | Specify the command and storage destination to save the transaction log. |
