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

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!