citusdata / citusdata/pg_cron

Cron job execution requires login permission

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

Description

I'm getting the following error message when trying my cron job tries to execute:
```
postgres_1 | 2021-06-04 08:57:00.006 UTC [32] LOG: cron job 3 starting: CALL my_proc('foobar')
postgres_1 | 2021-06-04 08:57:00.020 UTC [55] FATAL: role "group.readwrite" is not permitted to log in
postgres_1 | 2021-06-04 08:57:00.021 UTC [32] LOG: cron job 3 connection failed
```
The cron job runs fine if I add login permission to the user with which the job executes .
However, I'm trying to adhere to the principle of least-privilege, so I'd prefer not to add the login permissions.

Would it be possible to change this extension to allow running cron jobs with user accounts that don't have login permission?

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.