Postgres Pro
Downloads
Home   >   mailing lists

Thread: Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?

Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?

From
Santosh Udupi
Date:
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,