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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

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

PG Bug reporting form
The following bug has been logged on the website:

Bug reference:      15880
Logged by:          Shiwangini Shishulkar
Email address:      [hidden email]
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@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.

Reply | Threaded
Open this post in threaded view
|

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

Tom Lane-2
PG Bug reporting form <[hidden email]> writes:
> 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.

I don't know much about pgagent, but I seriously doubt that "untar the
source code into the installation directory" is the correct build process
for it.  There's probably a README file or some other documentation
explaining what you should do instead.

> 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.

"${MAJOR_VERSION}.${MINOR_VERSION}" is what it's seeing as the default
version in pgagent.control.  This reinforces the idea that what you've
installed is some precursor file and not what's intended to be the
built-and-installed contents of the extension.

                        regards, tom lane