KNOWLEDGE BASE

Retaining http_requests Data After Upgrades, Backups, or Cleanups


Published: 28 Aug 2013
Last Modified Date: 19 Dec 2019

Question

How to retain data that is purged from the http_requests table (user activity data) in the Tableau Server PostgreSQL database during upgrades, backups, and cleanups.

Environment

Tableau Server

Answer

Best Practice

  • Copy the data in its original structure into another database.

Alternative

  • Use a Postgres to SQL Server connector to copy the data to a secondary database.

Additional Information

  • Keeping the data in the same structure will allow you to replace the data connection (if necessary). All fields are aligned automatically, because the new data connection has the same structure as the original one.
  • Although Tableau Server does not archive any files, Tableau Support has seen cases in which users automatically back up their http_requests folder.
To voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: About http_requests table in tableau postgres table.


Discuss this article... Feedback Forum
Did this article resolve the issue?