PostgreSQL Setup

This article is for general guidance. Always work with your DBA when setting up a production database. If you have any questions, contact Senzing Support . Support is 100% FREE!
When upgrading from Senzing v3 to Senzing v4, there are changes made to the entity repository database schema. See Upgrading the Senzing Repository Schema To V4
For AWS Aurora PostgreSQL, see Aurora PostgreSQL Setup for cluster endpoint and IAM token authentication guidance.

Prerequisites

  • A <username>, <password>, IP or <hostname>, and <database> from the DBA that has select, delete, update, and truncate access

  • A PostgreSQL database tuned for Senzing

  • libpq and psql packages installed

  • Ubuntu/Debian: typically uses libpq5 and postgresql-client-common/postgresql-client-<version> packages
  • AWS Linux 2/RedHat: typically uses postgresql<version>-libs and postgresql<version> packages

Add the Senzing schema

If applicable, the DBA should set up the database schema. If you have any questions, contact Senzing Support . Support is 100% FREE!
psql -U <user> -d <database> -h <server> -W

\i <senzing_project_path>/resources/schema/szcore-schema-postgresql-create.sql
<senzing_project_path> refers to the path specified with the /opt/senzing/er/bin/sz_create_project command when creating a project.
\dt

\q

Configure the CONNECTION string

Edit the SENZING_ENGINE_CONFIGURATION_JSON environment variable or sz_engine_config.ini file :

Edit the new CONNECTION postgresql://<username>:<password>@<hostname>:5432:<database>/?schema=schemaname entry where:

5432 is the default PostgreSQL port number. Change this if the port value differs.
Parameter Description
<username> PostgreSQL username
<password> Password for the above username
<hostname> IP address or hostname of the PostgreSQL Server
5432 Port number of the PostgreSQL Server
<database> Database name
/?schema=schemaname Remove unless using custom schema

Update database with the Senzing ER configuration

A Senzing instance is configured with a Senzing Entity Resolution configuration. On a fresh installation this configuration needs to be registered in the Senzing database.

See Updating Database with Senzing ER Configuration

If you have any questions, contact Senzing Support. Support is 100% FREE!