Re: Pg_cron not working

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Rajesh Kumar <rajeshkumar(dot)dba09(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Pg_cron not working
Date: 2023-09-21 10:25:31
Message-ID: 3uz7ukefhsf3fho4q33adsczgdi4tzfuwhecgdooxtwrohufkh@e77ufwbtxadx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 2023-09-21 13:52 +0530, Rajesh Kumar wrote:
> I have installed pg_cron but the schedule seems not to be working.

How did you install it? What have you configured so far?

> Anybody knows, how to configure pg_hba.conf for pg_cron to work?

The readme says you may have to enable trust authentication [1] and the
pg_hba.conf docs [2] have examples for that.

[1] https://github.com/citusdata/pg_cron#ensuring-pg_cron-can-start-jobs
[2] https://www.postgresql.org/docs/current/auth-pg-hba-conf.html

--
Erik

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message OS DB2 2023-09-22 12:33:34 Corruption issue
Previous Message Rajesh Kumar 2023-09-21 08:22:25 Pg_cron not working