The following demonstrates the point-in-time recovery operation on the remote PostgreSQL database server.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.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 Apr 23 17:02 000000010000000000000018-rw------- 1 postgres postgres 16777216 Apr 23 16:54 000000010000000000000019-rw------- 1 postgres postgres 16777216 Apr 23 16:55 00000001000000000000001A-rw------- 1 postgres postgres 16777216 Apr 23 17:00 00000001000000000000001B-rw------- 1 postgres postgres 16777216 Apr 23 16:59 00000001000000000000001C-rw------- 1 postgres postgres 16777216 Apr 23 17:01 00000001000000000000001DOn the remote host, the directory is created to which the PostgreSQL database cluster is to be restored. This restore path is /opt/restore_pg94 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 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:-bash-4.1$ bart RESTORE -s pg94_remote -i pg94_2015-04-23T16:43 -p /opt/restore_pg94 -t 1 -g '2015-04-23 16:57:00'The following shows the restored base backup files in the restore path directory, /opt/restore_pg94: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.bash-4.1$ /opt/PostgreSQL/9.4/bin/pg_ctl start -D /opt/restore_pg94 -l /opt/restore_pg94/pg_log/logfile2015-04-23 18:01:08 EDT LOG: database system was interrupted; last known up at 2015-04-23 16:43:59 EDT2015-04-23 18:01:08 EDT LOG: recovery stopping before commit of transaction 1815, time 2015-04-23 17:00:24.475528-042015-04-23 18:01:08 EDT LOG: last completed transaction was at log time 2015-04-23 16:54:09.212224-04Since recovery was up to and including 2015-04-23 16:57:00, the following tables created after 16:57 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.