Connecting to a Postgres SQL Database Error

[Anonymous]

When connecting to a PostgresSQL database, I get the following error: 

Details: "An error happened while reading data from the provider: 'A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond'"

Here are the values I put in the connector widget: 

Server: acton1-act-8765.aivencloud.com

Database: defaultdb

Here are the connection details from my server: 

Database Name: defaultdb
Host: acton1-act-8765.aivencloud.com
Port: 18963
User: avnadmin

What am I doing wrong here? 

Thank you and have a great day!

[amitchandak · Accepted solution]

@Anonymous , Make sure you have not missed any step, including import of certificate

postgresql
https://community.powerbi.com/t5/Power-Query/Connecting-to-PostgresSQL-hosted-on-AWS-RDS/td-p/135666
https://dataintoresults.com/post/powerbi-and-postgresql-ssl-lets-encrypt-and-gateway/

[Anonymous]

@amitchandak - thank you! The ODBC connector solved this for me in your post. Much appreciated.