I have set up pgagent on my postgres 12 server. When I run
/usr/bin/pgagent -f -l 2 host=localhost port=5432 user=pgagent dbname=postgres password=pg-please-work
I get this error
Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?
What am I doing wrong?
Thank you,