Hi,
I have installed postgresql 12 on sles 15 for some tests. Now I'm
interested in some sort of scheduler and from what I've read so far,
pgagent should do the job. So I've installed pgagent 4.0. I've added a job
(which I can see in pgagent.pga_job) but everytime I ran it (from pgadmin)
nothing h
2020 at 11:34 PM Adrian Klaver
wrote:
> On 11/5/20 1:07 PM, Gabi Draghici wrote:
> >
> > Hi,
> >
> > I have installed postgresql 12 on sles 15 for some tests. Now I'm
> > interested in some sort of scheduler and from what I've read so far,
> >
stat_database) AS "Deletes"
) t
UNION ALL
SELECT 'to_stats' AS chart_name, row_to_json(t) AS chart_data
FROM (SELECT
(SELECT sum(tup_fetched) FROM pg_stat_database) AS "Fetched",
(SELECT sum(tup_returned) FROM pg_stat_database) AS "Returned"
) t
UNION ALL
xtrun=now()::timestamptz WHERE jobid=1::integer
but that's just about it !
Is there any way I can test that pgagent it's able to start a job ?
Regards,
Gabi
On Fri, Nov 6, 2020 at 6:41 PM Adrian Klaver
wrote:
> On 11/6/20 8:12 AM, Gabi Draghici wrote:
> >
> > I
My bad !
I didn't read the documentation too well ... and completed the 'Host agent'
with the IP instead of the hostname !
The job it's running now.
Thank you for help !
Regards,
Gabriel
On Sat, Nov 7, 2020 at 1:29 PM Gabi Draghici
wrote:
>
> I don't thin
