External Database Requirements

Requirements

The following prerequisites are required to use an external PostrgreSQL Database:

• Postgres Version: 12  

• 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. One set of privileges is necessary for initializing and upgrading the database. The other set (which is a subset of the first) is for reading and writing data when the application is running. Although it is possible to use one role to handle both of these cases, it is recommended to separate them.

  • Ensure the DB roles have the public schema on their search_path(s): 
    ALTER ROLE <user> SET search_path = "$user", public; 

  • The Alert Admin 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 Admin role should have the following privileges on all objects in the public schema (or the schema/database when relevant): 

    • SELECT 

    • INSERT

    • UPDATE 

    • DELETE

    • EXECUTE 

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

    • SELECT 

    • INSERT 

    • UPDATE 

    • DELETE 

    • EXECUTE