From: | PG Bug reporting form <noreply(at)postgresql(dot)org> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Cc: | shiwangini(dot)shishulkar(at)webgility(dot)com |
Subject: | BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su |
Date: | 2019-06-28 10:00:52 |
Message-ID: | 15880-845b4af7ec0bf949@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: 15880
Logged by: Shiwangini Shishulkar
Email address: shiwangini(dot)shishulkar(at)webgility(dot)com
PostgreSQL version: 11.3
Operating system: CentOS Linux release 7.6.1810 (Core)
Description:
To implement scheduling, we need use pgagent. For that, extension from
'https://ftp.postgresql.org/pub/pgadmin/pgagent/pgAgent-4.0.0-Source.tar.gz'.
And unzipped it to the location, from where it picks. Now, connected to sql
prompt as tried to create extension as per below:
[root(at)localhost pgAgent-4.0.0-Source]# su - postgres -c "psql"
psql (11.3)
Type "help" for help.
postgres=# \c postgres
You are now connected to database "postgres" as user "postgres".
postgres=# CREATE EXTENSION pgagent;
ERROR: extension "pgagent" has no installation script nor update path for
version "${MAJOR_VERSION}.${MINOR_VERSION}"
The last line error message i received which i'm not able to interpret.
Could you please help me with this. Any help will be appreciated. Also, if
there is any another way to configure/use pgagent then please share us the
link of doc.
From | Date | Subject | |
---|---|---|---|
Next Message | PG Bug reporting form | 2019-06-28 11:20:21 | BUG #15881: \d name_of_any_table_in_any_database produces ERROR |
Previous Message | Fahar Abbas | 2019-06-28 06:20:09 | Re: BUG #15879: pgAdmin4.9 can't update table record |