The steps are as follows:
- If you've used the Standalone hot physical database backup recipe, then recovery is very easy. Restore the backup file in the target server.
- Extract the backup file to the new data directory.
- Confirm that you have the correct backup before you restore:
$ cat backup_labelSTART WAL LOCATION: 0/12000020 (file 000000010000000000000012)CHECKPOINT LOCATION: 0/12000058START TIME: 2017-06-03 19:53:23 BSTLABEL: standalone
- Verify that all file permissions and ownerships are correct and links are valid. This should already be the case if you are using the Postgres user ID everywhere, which is recommended.
- Start the server.
This procedure is so simple because in the Standalone hot physical database backup recipe ...