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

From: Santosh Udupi <email(at)hitha(dot)net>
To: pgsql-novice <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?
Date: 2021-02-02 03:26:16
Message-ID: CACLRvHZC_yjXYu3euYmZUrDv7Jd9DygoJ+wtU1oOvy5rP+JsfA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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,

Browse pgsql-novice by date

  From Date Subject
Next Message Narendra Joshi 2021-03-07 18:15:18 Re: LEFT or RIGHT JOIN - can't see where I'm going wrong?
Previous Message Greg Rychlewski (LCL) 2021-02-01 01:48:29 Re: Explain Plan - Lower Estimated Time but Higher Cost