Cron job execution requires login permission
- 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.