Re: pgagent on linux

Dear support team

I found a hint in stack overflow: pgagent has to be created in the maintenance database (postgres par default).
So the job item occured and a new job was created in the postgres database.

Thank you and best regards
Elke

Gesendet von Mailspring (https://getmailspring.com/) der besten kostenlosen E-Mail-App für die Arbeit
On Juni 16 2020, at 6:58 pm, Elke Hofmann <info(at)elkehofmann(dot)net> wrote:
> Dear support team
>
> I am trying to install and run pgagent locally on linux mint 19.1 with postgresql 11 and pgadmin4.
> I added the extension to my database, the schema pgagent was created.
> In the tree view of pgadmin "pgagent Jobs" did not appear.
> After some attempts to start pgagent manually via pgagent <connectstring> "pgagent Jobs" appeared.
> I created a job, schedule, steps to write something into a table of this database, and it worked.
> But: the job and the jobsteps where NOT persisted in the tables in the schema pgagent, these remained empty.
> Schema pgagent is notabene visible in Navicat, NOT in pgadmin.
> I created another job via sql in the database (using Navicat). This hob worked, too.
> I need to be able to manipulate my schedules as well from pgadmin as from the database.
> A colleague of mine installed pgagent on WIndows and showed me the jobs written in the postgresql database.
>
>
> What was my mistake?
> Any help is highly appreciated.
> Best regards, Elke Hofmann