Hi i am new to postgres … I am trying to run a insert query with PGAgent by creating a job in my Postgres Database but it won’t work. If I copy the Statement and run it manually it works just perfect. Server OS is Centos. When I am trying to do the same in my local windows system it’s working fine.

I have installed postgresql with pgagent and a Scheduled a job. then I am trying to run the run job manually I am getting the error in event viewer