Postgres Pro
Downloads
Home   >   mailing lists

Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database? - Mailing list pgsql-novice

From Santosh Udupi
Subject Could not find the table 'pgagent.pga_job'. Have you run pgagent.sql on this database?
Date
Msg-id CACLRvHZC_yjXYu3euYmZUrDv7Jd9DygoJ+wtU1oOvy5rP+JsfA@mail.gmail.com
Whole thread Raw
List pgsql-novice
Tree view
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,

pgsql-novice by date:

Previous
From: "Greg Rychlewski (LCL)"
Date:
Subject: Re: Explain Plan - Lower Estimated Time but Higher Cost
Next
From: Simon Connah
Date:
Subject: Is it better keep most logic in the database or the Node.js application?