NetBackup™ Web UI 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 PostgreSQL data directory.

   Note:

   Post restore, 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 restored data directory to PostgreSQL data directory.
5. Create an empty file in data directory and name it recovery.signal.
6. Start PostgreSQL service.

For Linux (LVM):

1. Stop PostgreSQL services.
2. Copy all the contents of restored data directory to PostgreSQL data directory.
3. Create an empty file with name recovery.signal in data directory.
4. Change ownership of PostgreSQL data directory.

   For example:

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

5. Start the PostgreSQL service.

Recovery steps for backup done by pg_basebackup utility

1. Stop PostgreSQL services.
2. Delete or move everything from 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. (For Windows) Provide access to data directory for network service.
6. (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>
   

7. Start PostgreSQL service.

   Note:

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