we are having challenges in connecting to postgresql db from ca lisa , Do we need any additional drivers for this. If yes How can we add them
Thanks in advance,
This error looks is related to configuration changes required in PostgreSQL server. Please look at this below link for this error. Where they suggested to do changes in pg_hba.conf file on database.
You can download PostgreSQL JDBC driver from URL: PostgreSQL JDBC Download , Once you got the JDBC jar file, place this jar file in <LISA_HOME>/hotdeploy folder and restart the LISA component to reflect these changes (Verify the log file, to see this jar file has added in classpath).
After loading this driver, you can use Drivername in test case as: org.postgresql.Driver, Database URL as: jdbc:postgresql://hostname:port/dbname
Please try these steps from LISA
Hi Srikanth ,
Thanks for the quick info. I have downloaded the postgresql driver and also placed it it HOT_Deploy folder.
When i'm trying to test the connection to green plum db using postgresql its saying password authentication failed even though i'm providing accurate credentials.
I have re verified the connection string as well and they were accurate.
Please help me in resolving this.
Could you please share us the screenshot of the error, as it would be helpful for us to debug.
Hi Abhishek , Srikanth
PFB for the Error message encountered
Retrieving data ...