I'm trying to install Pega Chat 7.4, using a Postgres RDS instance. Is this possible/supported? I'm on the step in the installation guide where I need to run the postgres_script.sql, so am running the SQL through pgAdmin4 directly in the database. I'm getting an error saying 'ERROR: function uuid_generate_vlmc() does not exist'.
I'm wondering if this may be a side effect of using RDS instead of a server based Postgres install. Can anyone help?
I ended up figuring this out on my own - after further research these functions are part of the uuid-ossp extension that the aforementioned postgres_script.sql tries to enable in the line 'CREATE EXTENSION IF NOT EXISTS "uuid-ossp";' However, this extension already existed in Amazon's RDS instance for Postgres but for some reason I was unable to call the specific uuid_generate_v1mc() function. In order to refresh/reinstall these functions I ran a 'DROP EXTENSION "uuid-ossp";' and then followed it up with a 'CREATE EXTENSION "uuid-ossp";'
After doing this, I was able to call the uuid_generate_v1mc() function. Access to the function can be tested by running 'SELECT uuid_generate_v1mc();'