BUG #15647: pgagent file missing

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: prakash(dot)ramakrishnan(dot)ap(at)nielsen(dot)com
Subject: BUG #15647: pgagent file missing
Date: 2019-02-21 14:42:29
Message-ID: 15647-8f04fa10218a6e74@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: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-02-21 16:30:03 BUG #15648: oracle_fdw extension not able to create
Previous Message Mithun Cy 2019-02-21 12:58:28 Re: BUG #15641: Autoprewarm worker fails to start on Windows with huge pages in use Old PostgreSQL community/pgsql-bugs x