1 Reply Latest reply on Jun 18, 2012 11:12 AM by Joel Morris

    Disaster recovery via PostgreSQL backup / restore.

    allan.elder

      Hi

       

      We are currently in the process of creating our first live Tableau server instance; one of the questions that has come up is around disaster recovery. Our future plan is to have two hosts running Tableau; one live, and one dormant. We will be running backups of the live database every 15 mins.

       

      My question is, should there be a need to take the live host down and point users to the dormant host, can this be done by bringing up the dormant host and restoring the latest backup?

        • 1. Re: Disaster recovery via PostgreSQL backup / restore.
          Joel Morris

          Restoring PostGres is not sufficient for restoring a Tableau Server environment.  You will need to run Tableau Server backups in order to be able to recover a working Tableau Server instance.  This can be done using the "--unsafe" flag if you do not want to stop the server for the backup process (see the backup guide in the online help).  These backups should contain all you data with the exception of workbooks or extracts which are at that time, in the middle of being published updated or refreshed.  Usually, in the event of a disaster these can simply be re-published individually.

           

          Additionally, Tableau Server now has "High Availability" which means that a single environment can have passive, fail-over PostGres and Data Engine components (see "Understanding High Availability" in our online help).