Thread
#secoda-support
    b

    big-coat-23982

    11 months ago
    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 not connect to server: Connection timed out
    	Is 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.
    e

    elegant-house-93198

    11 months ago
    Happy to hear!