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.
- Open a command prompt.
- 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. - Type pg_dump -v -f "c:\report.backup" -F c -Z 5 -U wguser wgrep and press Enter.
- 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). - Copy the backup file to the new Report Server computer (for example, C:\backup.db).
- Stop the Report Server.
For more information, go to Start or Stop the Report Server. - At a command prompt, change your current working directory to \Program Files\WatchGuard\wsm11\postgresql\bin.
- 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.
- 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.
- Start the Report Server.
For more information, go to Start or Stop the Report Server.