From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | daniel(dot)rybakiewicz(at)raben-group(dot)com |
Subject: | BUG #17256: Running pgagent on a custom user |
Date: | 2021-10-29 09:11:02 |
Message-ID: | 17256-71bc9db5cddadad6@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 17256
Logged by: Daniel Rybakiewicz
Email address: daniel(dot)rybakiewicz(at)raben-group(dot)com
PostgreSQL version: 13.4
Operating system: Redhat 8
Description:
Good morning,
I am trying to run PGAGENT on a user other than POSTGRES.
I did:
1.drop extension pgagent (on postgres user)
2.create extensions pgagent (on pgjobs users)
3. I've set up the .pgpass file
4. I have set up the /etc/pgagent/pgagent_13.conf file
DBNAME = pgjobs
DBUSER = pgjobs
DBHOST = 127.0.0.1
DBPORT = 5432
when I'm logged in as a PGJOBS user in PGADMIN, I don't see the "pgagent
jobs" option. I only see it if I create an extension on the postgres user
and the goal is to create this on a custom user.
In addition, when I look in the schemas on the pgjobs user, PGADMIN I do not
see the PGAGENT scheme. When it searches for a list of schemas from SQL,
this schema exists.
As I did drop extension pgagent, the scheme appeared in PGADMIN.
Please let me know how I can use PGAGENT in PGADMIN on a custom database
user.
From | Date | Subject | |
---|---|---|---|
Next Message | Noah Misch | 2021-10-29 11:57:25 | Re: conchuela timeouts since 2021-10-09 system upgrade |
Previous Message | Herman verschooten | 2021-10-29 08:47:34 | Re: ERROR: posting list tuple with 20 items cannot be split at offset 168 |