Table of Contents Previous Next



In the table name pg94_rmt_tn_hhmi, n represents the active timeline. hhmi is the approximate time the table was created. For example, pg94_rmt_t1_1650 was created at approximately 4:50 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 base backup to use with the RESTORE subcommand.
The -t option with the SHOW-BACKUPS subcommand also displays the user-defined backup name if one was created:
Copy the saved, unarchived WAL files to the restore path pg_xlog subdirectory (/opt/restore_pg94/pg_xlog):
Inspect the /opt/restore_pg94/recovery.conf file to verify that it contains the correct recovery settings:
Note that it restores from the archived_wals subdirectory of /opt/restore_pg94 since the copy_wals_during_restore parameter in the BART configuration file is set to enabled for database server PG94_remote.
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