External Postgres Database Requirements

PostgreSQL major release version: 15 or 16

Alert follows the Black Duck SCA PostgreSQL Version Upgrade Schedule

Extension: uuid-ossp (Note: this should be installed prior to creating the database)

Schemas: public, alert

Roles/Privileges: Alert requires two sets of Postgres Privileges. The Alert Admin role is required to install uuid-ossp if it doesn't already exist. The Alert User role is required for all other operations during install and operation of the application.

• Ensure the DB roles have the public schema on their search_path(s):

  ALTER ROLE <user> SET search_path = "$user", public;

• The Alert User role should have the following privileges on all objects in the alert schema (or the schema/database when relevant):

  • SELECT
  • INSERT
  • CREATE
  • UPDATE
  • DELETE
  • TRUNCATE
  • REFERENCES
  • TRIGGER
  • TEMPORARY
  • EXECUTE
  • USAGE

• The Alert User role should have the following privileges on all objects in the public schema (or the schema/database when relevant):

  • SELECT
  • INSERT
  • UPDATE
  • DELETE
  • EXECUTE