UDF for AWS RDS - Postgres
Does anyone know whether we can install UDF without pljava support on AWS RDS- postgres or not?
Accepted Solution
Coforge
AU
As far as I know the Amazon RDS service does not allow installation of user-defined functions (UDFs).Because we do not have access to the operating system which is required to add PL/Java to PostgreSQL, we cannot install traditional UDFs on Amazon RDS (PostgreSQL). I am looking for workaround like PL/V8 instead of pl/java otherwise we need to complete the installation without UDF.
Pegasystems Inc.
IN
Hi,
The Pega Platform requires Java user-defined functions (UDFs). To work with PostgreSQL, UDFs require the PL/Java add-on for PostgreSQL and a new dedicated schema. The new schema, called SQLJ, is defined for the Pega Platform database.
Provided the Pega 7.3.1 installation guide with postgre. This may help you.
https://docs-previous.pega.com/pega-73-platform-installation-guide-apache-tomcat-and-postgresql
Accepted Solution
Coforge
AU
As far as I know the Amazon RDS service does not allow installation of user-defined functions (UDFs).Because we do not have access to the operating system which is required to add PL/Java to PostgreSQL, we cannot install traditional UDFs on Amazon RDS (PostgreSQL). I am looking for workaround like PL/V8 instead of pl/java otherwise we need to complete the installation without UDF.
Red Alpha, LLC
US
Pega newbie here - are you saying that Pega Platform requires UDFs and because PostgreSQL on RDS/Amazon is not available, we cannot install Pega Platform with PostgreSQL on RDS/Amazon?
I'm trying to work through the install documentation, but am wary of wasting a bunch of time if it's known not to work...
Toyota Financial Services
AU
Hi Ishwar,
Can you please provide more details on PL/V8? We are migrating to Amazon RDS PostgreSQL and facing errors while doing the execution of install.sql UDF script that got from the Media file.
Error message:
ERROR: permission denied for language c
SQL state: 42501
Thanks
Sandeep P V