citusdata / pg_cron

Run periodic jobs in PostgreSQL
PostgreSQL License
2.9k stars 195 forks source link

connection failed #321

Closed tranicus closed 7 months ago

tranicus commented 7 months ago

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 7 months ago

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