User GuidesAPI ReferenceRelease Notes
Doc HomeHelp CenterLog In
User Guides

Postgres

Optionally, you can configure Tamr to use an external instance of Postgres. In this case, you can specify the database URL, user, and password.

Single-node Tamr deployments use the instance of Postgres that is installed as part of the Tamr software package. See Install Postgres and Create the Database. Alternatively, you can configure Tamr to use an external instance of Postgres.

You can configure the following Postgres configuration variables:

Configuration VariableDescription
TAMR_PERSISTENCE_DB_URLThe URL of the database that you can use with the JDBC driver. In the URL, you can optionally specify ssl=true. This is useful if you are using an external instance of Postgres. For example, you can use: jdbc:postgresql://<host>:<port>/<database>?ssl=true.
TAMR_PERSISTENCE_DB_USERThe user for the Postgres instance.
TAMR_PERSISTENCE_DB_PASSThe encrypted password for the Postgres instance.

Changing the Default Postgres Username and password

To change the default username and password:

  1. Set a plain-text value for the configuration variable TAMR_PERSISTENCE_DB_USER using the admin tool. See Creating or Updating a Configuration Variable.
  2. Encrypt the database user's password using the utility encrypt.sh as follows:
cd <tamr-home-directory>/tamr
./encrypt.sh -AES256
Please enter a password to encrypt:
  1. Set the configuration variable TAMR_PERSISTENCE_DB_PASS to the encrypted output generated in Step 2 using the admin tool. See Creating or Updating a Configuration Variable.
  2. Restart Tamr and its dependencies. See Restarting.