From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: daniel.rybakiewicz@raben-group.com
Subject: BUG #17256: Running pgagent on a custom user
Date: Fri, 29 Oct 2021 09:11:02 +0000
Message-ID: <17256-71bc9db5cddadad6@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17256
Logged by: Daniel Rybakiewicz
Email address: daniel.rybakiewicz@raben-group.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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, daniel.rybakiewicz@raben-group.com
Subject: Re: BUG #17256: Running pgagent on a custom user
In-Reply-To: <17256-71bc9db5cddadad6@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox