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

From Tom Lane
Subject Re: BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su
Date
Msg-id 12540.1561731940@sss.pgh.pa.us
Whole thread Raw
In response to BUG #15880: ERROR: could not open extension control file "/usr/pgsql-11/share/extension/pgagent.control": No su  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
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



pgsql-bugs by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: BUG #15881: \d name_of_any_table_in_any_database produces ERROR
Next
From: Alvaro Herrera
Date:
Subject: Re: BUG #15873: Attaching a partition fails because it sees deletedcolumns