Thread: Pg_cron not working

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

There is already an entry for 

all all MD5. 

On top of that , how do I add trust ?

On Thu, 21 Sept 2023, 15:55 Erik Wienhold, <ewie@ewie.name> wrote:

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