BUG #17256: Running pgagent on a custom user

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.

Responses

Browse pgsql-bugs by date

  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