Question

connection timed out error: Postgres

  • 24 November 2021
  • 1 reply
  • 31 views
L
Badge

I am trying to convert an old script that loads 100+ tables in Postgres to a FME Server automation. One of the things I am doing is a

INSERT INTO schema1.table SELECT * FROM schema2.table

with a SQLExecutor where schema2 is a Oracle foreign table. This works fine for some smaller tables, but for a large table around 33gb I eventually receive a 'could not receive data from server: Connection timed out' error whether I run it on desktop or server. This worked fine when run from the script. I'm at a loss here, what could be causing the problem?

1 reply

marcyeranos
Rank
Badge

Hello, have you figured it out? If not yet, I think there will be a timeout settings. The Postgres server or the FME Server may have a connection timeout setting that is too low. An alternative is to create a spatial index if this is not the case.

Reply


Community Stats

28,669
Posts
109,358
Replies
36,531
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.