Thread: Pg_cron not working

Pg_cron not working

From
Rajesh Kumar
Date:
I have installed pg_cron but the schedule seems not to be working.

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

Re: Pg_cron not working

From
Erik Wienhold
Date:
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



Re: Pg_cron not working

From
Rajesh Kumar
Date:
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

Re: Pg_cron not working

From
Marian Wendt
Date:
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

The answer is in link number two ([2]) in Eric's email.

--
regards, marian wendt