|BART Host. If an incremental backup is to be restored onto the same host where BART has been installed, the restore process is outlined in Section 184.108.40.206.
If an incremental backup is to be restored onto a remote host where BART has not been installed, the restore process still follows the information outlined in Section 220.127.116.11
, but in addition the requirements in Section 18.104.22.168
must be established.
program must be available on the remote host because the RESTORE
subcommand invocation for an incremental backup results in the execution of the bart
program on the remote host to restore the modified blocks to their proper location within the restore directory on the remote host.
subcommand is used to restore an incremental backup by specifying its backup identifier or name with the -i option. All RESTORE
options are used in the same manner as when restoring a full backup.
See Section 5.4.8
for information on using the RESTORE
subcommand for restoring an incremental backup. Also note the usage of the -w
option of the RESTORE
subcommand to specify a multiple number of parallel worker processes to stream the modified blocks to the restore host.
Install BART on the remote host to which an incremental backup is to be restored. Use the instructions in Section 3.2
to install BART on this remote host.
No editing is needed in the BART configuration file bart.cfg
installed on the remote host.
Determine the Linux operating system user account on the remote host to be used as the remote user specified by the remote_host
parameter in the BART configuration file or by the -r
option when using the RESTORE
subcommand to restore the incremental backup. This remote user must also be the owner of the directory where the incremental backup is to be restored on the remote host. For example, the user account is typically enterprisedb
for Advanced Server or postgres
Make sure a password-less SSH/SCP connection has been established from the BART user on the BART host to the remote user on the remote host. See Section 4.2.1
for information on setting up a password-less SSH/SCP connection.
When the remote user connects to the remote host, the remote user’s PATH
environment variable must include the BART bin
directory. For example, modify the user’s ~/.bashrc
file to set the PATH
environment variable such as in the following example: