pgagent on linux

From: Elke Hofmann <info(at)elkehofmann(dot)net>
To: pgadmin-support(at)lists(dot)postgresql(dot)org <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgagent on linux
Date: 2020-06-16 16:58:43
Message-ID: 9AD9C894-0D61-46BB-B85A-8F1A79029B4D@getmailspring.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Elke Hofmann 2020-06-16 19:07:40 Re: pgagent on linux
Previous Message cgerard999 2020-06-15 11:00:48 Keyboard shortcut not working on French keyboards