Was this page helpful?
Yes No
Tableau Help > Tableau Server for Windows Help > 

Verify the Tableau Postgres Database

Under rare circumstances, the PostgreSQL database that Tableau Server users for its repository can become corrupted. (If corruption occurs, it's often a result of a hardware problem on the computer hosting the repository.) The corruption may not be immediately obvious and may not cause the database to stop functioning, but it can impact your ability to restore a backup of the data.

To help you avoid problems due to database corruption, as a best practice you should regularly perform these tasks:

  • Verify the integrity of the PostgreSQL database.
  • Back up your Tableau data.

Note: The verify option is available beginning with version 9.3 of Tableau Server.

Verifying the database

You can verify database integrity while you perform a backup, or you can verify the database, or a backup of the database, as a separate step.

To verify the database during a backup, add the -v option to the backup command:

tabadmin backup tabserver -v

To verify the current database or a backup of the database, use the verify_database command:

tabadmin verify_database

Note: You do not need to stop Tableau Server to verify the database.

This command verifies that a backup of the PostgreSQL database can be restored successfully. If you cannot restore the database, your backups aren't useful, and Tableau Server upgrades can fail.

Verify the integrity of the Tableau PostgrSQL database using the procedure below.

  1. Open a command prompt as an administrator and type the following:
    cd "C:\Program Files\Tableau\Tableau Server\10.4\bin"

    Note: If you are running a distributed installation of Tableau Server, perform this step on the primary computer.

  2. Verify the current database or a backup of the database. You do not need to stop Tableau Server to verify the database.

    • Verify the integrity of the Postgres database by typing the following:

      tabadmin verify_database

    • Verify the integrity of a backup file by typing the following:

      tabadmin verify_database -f <filename>, where <filename> is the name of your backup file.

      For example:

      tabadmin verify_database -f c:\backups\tableau\tabserver\tserver.tsbak

    • Verify the integrity of the database while creating a backup of the Tableau Server data by adding -v to the backup command:

      tabadmin backup tabserver -v

    You can optionally specify a location for temporary files that are created during the verification process.

    tabadmin verify_database -t C:\mytemp\tableau

    If you don't specify a location, the default Tableau temp folder is used.