Re: pgagent

Thanks, I'll check it out.

El mar., 6 oct. 2020 a las 23:56, Paul Förster (<paul(dot)foerster(at)gmail(dot)com>)
escribió:

> Hi Henry,
>
> > On 06. Oct, 2020, at 23:46, Henry Francisco Garcia Cortez <
> garcortez(at)gmail(dot)com> wrote:
> >
> > hello on pgadmin4 every five seconds this query repeat SELECT J.jobid
> FROM pgagent.pga_job J WHERE jobenabled AND jobagentid IS NULL AND
> jobnextrun <= now() AND (jobhostagent = '' OR jobhostagent = 'grafana')
> ORDER BY jobnextrun my problem is I enable logs of postgresql on log is
> written
>
> maybe you take a look at your logging parameters. You may especially set:
>
> log_statement = ddl # or none
> log_min_messages = warning
> log_min_error_statement = error
>
> See: What to Log
>
> https://www.postgresql.org/docs/current/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHAT
>
> Cheers,
> Paul

--
Ing. Henry G. Cortez