Getting Timed out after 10.0 s connecting postgresql database

Get Help
1

I have already using the Metabase for a long time. But currently, a 3rd party company has given me access to of there database which I am connecting to the metabase. But while connecting the PostgreSQL database to Metabase it is giving me the error Timed out after 10.0 s. This is the first time I am facing this encounter in Metabase.

Also, the same PostgreSQL connection is working on other analytics tools like Google Looker, Power BI, Apache Superset, etc. But not getting connected in the Metabase. I have Metabase self-hosted on my server.

Can anyone help me with this why this issue is coming in Metabase.

2

My System Diagnostic info is below

{
"browser-info": {
"language": "en-US",
"platform": "MacIntel",
"userAgent": "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/124.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.22+7",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.22",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.22+7",
"os.name": "Linux",
"os.version": "5.19.0-1029-aws",
"user.language": "en",
"user.timezone": "GMT"
},
"metabase-info": {
"databases": [
"postgres",
"h2",
"mysql"
],
"hosting-env": "unknown",
"application-database": "postgres",
"application-database-details": {
"database": {
"name": "PostgreSQL",
"version": "13.13"
},
"jdbc-driver": {
"name": "PostgreSQL JDBC Driver",
"version": "42.7.2"
}
},
"run-mode": "prod",
"version": {
"date": "2024-03-14",
"tag": "v0.49.0",
"hash": "46c668b"
},
"settings": {
"report-timezone": "Asia/Kolkata"
}
}
}

3

Are you sure you don't have to open some network ports? from your local computer are you able to connect to this postgres database using some other type of IDE like dbeaver

4

Check with the company itself if they have whitelisted your ip for connection or any other connection requirements are there except host port username and pass