Re: pgagent

I don't think that most of them are related to pgagent, since they are
coming anyway (I suppose it's about pgadmin's Dashboard).
There is just one that I think it's about "Run now" :

... EET postgres postgres [2104]LOG: statement: UPDATE pgagent.pga_job SET
jobnextrun=now()::timestamptz WHERE jobid=1::integer

but that's just about it !
Is there any way I can test that pgagent it's able to start a job ?

Regards,
Gabi

On Fri, Nov 6, 2020 at 6:41 PM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 11/6/20 8:12 AM, Gabi Draghici wrote:
> >
> > It't not a daemon yet (I started manually) but yes, it's running :
> >
> > postgres(at)dbdocs:~> ps aux | grep postgresql
> > postgres 2093 0.0 0.3 8720088 218280 ? Ss 17:54 0:00
> > /usr/lib/postgresql12/bin/postgres -D /opt/postgresql/database
> > postgres 2315 0.0 0.0 64664 5708 pts/2 S 17:57 0:00
> > /usr/bin/postgresql12-pgagent hostaddr=10.1.0.4 dbname=postgres
> > user=pgagent -s /opt/postgresql/pglog/pg_agent.log
> > postgres 2326 0.0 0.0 8696 820 pts/2 S+ 17:57 0:00 grep
> > --color=auto postgresql
>
> >
> > I've switched log_statement to 'all' and restarted the DB. All I see
> > it's a bunch of statements like these :
> >
> > 2020-11-06 18:07:03.869 EET postgres pgagent [2316]LOG: statement:
> > SELECT J.jobid FROM pgagent.pga_job J WHERE jobenabled AND
> > jobagentid IS NULL AND jobnextrun <= now() AND (jobhostagent = ''
> > OR jobhostagent = 'dbdocs-prd') ORDER BY jobnextrun
> > 2020-11-06 18:07:04.466 EET postgres postgres [2104]LOG: statement:
> > /*pga4dash*/
>
> The above is from when you click 'Run now'?
>
> >
> > Regards,
> > Gabi
> >
> >
> >
> >
> >
> >
> >
>
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>