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 <i...@elkehofmann.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

Reply via email to