Re: BUG #15647: pgagent file missing

Thanks for the report. We will check and revert. Most likely the installer
that you are using may not be supporting the extension based loading of the
modules. By the time we look and fix the issue, you may try installing
pgagent SQL.

Thanks.

On Thu, Feb 21, 2019 at 8:16 PM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 15647
> Logged by: ramakrishnan r
> Email address: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
> PostgreSQL version: 10.4
> Operating system: Red Hat Enterprise Linux Server release 7.4 (Maipo
> Description:
>
> Hi Team,
>
> I had an issue on one prod server installing pgagent below steps and not
> able to create the extesnion please find the below details,
>
> [root(at)sydrheappp001 postgres]# ./edb_pgagent.bin --mode text
>
> ----------------------------------------------------------------------------
> Welcome to the pgAgent Setup Wizard.
>
>
> ----------------------------------------------------------------------------
> Please select an empty directory for pgAgent installation.
>
> Installation Directory [/opt/pgAgent]: /opt/PostgreSQL/pgAgent
>
>
> ----------------------------------------------------------------------------
> Upgrade Mode
>
> Upgrade mode will prevent the installer from modifying the database cluster
> by
> loading pgAgent SQL scripts, in preparation for upgrading from earlier
> releases
> of PostgreSQL using the pg_upgrade tool.
>
> Upgrade Mode [y/N]: y
>
>
>
> ----------------------------------------------------------------------------
> PostgreSQL Installation Details
>
> Please verify the PostgreSQL installation details
>
> Host [localhost]: sydrheappp001.enterprisenet.org
>
> User Name [postgres]: postgres
>
> Password :
>
> Port [5432]: 5432
>
>
> ----------------------------------------------------------------------------
> pgAgent service account
>
> Please provide the user name of the account under which the pgAgent service
> will
> run.
> The .pgpass file will be created in the account home directory.
> If the user account does not exist it will be created.
>
> Operating system username [postgres]: postgres
>
>
> ----------------------------------------------------------------------------
> Setup is now ready to begin installing pgAgent on your computer.
>
> Do you want to continue? [Y/n]: y
>
>
> ----------------------------------------------------------------------------
> Please wait while Setup installs pgAgent on your computer.
>
> Installing
> 0% ______________ 50% ______________ 100%
> #########################################
>
>
> ----------------------------------------------------------------------------
> EnterpriseDB is the leading provider of value-added products and services
> for
> the Postgres community.
>
> Please visit our website at www.enterprisedb.com
>
> [root(at)sydrheappp001 postgres]# exit
> logout
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/home/postgres
>
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/opt/PostgreSQL/pgAgent
> ==> ls
> bin installer lib LICENSE pgAgent_3rd_party_licenses.txt README
> share
> uninstall-pgagent uninstall-pgagent.dat
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/opt/PostgreSQL/pgAgent
> ==> cd
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/home/postgres
> ==> pg_ctl restart -mf
> waiting for server to shut down........ done
> server stopped
> waiting for server to start....2019-02-22 00:45:51.379 AEDT [25253] LOG:
> listening on IPv4 address "0.0.0.0", port 5432
> 2019-02-22 00:45:51.379 AEDT [25253] LOG: listening on IPv6 address "::",
> port 5432
> 2019-02-22 00:45:51.381 AEDT [25253] LOG: listening on Unix socket
> "/tmp/.s.PGSQL.5432"
> ..................2019-02-22 00:46:10.074 AEDT [25253] LOG: redirecting
> log
> output to logging collector process
> 2019-02-22 00:46:10.074 AEDT [25253] HINT: Future log output will appear
> in
> directory "pg_log".
> done
> server started
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/home/postgres
> ==> psql -p 5432
> psql.bin (10.4)
> Type "help" for help.
>
> postgres=# create extension pgagent;
> ERROR: could not open extension control file
> "/opt/PostgreSQL/10/share/postgresql/extension/pgagent.control": No such
> file or directory
> postgres=#
> postgres=# \q
> postgres(at)sydrheappp001(dot)enterprisenet(dot)org:/home/postgres
>
>

--
Sandeep Thakkar