Question

1
Replies
3954
Views
BrahmeswaraRao Member since 2016 37 posts
Posted: February 27, 2016
Last activity: August 26, 2020
Closed
Solved

How to access  DB schema on PRPC Personal Edition -7.2

Hi,

I would like to access the DB schema to create a custom work table of work class.

I see ,Postgre DB is being used as pegarule database for personal edition. Is it being configured with split schema or single schema ? if it's split schema then how to access them .

I started pgAdmin III(pgsql/bin),but unable to add new schema to it as most of the fields are in read only . trying to add new server as mentioned below then it's throwing an error like mentioned service is not found"

Postgre.jpg

Below DB details are extracted from context xml

  <Resource name="jdbc/PegaRULES"

              auth="Container"

              type="javax.sql.DataSource"

              maxTotal="300"

              maxIdle="50"

              maxWait="10000"

              driverClassName="org.postgresql.Driver"

              url="jdbc:postgresql://localhost:5432/pega"

              username="pega"

              password="pega"/>

  

Note : Server is not connected through VM as it has been installed in local machine.

PRPC version : Pega 7.2 .

I had gone through the couple of articles,which are posted on PDN but still i couldn't get it properly.

https://pdn.pega.com/forums/senior-system-architect-71/connecting-postgres-database

Re: Hi , I am new for this pega prpc, while installing prpc software ---- Unable to connect to database -- here what i have to do , please help me

Additional Configuration Steps to Connect to Postgres through VM.docx

Please elaborate the process of postgre DB access.

Data Integration Low-Code App Development Installation and Deployment System Administration Low-Code App Development Upgrades
Moderation Team has archived post
Share this page LinkedIn