Forum Discussion

willianmsantos's avatar
willianmsantos
Frequent Visitor
9 years ago
Solved

Postgresql: Exception while reading from stream

    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    
Need Help
  • willianmsantos's avatar
    willianmsantos
    8 years ago

     

    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!

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    kkk93
    Frequent Visitor
    1 year ago

    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.