Alex had used localhost as the server, but PostgreSQL was on a remote host. Worse, the firewall blocked port 5432. After opening the port and using the correct IP, the connection test succeeded.
Alex had downloaded the 64-bit driver, but Tableau was running in 32-bit mode on that machine. ODBC drivers are not interchangeable between bitness. postgres odbc download
A Guide to PostgreSQL ODBC: Drivers, Installation, and Connectivity Alex had used localhost as the server, but
Unlike some commercial database vendors that provide a unified installer for all their tools, PostgreSQL maintains a modular approach. You typically download the driver separately from the main database server software. postgres odbc download
During DSN setup, Alex saw two driver names:
: Binary formats (installers) for various platforms are hosted on the PostgreSQL downloads site .