Re: pgagent on linux - Mailing list pgadmin-support
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, der besten kostenlosen E-Mail-App für die Arbeit
On Juni 16 2020, at 6:58 pm, Elke Hofmann <info@elkehofmann.net> wrote:
Dear support teamI 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
pgadmin-support by date: