Search

Client-Hosted Database Requirements

Client-Hosted Database Requirements

Client-Hosted Database Requirements

Server Requirements

  • PostgreSQL (or compatible) server, with version 13 at minimum
  • SSL connection supported
  • 20GB of free storage space to get started (recommended 100GB)
  • Able to support burst of 100 connections (recommended 500 connections)

User Requirements

  • User db_writer
    • CREATE DATABASE, CREATE ROLE permissions at minimum
    • Password is to be an alpha-numerical random string 64-character long
SQL SCRIPT (recommended)  

CREATE ROLE db_writer WITH 
LOGIN 
NOSUPERUSER 
CREATEDB 
CREATEROLE 
NOREPLICATION; 

(replace the password accordingly)

ALTER ROLE db_writer PASSWORD 'xxxxxx'; 

Onboarding process

  • Reason Automation provides IP for the client to whitelist.
  • The client whitelist IP provided by Reason Automation
  • The client generates an alpha-numerical random string 64-character long
  • The client creates the db_writer user
  • The client communicates to ReasonAutomation the following:
Server FQDN: XXX 
Server port: XXX 
Username: 
db_writer Password: XXX 
  • Reason Automation validates connectivity and permissions
  • Reason Automation will manage the databases and create read-only accounts for auditing automatically

FAQ

1. Is the SSL requirement a must have?
2. Why are so many connections used by Reason Automation?
3. How many databases/accounts will be created?