Postgresql: Exception while reading from stream

[willianmsantos]

Hello Dear Community!

Has anyone ever got this message while trying to connect to a Postgre DB? What was the workaround? 

Thanks in advance!

Will

[aldoresendiz]

In my case the problem was that I misspelled the name of my database...The name is defined as XXXXDb and I was passing XXXXDB.

[Anonymous]

Go to Edit Queries->Advanced Editor-> add timeout in the connection

Source = PostgreSQL.Database("server_name", "database_name", [CommandTimeout=#duration(5, 0, 0, 0)]),

[kkk93]

Does this step have to be done for all the tables? Or is this there a way where I can apply this timeout to all the tables? Once I open the advanced editor, it has the query for that particular table which is open.

[Anonymous]

This error may happen when connection string is lacking port number. Try using server:port in connection string to Postgres database.

[pehesarani]

How to do that? 

I have the same problem. I can't connect Postgres DB to Power BI 😥

[Anonymous]

Hi @willianmsantos,

I'd like to suggest you setting the 'Timeout' parameters and try again, it may fix the issue.

Reference link:

PostgreSQL.Database

Regards,

Xiaoxin Sheng

[willianmsantos · Accepted solution]

Hello Community!

That was definelty some firewalls dropping packages between the server I have the client installed and the database. I asked firewall team to open the route between source and destination and It worked properly.

Thanks for your insights!

[maxianren]

how to "open the route between source and destination"? could you please give me some details? thanks

[Jake_Roesler]

Bad news. This may well be the first of many errors you'll get trying to connect to a Postgresql data source. 

I've been banging my head against a Certificate error for a week. 

[willianmsantos]

That's sad, I've spent most of day yesterday struggling over this issue. I hope to get back with some good news. 🙂