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

Postgres Extract fails to refresh in Tableau Cloud 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

Cause

A potential cause is that changes in the primary Postgres database can trigger cleanup in the standby Postgres database, which cancels affected queries on the standby.