Question

Postgres Log files

  • 14 February 2017
  • 3 replies
  • 7 views

Badge

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

Badge +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!

Userlevel 4

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/

Badge

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

Reply