---
schema_version: "1"
id: a7c8bff9159843d4e02e3bc10c6e3c302ea41449388399c58628f901eb4061cc
title: Tableau Server Repository
collection: tableau
version: next
locale: en-gb
portal_url: https://docs.salesforce.com/tableau/next/en-gb/server/server_process_repository.md
canonical_url: https://help.tableau.com/v0.0/server/en-gb/server_process_repository.htm
source_site: help.tableau.com
content_type: documentation
content_hash: 76cb65c2591813092902b48b0d0095a7af7f6f2e3f12d993ad34fe8482f7b66a
description: Understand the Tableau Server Repository PostgreSQL database.
---
[Skip to main content](#main-content)

# Tableau Server Repository

Tableau Server Repository is a database that stores server data. This data includes information about Tableau Server users, groups and group assignments, permissions, projects, data sources, workbooks, and extract metadata and refresh information.

The Repository is also referred to as the _PostgreSQL_ repository or database.

**Important:** Do not directly modify the repository. Doing so can break Tableau Server. Any customer modifications of the repository will make your installation unsupportable by Tableau.

<table style="width: 100%;mc-table-style: url('Resources/TableStyles/Basic-Border.css');" class="TableStyle-Basic-Border" cellspacing="0"><colgroup><col class="TableStyle-Basic-Border-Column-Column1" style="width: 15%;"><col class="TableStyle-Basic-Border-Column-Column1"></colgroup><tbody><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><strong>Process</strong></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Repository</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><strong>Status</strong></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Status of the Repository is visible on the Status Page. For more information, see <a href="https://help.tableau.com/v0.0/server/en-gb/service_viewstatus.htm" class="xref">View Server Process Status</a></td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyB-Column1-Body1"><strong>Logging</strong></td><td class="TableStyle-Basic-Border-BodyA-Column1-Body1">Logs generated by the repository are located in <code><code>C:\ProgramData\Tableau\Tableau Server\data\tabsvc\logs\</code>pgsql</code>. For more information, see <a href="https://help.tableau.com/v0.0/server/en-gb/logs_loc.htm" class="xref">Tableau Server Logs and Log File Locations</a></td></tr></tbody></table>

## Preferred active repository

When you configure Tableau Server you have the option to specify a node as the preferred active repository. When Tableau Server is configured for repository failover, the preferred active repository node is the one used for the active repository. This is an optional step, and if you do not specify a preferred active repository node, Tableau Server will select the active repository node on startup.

To configure the preferred active repository, use the `tsm configuration set` command to configure the `pgsql.preferred_host` option:

`tsm configuration set -k pgsql.preferred_host -v "<host_name>"`

**Note:** The `host_name` is case-sensitive and must match the node name shown in the output of `tsm status -v`.

Configure a preferred active repository node if you want Tableau Server to select a specific node on startup. You might want to do this if you have a particular server you want to use for your active repository (a computer with more disk space or memory for example), or if you are using custom administrative views. Custom administrative views have embedded connection information that refers to the repository for which you created the views. For more information on connecting to the Tableau Server repository, see [Collect Data with the Tableau Server Repository](https://help.tableau.com/v0.0/server/en-gb/perf_collect_server_repo.htm)

## The failoverrepository Command

If failover occurs and your passive repository becomes the active repository, it remains the active repository until either Tableau Server restarts or you use the `tsm topology failover-repository` command to switch back. Specify the repository you want to be the active one, or specify that the preferred active repository (if configured) should be made active again. For more information, see [tsm topology failover-repository](https://help.tableau.com/v0.0/server/en-gb/cli_topology_tsm.htm#TSMFailoverRepository).