Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Barathi Priyan Ganesan (BarathiPriyanG)
HCL Technologies Ltd.

HCL Technologies Ltd.
NL
BarathiPriyanG Member since 2012 5 posts
HCL Technologies Ltd.
Posted: Nov 25, 2017
Last activity: Nov 27, 2017
Posted: 25 Nov 2017 17:58 EST
Last activity: 27 Nov 2017 7:14 EST
Closed
Solved

Connection Issues in LSA71 PVS Instance to PostGres DB

Hi All,

I was working on the PVS Instance provided with LSA7.1 for quite sometime. I was trying to connect with the DB.

Since there is no connection details provided anywhere other than username and password. I have tried different combinations but i am unable to connect.

I am using pgAdmin 4 as recommended in the course. I have also searched for conf file in the location /opt/tomcat/conf and not able to find the correct details.

Please find the below screenshot. Kindly let me know if you have any inputs on this.

Regards,

Barathi Priyan

To see attachments, please log in.
Data Integration

Accepted Solution

Posted: 7 years ago
Posted: 27 Nov 2017 7:13 EST
Barathi Priyan Ganesan (BarathiPriyanG)
HCL Technologies Ltd.

HCL Technologies Ltd.
NL

Received an error that the specified host is not in pg_hba.conf.

I have added the below entry manually in pg_hba.conf. Now I am able to connect.

host  all  all   Proprietary information hidden/0  trust

Related Content:https://collaborate.pega.com/discussion/pega-717-pvs-database-connection-details

To see attachments, please log in.
Posted: 7 years ago
Posted: 25 Nov 2017 18:05 EST
Barathi Priyan Ganesan (BarathiPriyanG)
HCL Technologies Ltd.

HCL Technologies Ltd.
NL

Also tried with details as below provided in context.xml. Still no luck.

In postgres, I don't have option to provide JDBC URL directly :(

 
<Resource name="jdbc/PegaRULES"
  auth="Container"
  type="javax.sql.DataSource"
  driverClassName="org.postgresql.Driver"
  url="jdbc:postgresql://XYZ.0.0.1:ABCD/pega"
  username="pega"
  password="pega"
  initialSize="11"
  maxActive="100"
  maxIdle="30"
  maxWait="10000"
/>
To see attachments, please log in.

Accepted Solution

Posted: 7 years ago
Posted: 27 Nov 2017 7:13 EST
Barathi Priyan Ganesan (BarathiPriyanG)
HCL Technologies Ltd.

HCL Technologies Ltd.
NL

Received an error that the specified host is not in pg_hba.conf.

I have added the below entry manually in pg_hba.conf. Now I am able to connect.

host  all  all   Proprietary information hidden/0  trust

Related Content:https://collaborate.pega.com/discussion/pega-717-pvs-database-connection-details

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice