Skip to main content

Tableau dirty Backup

Steps for performing a dirty restore

1. Install Tableau Server 2019.1.0 on the Dev machine
2. Stop Tableau Server
3. Copy the following folders from the current production:

D:\Tableau Server\data\tabsvc\pgsql
D:\Tableau Server\data\tabsvc\dataengine

4. Update the pg_hba.conf

D:\Tableau Server\data\tabsvc\config\pgsql_0.<version>/pg_hba.conf

Change "md5" to "trust" for the user "tblwgadmin" like this:
host    all         tblwgadmin         <address>/32          md5
to : host    all         tblwgadmin        <address>/32         trust

5. Regenerate the internal token:

tsm security regenerate-internal-tokens [options] [global options]
tsm pending-changes apply

6. Re-index

tsm maintenance reindex-search

7. Make a proper backup:
tsm maintenance backup -f myBackup

At this point, we will have the proper backup.  During this time, confirm the content on the Dev environment.

Once we confirmed all is good, we can consider performing a clean re-installation.

Step 1 - Copy the configuration files for reference

D:\Tableau Server\data\tabsvc\config\tabadminagent <version>

Step 2 - Remove Tableau Server

a. Open command prompt as administrator

b. Navigate to D:\Tableau Server\packages\scripts.<version>

c. Run: tableau-server-obliterate.cmd -y -y -y

Note: This will leave the license information intact.

d. Confirm no orphaned Tableau Server services

e. Rename D:\Tableau Server\ to D:\Tableau Server Old\

Step 3 - Install Tableau Server

Confirm the installation path.  Can reference the settings export file if needed.

Recommend initially installing with the Network Service to keep the installation simple as we can update the Run As User later by accessing the TSM GUI on port 8850

Configure with the same identity store as the original installation (local versus Active Directory)

Step 4 - Restore content

a. Copy the tsbak file to the following:

D:\Tableau Server\data\tabsvc\files\backups

b. Replicate the permission from the backup folder to the tsbak.  This will ensure less issue with the file permission

b. Run: tsm maintenance restore -f <filename>.tsbak

Step 5: Configure the following:

* External SSL
* Update the Run As User
* Restore custom branding

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Gateway port to use 80 to 443 on Tableau Server

Change Gateway port from 80 to 443 or 8080       To change the Gateway port from 80 to 443 then use below commands First , list your nodes with the command. tsm topology list-node  Then execute the command to set port  tsm topology set-ports --node-name node1 --port-name gateway:primary --port-value 443 The above command will ask for a restart.  Check ports using  tsm topology list-ports  If some error occurs in applying changes: try disabling (enable later) external ssl first- tsm security external-ssl disable You might need to run init command again with new port- tsm reset tabcmd initialuser --server localhost:443 --username 'ADMINUSER' --password 'adminpwd'
Post a Comment
Read more

Creating Groups using Tableau API and Python Script

 Creating Tableau Groups using Python and API Prerequisites: Python on the machine tableauserverclient module API enabled on Tableau server. Permissions to update for the user Groups.csv file . list all groups in a csv file Changes to be made in the script for below lines in the script groups = open('<Filepath>/groups.csv') pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' Script: import tableauserverclient as TSC import csv groups = open('<Filepath>/groups.csv') grp = csv.reader(groups) sourcegroups=[] createdgrps=[] pat='getyourpersonaltoken' server = TSC.Server('http://myserver.tableau.com',use_server_version=True) tokenName = 'mytokenname' ta = TSC.PersonalAccessTokenAuth(token_name=tokenName, personal_access_token=pat) with server.auth.sign_in_with_personal_access_token(ta):    groupslist, pagination_item  = server.groups.get() ...
Post a Comment
Read more