citusdata / citusdata/pg_cron

When edit a job it does not edit host

Open
#199 2 comments 0 reactions 0 assignees View on GitHub
Dominant language
C
Stars
3.9k
Forks
260
Avg merge
5d 5h
Merged PRs (30d)
1

Description

Hi,

Firstly I used default "cron.host" setting but I had a "connection error". I changed my "cron.host" parameter to "/var/run/postgresql".
Of course, I restart afterwards and check parameters:

```
postgres=# select name, setting from pg_settings where name like '%cron%';
name | setting
-----------------------------------+---------------------
cron.database_name | postgres
cron.enable_superuser_jobs | on
cron.host | /var/run/postgresql
cron.log_min_messages | warning
cron.log_run | on
cron.log_statement | on
cron.max_running_jobs | 32
cron.use_background_workers | off
(8 rows)
```

Then, I tried to renew my job but I only updated command and schedule. If a jobid/jobname exists and if we refresh the job, it is better to refresh other parameters I think. What do you think?

I solved my issue unschedule and schedule it again.

Thanks!

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.