Installing PEGA Platform 8.5 with Tomcat and PostgreSQL

In this vide I am going to tell you the step by step process on How to Installing Pega Platform 8.5 with Tomcat and PostgreSQL.

Prerequisite

Download the 116916_Pega8.52.zip from Pega via My Digital Software Delivery

Pega Platform My Digital Software Delivery — Pega Digital Software Delivery

2. Download the PostgreSQL Database, I have downloaded 9.6 for my windows 64-bit operating system.

pega postgreSQL database download — https://www.enterprisedb.com/downloads/postgres-postgresql-downloads

3. Download & Install Java and JDK.

download java and jdk in windows 10 operating system — java.com/en/download , oracle.com/java/technologies/javase-jdk15-downloads.html

4.Download PostgreSQL JDBC Driver (You can download the jar from Stack Builder also)

PostgreSQL JDBC Driver download for Pega Platform — Jdbc.postgresql.org/download.html

5.Download and Install Apache Tomcat Server

Apache Tomcat Server download and Install windows 10 — https://tomcat.apache.org/download-90.cgi

If you are unsure on How to Install and Configure PostgreSQL, Java, jdk and Apache Tomcat Server, then pause this video right here, and watch below videos on my channel.

https://youtu.be/SSZp0vifz7A

https://youtu.be/atbVosbi4As

https://youtu.be/kOSFJdL_VQI

Follow the below steps one by one to install and configure PEGA Platform 8.5 with Tomcat and PostgreSQL

Step 1: set JAVA_HOME, JRE_HOME, Path environment variable

JAVA_HOME, JRE_HOME set environment varibles for Pega platform 8.5 for Tomcat

Step 2: Create database user by using PostgreSQL tools

create new database user for PostgreSQL pega platform 8.5

Right-click Login Roles and select New Login Role.
In the Role Name field, enter the name for your database user.
On the Definition tab, enter the password for this user.
On the Role Privileges tab, grant permissions to this user. ØClick OK.

Step 3: Create an empty database

postgreSQL empty database creation for pega platform 8.5

Right-click Databases and select New Database.
In the Name field, enter the name of the new database to create.
In the Owner drop down box, select the database user.
Click OK to create the database.

Step 4: Create the primary schemas

Under the database name, right-click Schemas and select New Schema.
On the New Schema window, in the Name field, enter the schema name in lowercase letters.
Use the Owner drop-down list to select your database user.
On the Privileges tab, select ALL, click Add/Change and select the privileges to grant to the database user.
Add the schema to the search path:

.In the Databases section, right-click your database name and select Properties.
Select Variables.
In the Variable Name field, select search_path.
In the Variable Value field, specify both the primary schema and the database schema. dataschema,rulesschema
Click Add/Change.
Click OK to add the variable.

create schema in pega postgreSQL database 8.5

Step 5: Installing PL/Java on Windows for Java user-defined functions

Install Microsoft Visual C++ (MSVC) runtime integrated development environment from the Microsoft Windows site. Install MSVC even if it is already installed.

Pega already gaving this software in their distribution package (ResourceKit –> PLJava –> 9.6 –> Windows)

Restart your computer

Copy the following files from ResourceKit\PLJava\9.x\Windows to the PostgreSQL_Home\lib\directory.

• pljava.dll

• pljava.jar

Configure the PostgreSQL virtual machine and library options:

Open postgresql.conf in the PostgreSQL data directory and navigate to the end of the file.
Enter a line similar to the following to add the classpath; use the double slash marks for the entire path name in the classpath as shown: pljava.classpath=’PostgreSQL_Home\\lib64\\pljava.jar’
Optional. Enter a line similar to the following to set the virtual machine options:
1. pljava.vmoptions = ‘-Xms32M -Xmx64M -XX:ParallelGCThreads=2’
Enter the following line to set the working memory size:
1. work_mem = 5MB
At the end of the file, enter a line similar to the following to set the library location from step 4; use the double slash marks for the entire path name as shown:
1. pljava.libjvm_location = ‘%JRE_HOME%\\bin\\server\\filename’
Save and close postgresql.conf.
Stop and restart the PostgreSQL service.

After completing changes, it looks like below

postgresql config file for pega platform 8.5 installing

Step 6: Creating secondary schema for Java user-defined functions

Open the install.sql file in the ResourceKit/PLJava/9. x/OS / directory in a text editor. You will copy the contents of this file into the PostgreSQL tool in a later step.
In pgAdmin, select the database in which you plan to install PL/Java.
Open SQL query tool, paste the contents of the install.sql file into the pgAdmin editor.
Click Execute pgScript.
Verify that there are no error messages. If there is an error, check the library directory settings and restart the PostgreSQL service.

After successful completion of the script execution, you will see sqlj schema will be created with tables and views

postgreSQL pljava pega script execution for pega platform 8.5

How to Installing Pega Platform 8.5 with Tomcat and PostgreSQL

Step 7: Installing Pega Platform

Installing by using the Installation and Upgrade Assistant (IUA)

1.Double-click the PRPC_Setup.jar file to start the IUA.

2.Click Next to display the license agreement.

3.Review the license agreement and click Accept.

4.On the Installer Mode screen, choose Installation and click Next.

5.Choose your database type and click Next.

6.Choose Standard Edition and click Next.

7.Configure the database connection. The JDBC drivers allow the Pega Platform application to communicate with the database.

8.Click Test Connection. If the connection is not successful, review your connection information. Correct any errors, and retest. When the connection is successful, click Next.

9.System Name – Enter the name of your Pega Platform system.

10.Production Level – Enter a production level. The production level affects many security features of your system. Both the system name and production level can be changed after the system is running.

11.Click Start to begin loading the rulebase. Logs display in the log window and are also stored in the \scripts\logs directory.

pega platform 8.5 rulebase load complete

Click Back to return to the previous screen, and then click Exit to close the IUA.

Pega Platform IUA installation and upgrade assistent

Step 8: Configuring your application server

1.Ensure that your database JDBC jar file is accessible to Tomcat by saving it to the lib directory on your application server

pega platform jdbc driver jar file for pega platform installation

2.Open the context.xml file and locate the <context> element. You will add all Pega Platform entries to the <context> element.

pega tomcat server context xml file for pega platform 8.5

3.Save and close the context.xml file.

4.Start the server to make these changes effective.

Add the required roles, users, and passwords to the tomcat-users.xml file:

1.Open the tomcat-users.xml file in the Tomcat_home /conf/ directory.

2.Add the following lines anywhere in the file body:

3. Save and close the file.

Setting JVM parameters on Tomcat

•Initial Heap Size (Xms) — Between 4 GB

•Maximum Heap Size (Xmx) — Between 4 GB – 8 GB

Add a headless AWT setting to the Java options to allow the Pega Platform to render and display graphics

-Djava.awt.headless=true

In a single node cluster, set the node type to Universal

-DNodeType=Universal

pega tomcat java options configurations for pega platform installation 8.5

Step 9: Deploying the Pega Platform file prweb.war

1.Copy the prweb.war file from the \archives\ directory to the Tomcat_home\webapps\ directory.

2.Restart the application server.

3.Shut down the server and delete the prweb.war file from the Tomcat_home\webapps\ directory to prevent Tomcat from redeploying the application each time the server restarts.