Thread: BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su
BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su
From
PG Bug reporting form
Date:
The following bug has been logged on the website: Bug reference: 15880 Logged by: Shiwangini Shishulkar Email address: shiwangini.shishulkar@webgility.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@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.
Re: BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su
From
Tom Lane
Date:
PG Bug reporting form <noreply@postgresql.org> 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