Upgrade Tableau Server with External Repository for a New Major Version of PostgreSQL

When there is a change in the PostgreSQL major version requirement for Tableau Server, there are some specific instructions you must follow to ensure that your Tableau Server upgrade is successful. For example, Tableau Server 2020.4 requires the repository to use PostgreSQL version 12. This is a major version change from PostgreSQL version 9.x used in Tableau Server versions earlier than 2020.4. So if you are upgrading from an earlier version of Tableau Server to version 2020.4 or later, you will need to take the steps described in the following sections to complete the upgrade.

This topic also includes the product compatibility between PostgreSQL and Tableau Server.

Before you upgrade

You cannot do an in-place upgrade to update the PostgreSQL version on your existing PostgreSQL DB instance on Amazon RDS or Azure Database for PostgreSQL DB. Instead, you must create a new instance and point the Tableau Server to the new instance during upgrade. Use the following information to create a new instance and prepare for the upgrade:

  1. Create a new instance of PostgreSQL Database instance:
    1. Create a PostgreSQL DB Instance on AWS Relational Database Service (RDS)
    2. Create an Azure Database PostgreSQL Instance on Azure
    3. Create a PostgreSQL Instance on Google Cloud
    4. Create a PostgreSQL Database as a Stand-Alone Installation
  2. SSL connections are not required but recommended. If you want to set up SSL connections for communications between Tableau Server and the External Repository, do the following:
  3. Create a configuration file for the new instance you created in step 1.

    Create a json file with the following configuration settings:

    {
     "flavor":"<flavor name>",
     "masterUsername":"<admin user name>",
     "masterPassword":"<password>", 
     "host":"<instance host name>",
     "port":5432
    }
    
    • flavour: This is the type of external service you are going to use for Tableau Server repository.

      • Amazon RDS: use “rds”
      • Azure Database: use "azure"
      • Google Cloud Database: use "gcp"
      • Stand-alone PostgreSQL database: use "generic"
    • masterUsername:

      • Amazon RDS: Use "rails” for the username. This is the user that you specified when creating the RDS instance.

        You must use "rails" as the masterUsername. This is required for the external repository to work with Tableau Server properly.

      • Azure Database, Google Cloud Instance or Stand-alone PostgreSQL Instance: Choose a username that meets your requirements. We recommend using postgres as the Administrator username. If you choose to use a different username, make sure that the username does not start with pg or azure. The username also cannot be rails, tblwgadmin, tableau, readonly or tbladminviews.
    • masterPassword: This is the same password you specified when creating the PostgreSQL database instance.

    • host: This is the endpoint of your PostgreSQL database instance.

    • port: The database port you specified when creating the PostgreSQL DB instance. Default port for PostgreSQL is 5432.

Tableau Server Upgrade

Note: If you are using Tableau Server External Repository, you must upgrade Tableau server using the command line option.

The following are the high level steps of how to specify the external repository parameters when running the upgrade script.

For a full walk-through of the Tableau Server upgrade process, see Upgrading from earlier versions.

  1. On the Tableau Server, open a command prompt as administrator.

    Note: You must open a new command window because the Setup program updates the path for the new installation.

  2. Navigate to the scripts folder for your new installation.

    By default:

    C:\Program Files\Tableau\Tableau Server\packages\scripts.<version_code>\

  3. Run the upgrade script and specify the configuration file and the SSL certificate:

    upgrade-tsm.cmd --external-repository-config-file=<json config file> --external-repository-cert-file=<SSL certificate file>

Product Compatibility

The table below lists the version of PostgreSQL that is supported with Tableau Server. Use this table to determine the version of PostgreSQL to install for your External Repository.


Amazon RDS support: External Repository using Amazon RDS is supported on Tableau Server versions 2019.3 and later.
Azure Database support: External Repository using Azure Database instance is supported on Tableau Server versions 2020.4 and later.

Google Cloud support: External Repository using Google Cloud SQL instance is supported on Tableau Server versions 2021.4 and later.
Stand-alone PostgreSQL instance support: External Repository using a stand-alone installation of PostgreSQL database is supported on Tableau Server versions 2021.2 and later.

Google Cloud Platform support: External Repository using a PostgreSQL instance on Google Cloud Platform is supported on Tableau Server versions 2021.4 and later.

Tableau Server versionsPostgreSQL minimum compatible versions
2021.2.3 - 2021.2.8

2021.3.0 - 2021.3.7

2021.4.0 - 2021.4.3

12.6
2021.2.10 - 2021.2.14

2021.3.8 - 2021.3.13

2021.4.4 - 2021.4.8

12.8
2021.2.15 - 2021.2.16

2021.3.14 - 2021.3.15

2021.4.9 - 2021.4.10

12.10
2021.2.17 - 2021.2.18

2021.3.16 - 2021.3.17

2021.4.11 - 2021.4.12

12.11
2021.3.26

2021.4.23

12.15
2022.1.013.3
2022.1.1 - 2022.1.313.4
2022.1.4 - 2022.1.613.6
2022.1.7 - 2022.1.16

2022.3.0 - 2022.3.7

2023.1.0 - 2023.1.4

13.7
2022.1.17 - 2022.1.19

2022.3.8 - 2022.3.11

2023.1.5 - 2023.1.7

2023.3.0 - 2023.3.3

13.11
2024.0 - 2024.x15.6
Legacy compatibility

The table below includes two columns:

  1. PostgreSQL version shipped with Tableau Server, which is the version that is installed with Tableau Server for local Repositories.
  2. All PostgreSQL versions supported for External Repository.

Notes:
- For PostgreSQL versions earlier than version 10, the first two digits indicate the major version, and the minor version is represented by the last digit. For example, in the version 9.4.1, 9.4 indicates the major version and the .1 indicates the minor version.
- For PostgreSQL versions 10 or later, the first digit indicates the major version, and the minor version is the represented by the last digit. For example, in the version 11.1, 11 is the major version and .1 is the minor version.
- A PostgreSQL version with a major version equal to, and a minor version greater than, the Postgres version shipped with Tableau server is always acceptable for use with the external repository, along with any explicitly allowed older versions.

Tableau Server VersionPostgreSQL Version (Shipped with Tableau Server)Alternative PostgreSQL Versions supported for External Repository
2019.3 - 2019.3.39.6.11

9.6.x, where x is greater than 11

2019.3.4 - 2019.3.109.6.159.6.x, where x is greater than 15
2019.3.11 - 2019.3.149.6.179.6.15, or 9.6.x, where x greater than 17
2019.4 - 2019.4.19.6.149.6.x, where x is greater than 14
2019.4.2 - 2019.4.69.6.159.6.x, where x is greater than 15
2019.4.7 - 2019.4.139.6.179.6.15, or 9.6.x, where x is greater than 17
2020.1 - 2020.1.69.6.159.6.x, where x is greater than 15
2020.1.7 - 2020.3.29.6.179.6.15, or 9.6.x, where x is greater than 17
2020.4 – 2021.412.8

12.8, or 12.x, where x is greater than 8

2022.1 and later13.313.3 or 13.x, where x is greater than 3

Who can do this

Tableau Server Administrators can upgrade and configure Tableau Server.

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!