pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17256: Running pgagent on a custom user
2+ messages / 2 participants
[nested] [flat]
* BUG #17256: Running pgagent on a custom user
@ 2021-10-29 09:11 PG Bug reporting form <noreply@postgresql.org>
2021-10-29 15:55 ` Re: BUG #17256: Running pgagent on a custom user David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2021-10-29 09:11 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: daniel.rybakiewicz@raben-group.com
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #17256: Running pgagent on a custom user
2021-10-29 09:11 BUG #17256: Running pgagent on a custom user PG Bug reporting form <noreply@postgresql.org>
@ 2021-10-29 15:55 ` David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: David G. Johnston @ 2021-10-29 15:55 UTC (permalink / raw)
To: daniel.rybakiewicz@raben-group.com <daniel.rybakiewicz@raben-group.com>; pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
On Friday, October 29, 2021, PG Bug reporting form <noreply@postgresql.org>
wrote:
> 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.
>
The project (core PostgreSQL) this list is maintained by does not develop
the pgagent application. You should search out and post your questions to
whatever support forum is provided by it’s authors.
David J.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2021-10-29 15:55 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-10-29 09:11 BUG #17256: Running pgagent on a custom user PG Bug reporting form <noreply@postgresql.org>
2021-10-29 15:55 ` David G. Johnston <david.g.johnston@gmail.com>
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