10-14-2019 12:31 AM
Hi,
While trying to connect PostgreSQL using JDBC getting below error.
.
Could you please help to resolve this issue.
Thanks in advance!
Thanks,
Venu
10-14-2019 03:13 AM
Hi,
I don’t understand what is the exact issue. Can any one help here please as this is on priority . It’s very urgent
Thanks,
Venu
10-15-2019 12:59 AM
Hi, can you try this:
When connecting to an SSL enabled PostgreSQL account, the account fails in validation. To overcome this, configure the URL properties in Account settings to establish an SSL connection with the following parameter and value:
URL property name | URL property value |
---|---|
sslmode | require |
or try
URL property name: ssl
Value: true
10-15-2019 06:07 AM
Hello Venu,
Your screenshot shows the “Min pool size” was reduced from the default value of 3 to 0. Can you return that value back to the default value then try again?
Documentation link for PostgreSQL account:
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/1438860/PostgreSQL+Account
10-16-2019 03:11 AM
Many thanks !
It’s now working