KNOWLEDGE BASE

Error "Connection timed out. Is the server running ... and accepting TCP/IP connections" Refreshing Postgres Extract


Published: 17 Jan 2017
Last Modified Date: 06 Jul 2017

Issue

Postgres Extract fails to refresh in Tableau Online with the following error:
Connection timed out
Is the server running on "server name" (ip address) and accepting TCP/IP connections on port xxxx?
Unable to connect to the server "server name". Check that the server is running and that you have access privileges to the requested database.


Additionally, when trying to connect to the Postgres data source on Tableau Desktop, the following error occurs:
Canceling statement/ terminating connection due to conflict with recovery.
User query might have needed to see row versions that must be removed.
Error fetching next row

Environment

  • Tableau Online
  • Tableau Desktop
  • Postgres

Cause

Changes in the primary Postgres database can trigger cleanup in the standby Postgres database, which cancels affected queries on the standby.
Did this article resolve the issue?