PostgreSql Support
Hello,
I have few questions with regards to compatibility of PostgreSql.
1. Does Postgresql work only with Tomcat? We currently use JBoss application server and Nginx Web server. We are planning to only change the Database to Postgressql., Will that work?
2. We are planning to run Postgressql on AWS which uses the opensource version of Postgressql. I also know that Pega Cloud runs on AWS Postgressql. But the documentation says its supported only on Enterprise DB version. Can you confirm it will work with versions on AWS RDS?
I would appreciate if you can answer and also let me know if anyone is already using it.
Accepted Solution
EPAM Systems, Inc.
ES
Hi Abubakr,
Just to add on your queries,
1. Does Postgresql work only with Tomcat?
Ans:- No.
We currently use JBoss application server and Nginx Web server. We are planning to only change the Database to Postgressql., Will that work?
JBoss + PostGreSQL
Below are the few useful links(Generic) for configuration:-
https://developer.jboss.org/wiki/JBossAS7-DatasourceConfigurationForPostgresql
Nginx + PostGreSQL
Hi Abubakr,
Just to add on your queries,
1. Does Postgresql work only with Tomcat?
Ans:- No.
We currently use JBoss application server and Nginx Web server. We are planning to only change the Database to Postgressql., Will that work?
JBoss + PostGreSQL
Below are the few useful links(Generic) for configuration:-
https://developer.jboss.org/wiki/JBossAS7-DatasourceConfigurationForPostgresql
Nginx + PostGreSQL
https://ef.gy/using-postgresql-with-nginx
JBoss + PostgreSQL + Pega platform :- No
I second Rincy, below are the pointers from platform support guide :-
- PostgreSQL is only supported for the Tomcat webserver.
2. We are planning to run Postgressql on AWS which uses the opensource version of Postgressql. I also know that Pega Cloud runs on AWS Postgressql. But the documentation says its supported only on Enterprise DB version. Can you confirm it will work with versions on AWS RDS?
- The Postgres Community Editions are not supported for production enterprise systems. Only the Standard Edition (Enterprise DB) versions of Postgres are supported for enterprise installations.
- PostgreSQL(Standard or Enterprise Edition as well as Community edition) is supported for WAR installations only(in Tomcat server, if I am not wrong).
Kindly notify, if it helps you.
Regards,
Asif
Pegasystems Inc.
AU
Hi,
PostgreSQL is an open source database and is not specific to tomcat. You will find a lot of documentation on JBoss developer community regarding the same.
For AWS RDS (where DB service will be provided by AWS) and Postgres related query, please follow below links:
http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_PostgreSQL.html
https://aws.amazon.com/rds/postgresql/pricing/
https://aws.amazon.com/rds/postgresql/
For product platform support details from Pega Product perspective, please feel free to visit https://collaborate.pega.com/discussion/prpc-5x-6x-platform-support-guide-easy-find
Please feel free to revert back with further queries.
Amazon Corp
US
Hi Ashutosh,
Thanks for the response. I did look at AWS documentation already. I wanted to check if Pega Supports Community edition of Postgresql for Production use as that is what is on AWS. As per platform support guide only Enterprise DB versions are supported for Production use.
Pegasystems Inc.
IN
Hello Abubaker,
Thanks for posting your query in PSC :)
Find answer to the your first query i.e. Support of PostGreSQL with JBoss, in the PSC post .
I find this answer it true even for Pega 7.2.2. Refer https://pdn.pega.com/support-resources/deployment-upgrades/deployment-guides. You will find the installation guide of PostgreSQL with Tomcat. Refer https://collaborate.pega.com/discussion/prpc-5x-6x-platform-support-guide-easy-find, page number-9 mentioning Postgre only supported with Tomcat.
Also, refer https://collaborate.pega.com/question/pega-721-postgres-jboss-support
Hope this answers.
Regards,
Rincy
Accepted Solution
EPAM Systems, Inc.
ES
Hi Abubakr,
Just to add on your queries,
1. Does Postgresql work only with Tomcat?
Ans:- No.
We currently use JBoss application server and Nginx Web server. We are planning to only change the Database to Postgressql., Will that work?
JBoss + PostGreSQL
Below are the few useful links(Generic) for configuration:-
https://developer.jboss.org/wiki/JBossAS7-DatasourceConfigurationForPostgresql
Nginx + PostGreSQL
Hi Abubakr,
Just to add on your queries,
1. Does Postgresql work only with Tomcat?
Ans:- No.
We currently use JBoss application server and Nginx Web server. We are planning to only change the Database to Postgressql., Will that work?
JBoss + PostGreSQL
Below are the few useful links(Generic) for configuration:-
https://developer.jboss.org/wiki/JBossAS7-DatasourceConfigurationForPostgresql
Nginx + PostGreSQL
https://ef.gy/using-postgresql-with-nginx
JBoss + PostgreSQL + Pega platform :- No
I second Rincy, below are the pointers from platform support guide :-
- PostgreSQL is only supported for the Tomcat webserver.
2. We are planning to run Postgressql on AWS which uses the opensource version of Postgressql. I also know that Pega Cloud runs on AWS Postgressql. But the documentation says its supported only on Enterprise DB version. Can you confirm it will work with versions on AWS RDS?
- The Postgres Community Editions are not supported for production enterprise systems. Only the Standard Edition (Enterprise DB) versions of Postgres are supported for enterprise installations.
- PostgreSQL(Standard or Enterprise Edition as well as Community edition) is supported for WAR installations only(in Tomcat server, if I am not wrong).
Kindly notify, if it helps you.
Regards,
Asif