Обсуждение: Pg_cron not working
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?
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
There is already an entry forall 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
regards, marian wendt