citusdata / citusdata/pg_cron

pg_cron uses wrong certificate for authentification

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

Description

Hello,
we set up our postgres db to work with certificates as authentification instead of password.
This works perfectly fine beside the pg_cron.

The error message we get is:
`provided user name (pgcron_user) and authenticated user name (postgres) do not match`
For me it looks like the pg_cron user is not really used to execute the jobs, because postgres try to verify the user name with the certificate from the postgres user.

Our configuration:

For postgres user, certificates with the CN postgres
/home/postgres/.postgres/postgresql.crt
/home/postgres/.postgres/postgresql.crt
pg_hba entry:
hostssl db postgres 192.168.5.5/32 cert

For pg_cron, certificates with the CN pgcron_user
/home/pgcron_user/.postgresql/postgresql.crt
/home/pgcron_user/.postgresql/postgresql.key
pg_hba entry:
hostssl db pgcron_user 192.168.5.5/32 cert

The jobs are configured with nodename 192.168.5.5 and username: pgcron_user

Any hints or ideas what I can do or check?
Do you need more informations?
Is there a way to set the path to the certificates for pg_cron?

Regards and thx for any help,
Yufiel

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.