Re: pgagent

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@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.klaver@aklaver.com