User GuidesAPI ReferenceRelease NotesEnrichment APIs
Doc HomeSupportLog In

Configuring PostgreSQL

Change the PostgreSQL user password and encrypt that password.

You can configure the following PostgreSQL configuration variables:

Configuration Variable

Description

TAMR_PERSISTENCE_DB_URL

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.

TAMR_PERSISTENCE_DB_USER

The user for the Postgres instance.

TAMR_PERSISTENCE_DB_PASS

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:
psql 
ALTER USER tamr WITH PASSWORD <unencrypted_password>;
\q
  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
<tamr-home-directory>/openjdk-8u222/bin/java
echo $JAVA_HOME
<tamr-home-directory>/openjdk-8u222

If these settings are not 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 Core and its dependencies. See Restarting Tamr Core.

Did this page help you?