Skip to main content
Question

Postgres Log files

  • February 14, 2017
  • 3 replies
  • 12 views

Forum|alt.badge.img

Good morning,

I have a FME Server job that runs a python caller. Part of this python caller is to run some sql in a postgres database. When I look in my fme job log I can see the step being called but I don't see any logging from the sql.

Is it possible to add the logging from the postgres log into the fme log?

3 replies

Forum|alt.badge.img+7

Hi @johnbyrnejb

I don't know a way to do this automatically - I don't think this is possible. Of course you can always write this functionality yourself since both log files are text-files and contain a timestamp. Merging them shouldn't be that hard.

Good luck!


david_r
Evangelist
  • February 14, 2017

I agree with @jeroenstiers.

But since you're already using Python you could look into what is possible using the psycopg2 module. Lots of possibilites there: http://initd.org/psycopg/docs/


Forum|alt.badge.img
  • Author
  • February 14, 2017

thanks @jeroenstiers and @david_r, I was being lazy and hoping there was an automatic way.


Reply


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