Re: Pg_cron not working

From: Marian Wendt <marian(dot)wendt(at)yahoo(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Pg_cron not working
Date: 2023-10-05 05:42:29
Message-ID: 57ab4200-e8e8-4cb3-aaf3-f7a7f02ffcd4@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> 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(at)ewie(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Benjamin Acquaye 2023-10-05 17:48:45
Previous Message Rajesh Kumar 2023-10-05 04:07:56 Re: Pg_cron not working