If holmesdb password contains special char as single quote ex: Fonp2'GiluPifq which failed to instantiate database. The following logs are shown
Initializing the holmes rule management database...
GRANT ALL PRIVILEGES ON APLUS_RULE TO holmes;
You are now connected to database "postgres" as user "holmes".
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql:19: ERROR: permission denied to create database
psql:/opt/onap/bin/../dbscripts/postgresql/onap-holmes_rulemgt-createobj.sql:57: ERROR: unrecognized role option "gilupifq"
LINE 1: CREATE ROLE holmes with PASSWORD 'Fonp2'GiluPifq' LOGIN;
ERROR: relation "aplus_rule" does not exist
LINE 1: select * from aplus_rule;
Failed to initialize the database!
Could you please take a look?