Skip to main content
Solved

Copying table from postgis to postgis as FME server job

  • April 27, 2018
  • 1 reply
  • 14 views

dollargis
Contributor
Forum|alt.badge.img+6

The task is to read a postgis table (fully qualified namespace.tablename) from one database and write it to another database into the same namespace and with the same tablename. Table name and namespace are not known beforehand but get submitted in the form namespace.tablename as a parameter at runtime

I have successfully created this JobSubmitter workspace:

which, according to this logfile runs successfully.

The server workspace postgis2postgis.fmw looks like this:

and when run, fails for reasons unknown to me. The server log is this:

I cannot figure what I've misconfigured here, so any help would be greatly appreciated.

Best answer by dollargis

Shame on me, but this works! I had made two mistakes:

* Switched off error logging

* and therefore not seen that I had forgotten to enable the postgis extension in the database

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

dollargis
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • Best Answer
  • April 27, 2018

Shame on me, but this works! I had made two mistakes:

* Switched off error logging

* and therefore not seen that I had forgotten to enable the postgis extension in the database