citusdata/pg_cron

connection failed

tranicus opened this issue · 1 comments

tranicus commented

Hello All, any advises?

I've tried updated the pg_hba:

"local" is for Unix domain socket connections only

local all all trust

I've tried: UPDATE cron.job SET nodename = '';

\dn+
List of schemas
Name | Owner | Access privileges | Description
--------------+-------------------+----------------------------------------+------------------------
cron | postgres | postgres=UC/postgres +|
| | partman_user=UC/postgres |
partman | postgres | postgres=UC/postgres +|
| | partman_user=UC/postgres |
partman_test | postgres | |
public | pg_database_owner | pg_database_owner=UC/pg_database_owner+| standard public schema
| | =U/pg_database_owner +|
| | partman_user=UC/pg_database_owner |

tranicus commented

I was missing cron.host = '' from pg_hba file.