Question

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"
Below DB details are extracted from context xml
<Resource name="jdbc/PegaRULES"
auth="Container"
type="javax.sql.DataSource"
maxTotal="300"
maxIdle="50"
maxWait="10000"
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"
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
Additional Configuration Steps to Connect to Postgres through VM.docx
Please elaborate the process of postgre DB access.