How do i connect quicksight to postgres hosted on aws lightsail instance?

Question & Answer
,
11

@Neeraj @Kristin
Besides network security, There is also a problem connecting to postgresql >= 14

ref: PostgreSQL 14+ support
Is there any update on that?

Currently, I have below in my pg_hba.conf (if scram-sha-256 is still not supported on postgres, :speak_no_evil:)

host    all             quicksight           52.66.193.64/27    md5

server configuration

ssl = on and ssl_min_protocol_version=TLSv1.2

I have tried with md5 and scram-sha-256; In both case I am getting this error on quicksight.

region: ap-south-1
timestamp: 1718097082394
requestId: bcbd106e-6bd3-4f46-bbf9-9e8e93c0bf65
sourceErrorCode: SSL_CERT_VALIDATION_FAILURE
sourceErrorMessage:  
`SSL error`: 
    PKIX path building failed: `sun.security.provider.certpath.SunCertPathBuilderException`: unable to find valid certification path to requested target

And on the Postgresql server side, I am getting the below error

LOG:  could not accept SSL connection: sslv3 alert certificate unknown
LOG:  could not accept SSL connection: wrong version number
HINT:  This may indicate that the client does not support any SSL protocol version between TLSv1.2 and TLSv1.3.

Any suggestion?

thanks
Neelay