cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

PostGreSql connectivity

vbetharasi
New Contributor

Hi,
While trying to connect PostgreSQL using JDBC getting below error.
image .

Could you please help to resolve this issue.

Thanks in advance!

Thanks,
Venu

5 REPLIES 5

vbetharasi
New Contributor

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

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

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

Many thanks !

Itโ€™s now working