Access to the PostgreSQL database that comes with tableau

Suddenly found that the company Tableau server database size increased sharply, so decided to directly connected to the database troubleshooting. The process is recorded as follows: Finally, a http_requests table was found to be large (7G), which was supposed to be a data cache. The result is a log problem O (╯-╰) O. Because the company's tableau version is relatively low cannot directly view the table, temporarily did not touch it, do not know whether it will affect performance.

One. Open Tableau Server database access 1. Open a Command Prompt window (administrator) into the directory where the Tableau program is located

" C:\Program Files\tableau\tableau Server\8.3\bin "

2.8.2.4 and Previous versions enter the following command to open the command for user tableau to access the database

Tabadmin dbpass [Password]

For example, enable the "Tableau" user and set the password to "[email protected]";

Tabadmin dbpass [email protected]

8.2.5 and above use the following command, 8.2.5 Add more One readonly user can access all tables in the database

Tabadmin dbpass--username [tableau | readonly[password]

For example, enable the "Tableau" user and set the password to "[email protected]";

Tabadmin dbpass--username tableau [email protected]

Or turn on the "readonly" user and set the password to "[email protected]":

Tabadmin dbpass--username readonly [email protected]

Note: If the user is not specified, the user "tableau" is enabled by default

3. Restart Tableau Server

Tabadmin restart

To block access, you can use the following command

Tabadmin dbpass--disable--username [user]

Like what:

Tabadmin dbpass--disable--username readonly tabadmin Restart Note: If you do not specify a user, the default mask "tableau the user

Official Document Address: http://onlinehelp.tableausoftware.com/current/server/en-us/adminview_postgres_access.htm

Two. Using PostgreSQL Client Access

Open the PostgreSQL client

Server: Enter the tableau server address

Database:tableau's own database is named Workgroup.

Port:tableau default port is 8060-if not connected, the reason for excluding the firewall, you can view the directory (C:\Program Files\tableau\tableau server\8.3\config) If the pgsql.port in the file is set to a different port

Username:tableau or ReadOnly

Note: Tableau users cannot read all the tables in the database. For example, Http_requests does not have permission to view the table data must be read-only account readonly

Attached official use Tableau desktop to connect database document Http://onlinehelp.tableausoftware.com/current/server/en-us/adminview_postgres_connect.htm

Access to the PostgreSQL database that comes with tableau