Back Up and Restore the Report Server Database

You can use the pg_dump.exe utility to create a file that contains the entire contents of your Report Server database. This file is called a dump file. You can use this file and the pg_restore.exe utility to restore the database on the current server, or to move the Report Server to a different server.

  1. Open a command prompt.
  2. Type cd \Program Files\WatchGuard\wsm11\postgresql\bin and press Enter to change your working directory.
    Use the appropriate version number for your WSM installation.
  3. Type pg_dump -v -f "c:\report.backup" -F c -Z 5 -U wguser wgrep and press Enter.
  4. When requested, type your Administrator passphrase.
    The contents of your Report Server database are saved to the specified path and filename, in your current working directory (selected in Step 1).
  5. Copy the backup file to the new Report Server computer (for example, C:\backup.db).
  6. Stop the Report Server.
    For more information, see Start or Stop the Report Server.
  7. At a command prompt, change your current working directory to \Program Files\WatchGuard\wsm11\postgresql\bin.
  8. Select an option to restore the database:
    • To restore the database backup on an existing Report Server computer that has a Report Server database installed and configured with the WatchGuard Server Center Setup wizard, type pg_restore -U wguser -v -c -d wgrep "c:\report.backup" and press Enter.
      When requested, type your Administrator passphrase and press Enter.
      The Report Server database is overwritten with the contents of the database dump file.
    • To restore the database backup on a new Report Server computer that does not have a database created and configured with the WatchGuard Server Center Setup wizard, type pg_restore -U wguser -v -C -d wgrep "c:\report.backup" and press Enter.
      When requested, type your Administrator passphrase and press Enter again.
      The database is created and the backup file contents are imported into the new Report Server.
  9. Start the Report Server.
    For more information, see Start or Stop the Report Server.

See Also 

Configure Report Deletion Settings and Database Settings

Move the Report Directory

About the Report Server

Give Us Feedback     Get Support     All Product Documentation     Technical Search