Error with Postgres Database Authentication with Data Studio

2
votes

I am trying to connect my postgres database to Data Studio and I received the following error:

Sorry, we encountered an error and were unable to complete your request. Error ID:1b7b6c50.

I entered in the same credentials that I used (successfully) when I connected my postgres database to Tableau, and I can't seem to figure out what the issue is.

 Host Name or IP: localhost
 Port: 5432
 Database: WU
 Username: postgres
 Password: [my correct password]

While troubleshooting, I also tried entering in 1 ::1 and :1 for the host name, and got the same error. However, when I entered local as the host name, it seemed like Data Studio did some thinking before shooting me a different error. The new error said:

Can't reach the host. Please double check your connection parameters. Learn more about database connectors here.
Error ID: 079b22f8"

Does anyone have an explanation as to what is going wrong here?

1
postgresqlgoogle-data-studio
Give it a try with host=127.0.0.1 which is the same thing as localhost - Slumdog
try 127.0.0.1 or configure the pg_hba.conf and change ipv4 address to 0.0.0.0:0 and postgres should listen to accept connection - dwir182
AFAIK google datastudio is cloud solution, so it don't understand localhost or 127.0.0.1. Or there is some desktop app? - Zufar Muhamadeev
Thank you @Slumdog I tried entering your suggestion, but I got the same error as before "Sorry, we encountered an error and were unable to complete your request." - datadish
Thank you for the suggestion @dwir182. Would you be able to provide more details about how I should go about this? I read postgres's documentation about the pg_hba.conf file and found this article that mentioned making a backup copy of it before altering it (desktop.arcgis.com/en/arcmap/latest/manage-data/…) but I want to make sure doing so won't break the connection I already have set up with Tableau (or cause other unexpected issues for me). Thanks! - datadish

1 Answers

0
votes

You need to whitelist some ips inorder for google data studio to connect to postgres. Here's the google support