The following demonstrates the point-in-time recovery operation on the remote PostgreSQL database server.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.The following lists the current PostgreSQL server WAL files. The ones that have not been archived are indicated with bold font.-rw------- 1 postgres postgres 16777216 Mar 29 14:07 000000010000000000000004-rw------- 1 postgres postgres 16777216 Mar 29 13:50 000000010000000000000005On the remote host, the directory is created to which the PostgreSQL database cluster is to be restored. This restore path is /opt/restore_pg95 owned by user account postgres.Note that in the BART configuration file, the remote user and remote host IP address, firstname.lastname@example.org, 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 email@example.com …).Use the SHOW-BACKUPS subcommand to identify the backup to use with the RESTORE subcommand.SERVER NAME BACKUP ID BACKUP NAME BACKUP PARENT BACKUP TIME BACKUP SIZE WAL(s) SIZE WAL FILES STATUSThe -t option with the SHOW-BACKUPS subcommand displays additional backup information:-bash-4.1$ bart RESTORE -s hr -i hr_2017-03-29T13:50 -p /opt/restore_pg95 -t 1 -g '2017-03-29 14:01:00'The following shows the restored backup files in the restore path directory, /opt/restore_pg95: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.bash-4.1$ /opt/PostgreSQL/9.5/bin/pg_ctl start -D /opt/restore_pg95 -l /opt/restore_pg95/pg_log/logfile2017-03-29 14:33:23 EDT LOG: database system was interrupted; last known up at 2017-03-29 13:50:25 EDT2017-03-29 14:33:23 EDT LOG: recovery stopping before commit of transaction 1762, time 2017-03-29 14:02:28.100072-042017-03-29 14:33:23 EDT LOG: last completed transaction was at log time 2017-03-29 14:00:43.351333-04Since recovery was up to and including 2017-03-29 14:01:00, the following tables created after 14:01 are not present: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.