 |
| How to access Pega 7 PostgreSQL with pgAdmin 4 |
For Purpose of this educational video, we are using Pega Platform Personal Edition version 7.4
Pega Platform Personal Edition, already has PostgreSQL pgAdmin 4 installed.
If you are not using Pega Personal Edition, you may need to Download and install postgre SQL pgAdmin 4 in your computer.
Steps to access Pega 7 PostgreSQL DB with pgAdmin 4
Follow below steps to access Pega postgreSQL Database
Step 1 - Start Pega Platform Personal Edition
To access postgre SQL with pgAdmin 4, first of all start your Pega Personal edition server. This will start tomcat server and Postgre SQL database server.Step 2 - Run pgAdmin 4 from Pega Persona Edition installation Directory
Now go to installation directory of Pega. You will see pgsql folder. On opening this folder you will find PG Admin 4 folder. Start pgAdmin4.exe file.Step 3 - Create Database server connection
Once pgadmin will start. On left hand side find servers. Right click servers. Click create and then click server. A new window will pop up.Enter any Name to this server. Then Click on Connections tab.
Enter Host name or IP address of the server you want to connect. Here I am connecting on local host. Database port number is what you have configured while Pega Installation.
Default database port is 5432 and Username password both are Postgres. Click save to finish the set up.
Step 4 - Verify Pega database server connection
Now on Left hand side, Click on servers. You will find name of server you have configured.After click on your connection name, click on databases. It will show database name postgres. Expand postgres, it will show component of postgres database. on expanding schemas, you can find rules and data schemas.
Expanding rules schema and further exapand Tables. It will show list of tables in rules schema.
Similarly Expand data schema and tables in that. You will see list of tables in Data schema.
 |
| Steps to access Pega Database using pgAdmin 4 |
0 Comments