Before You Begin:
- Install PostgreSQL before creating the database and database user.
- Review the permission and configuration requirements below.
The database user must have the following permissions:
- CRUD access to the tables in all the schemas in the database used by Tamr Core for normal operation.
- For setup and upgrade, CRUD access to schema objects and schemas.
The simplest way to meet this requirement is to configure the Tamr Core database user as the owner of the database it uses.
Note: The Tamr Core database user does not require SUPERUSER access.
The Tamr Core database and database user must meet these configuration requirements:
- The name of the Tamr Core database must match the last path element in the
TAMR_PERSISTENCE_DB_URLconfiguration variable. The default name is
- The user for the Tamr database must match the
TAMR_PERSISTENCE_DB_USERconfiguration variable. The default is
- The password for the Tamr database user must match the
Important: For security purposes, do not use the default value for the Tamr database user password.
For more information on configuring Tamr Core access to PostgreSQL, including how to set the password used to access the database, see PostgreSQL.
To create the database and database user:
- Follow the example below to create and configure the database and database user:
sudo su - postgres psql -c "CREATE USER <username> PASSWORD '<password>';" psql -c "CREATE DATABASE <database> WITH OWNER <username>;" exit
- Confirm that you can sign in to the PostgresQL database with the username and password:
psql <database> -U <user> -h localhost -W Password: <password> exit
Updated 7 months ago