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@xxxxxxxxxxx
