I made an integration with a Postgres database, I can see the tables were successfully extracted under Catalog, however when I try to run a simple query (
select * from matchs limit 1;
) under Analysis I’m getting a pretty generic error I think passed through from SQLAlchemy.
Error from Query Engine
(psycopg2.OperationalError) could notconnecttoserver: Connection timed outIs the server running on host "35.236.89.200" and accepting
TCP/IP connections on port 5432?
(Background on this error at: <http://sqlalche.me/e/e3q8>)
e
elegant-house-93198
11 months ago
Hi Mark, you need to whitelist the IP address
54.175.53.193/32
on your Postgres database. I missed updating the Postgres documentation here.
The extractions are run on a different service than the analysis query engine, which is why you need to whitelist both addresses.
b
big-coat-23982
11 months ago
Perfect. Works now. Thanks. Figured it was something like that.
