Solved

Copying table from postgis to postgis as FME server job

  • 27 April 2018
  • 1 reply
  • 1 view

Badge

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.

icon

Best answer by dollargis 27 April 2018, 16:52

View original

1 reply

Badge

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

Reply