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 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. |
Changing the Default Postgres Username and password
To change the default username and password:
- Set a plain-text value for the configuration variable
TAMR_PERSISTENCE_DB_USER
using the admin tool. See Creating or Updating a Configuration Variable. - 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:
- 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. - Restart Tamr and its dependencies. See Restarting.
Updated over 5 years ago