Re: pgagent
| От | Henry Francisco Garcia Cortez |
|---|---|
| Тема | Re: pgagent |
| Дата | |
| Msg-id | CAJP2v3FNa1QevCwrGk-KiS4W7JLOyrDcJ6YTaOdidWJmw+1V=Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pgagent (Paul Förster <paul.foerster@gmail.com>) |
| Список | pgsql-admin |
Thanks, I'll check it out.
El mar., 6 oct. 2020 a las 23:56, Paul Förster (<paul.foerster@gmail.com>) escribió:
Hi Henry,
> On 06. Oct, 2020, at 23:46, Henry Francisco Garcia Cortez <garcortez@gmail.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
В списке pgsql-admin по дате отправления: