User GuidesAPI ReferenceRelease NotesEnrichment APIs
Doc HomeHelp 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 these settings are not set, run the following commands (assuming bash shell):

export JAVA_HOME=<tamr-home-directory>/openjdk-8u312-b07
export PATH=$JAVA_HOME/bin:$PATH
  1. Encrypt the database user's password using the utility as follows:
cd <tamr-home-directory>/tamr
./ -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 Core and its dependencies. See Restarting Tamr Core.