BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su

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.

Responses

Browse pgsql-bugs by date

  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