NetBackup™ for PostgreSQL Administrator's Guide

For Windows (VSS):

1. Go to Control Panel > System and Security > Administrative Tools > Services.
2. Select PostgreSQL service and stop it.
3. Delete or move everything from the PostgreSQL data directory.

   Note:

   Post restores, change the attributes of the restored data directory and files by using the following command:

   attrib -S restore_path/*.* /S /D

4. Copy all the contents of the restored data directory to PostgreSQL data directory.
5. Edit the postgresql.conf file from the PostgreSQL data directory and edit the restore_command parameter as restore_command = 'copy "restored_WAL_directory\\%f" "%p"'.

   For precise point-in-time recovery, specify the timestamp up to which recovery is performed. Update the recovery_target_time parameter as recovery_target_time = 'yyyy-mm-dd hh:mm:ss'

6. Create an empty file in the data directory and name it recovery.signal.
7. Start PostgreSQL service.

For Linux (LVM):

1. Stop PostgreSQL services.
2. Delete or move everything from the PostgreSQL data directory.
3. Extract and copy the data directory and WAL directory contents to respective location.
4. Create an empty file with name recovery.signal in data directory.
5. Edit the postgresql.conf file from the PostgreSQL data directory and edit the restore_command parameter as restore_command = 'copy "restored_WAL_directory\\%f" "%p"'.

   For precise point-in-time recovery, specify the timestamp up to which recovery is performed. Update the recovery_target_time parameter as recovery_target_time = 'yyyy-mm-dd hh:mm:ss'

6. Change ownership of PostgreSQL data directory and permission to 700.

   For example:

   chown -R postgres:postgres /full/path/of/PostgreSQL/Data/Dir

   chmod - R 700 /full/path/of/PostgreSQL/Data/Dir

7. Start PostgreSQL service.

Recovery steps for backup done by pg_basebackup utility

1. Stop PostgreSQL services.
2. Delete or move everything from the PostgreSQL data directory.
3. Extract and copy the data directory and WAL directory contents to respective location.
4. Create an empty file with name recovery.signal in data directory.
5. Edit the postgresql.conf file from the PostgreSQL data directory and edit the restore_command parameter as restore_command = 'copy "restored_WAL_directory\\%f" "%p"'.

   For precise point-in-time recovery, specify the timestamp up to which recovery is performed. Update the recovery_target_time parameter as recovery_target_time = 'yyyy-mm-dd hh:mm:ss'

6. (For Windows) Provide access to data directory for network service.
7. (For Linux) Change ownership of PostgreSQL data directory and permission to 700.

   For example:

   chown -R postgres:postgres /full/path/of/PostgreSQL/Data/Dir
   chmod  - R 700 /full/path/of/PostgreSQL/Data/Dir
   

8. Start PostgreSQL service.

   Note:

   Remove the restore data from the restored path /full/path/of/restore/directory after successful recovery, else the next backup job may fail.