Skip to main content
Solved

Copying table from postgis to postgis as FME server job

  • April 27, 2018
  • 1 reply
  • 7 views

dollargis
Contributor
Forum|alt.badge.img+1

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

View original
Did this help you find an answer to your question?

1 reply

dollargis
Contributor
Forum|alt.badge.img+1
  • 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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings