Table of Contents Previous Next



In the table name hr_rmt_tn_hhmi, n represents the active timeline. hhmi is the approximate time the table was created. For example, hr_rmt_t1_1356 was created at approximately 1:56 PM while timeline #1 is active.
Note that in the BART configuration file, the remote user and remote host IP address, postgres@192.168.2.24, have been set with the remote_host parameter. If not given in the BART configuration file, this information must then be specified by the --remote-host option when giving the RESTORE subcommand (for example, bart RESTORE --remote-host postgres@192.168.2.24 …).
Use the SHOW-BACKUPS subcommand to identify the backup to use with the RESTORE subcommand.
The -t option with the SHOW-BACKUPS subcommand displays additional backup information:
Copy the saved, unarchived WAL files to the restore path pg_xlog subdirectory (/opt/restore_pg95/pg_xlog):
Inspect the /opt/restore_pg95/recovery.conf file to verify that it contains the correct recovery settings:
Note that it restores from the archived_wals subdirectory of /opt/restore_pg95 since the copy_wals_during_restore parameter in the BART configuration file is set to enabled for database server hr.
Note: The BART RESTORE operation stops WAL archiving by adding an archive_mode = off parameter at the very end of the postgresql.conf file. This last parameter in the file overrides any other previous setting of the same parameter in the file. Delete the last setting and restart the database server to start WAL archiving.


Table of Contents Previous Next