HomeTamr Core GuidesTamr Core API Reference
Tamr Core GuidesTamr Core API ReferenceTamr Core TutorialsEnrichment API ReferenceSupport Help CenterLog In

Configuring PostgreSQL

Change the PostgreSQL user password and encrypt that password.

You can configure the following PostgreSQL configuration variables:

Configuration Variable



The 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.


The user for the Postgres instance.


The encrypted password for the Postgres instance.

For more information, see the Configuration Variable Reference.

Changing the Postgres Username and Password

To change the username and password:

  1. Use the PostgreSQL ALTER USER command to change the default password for the "tamr" username. For example:
ALTER USER tamr WITH PASSWORD <unencrypted_password>;
  1. Restart PostgreSQL.
  2. Set a plain-text value for the configuration variable TAMR_PERSISTENCE_DB_USER using the admin tool. See Creating or Updating a Configuration Variable.
  3. Confirm that the current Java is set to Tamr's bundled OpenJDK package, and that the environment variable JAVA_HOME is set.
which java

If those aren't set, run the following commands (assuming bash shell):

export JAVA_HOME=<tamr-home-directory>/openjdk-8u222
export PATH=$JAVA_HOME/bin:$PATH
  1. 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 5 using the administration utility. See Setting configuration variables.
  2. Restart Tamr and its dependencies. See Restarting.

Did this page help you?