pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPg_cron not working
4+ messages / 3 participants
[nested] [flat]
* Pg_cron not working
@ 2023-09-21 08:22 Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-21 10:25 ` Re: Pg_cron not working Erik Wienhold <ewie@ewie.name>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar @ 2023-09-21 08:22 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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?
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron not working
2023-09-21 08:22 Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-09-21 10:25 ` Erik Wienhold <ewie@ewie.name>
2023-10-05 04:07 ` Re: Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
0 siblings, 1 reply; 4+ messages in thread
From: Erik Wienhold @ 2023-09-21 10:25 UTC (permalink / raw)
To: Rajesh Kumar <rajeshkumar.dba09@gmail.com>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron not working
2023-09-21 08:22 Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-21 10:25 ` Re: Pg_cron not working Erik Wienhold <ewie@ewie.name>
@ 2023-10-05 04:07 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-10-05 05:42 ` Re: Pg_cron not working Marian Wendt <marian.wendt@yahoo.com>
0 siblings, 1 reply; 4+ messages in thread
From: Rajesh Kumar @ 2023-10-05 04:07 UTC (permalink / raw)
To: Erik Wienhold <ewie@ewie.name>; +Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Pg_cron not working
2023-09-21 08:22 Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-21 10:25 ` Re: Pg_cron not working Erik Wienhold <ewie@ewie.name>
2023-10-05 04:07 ` Re: Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
@ 2023-10-05 05:42 ` Marian Wendt <marian.wendt@yahoo.com>
0 siblings, 0 replies; 4+ messages in thread
From: Marian Wendt @ 2023-10-05 05:42 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
> 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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-10-05 05:42 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-09-21 08:22 Pg_cron not working Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-09-21 10:25 ` Erik Wienhold <ewie@ewie.name>
2023-10-05 04:07 ` Rajesh Kumar <rajeshkumar.dba09@gmail.com>
2023-10-05 05:42 ` Marian Wendt <marian.wendt@yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox