BUG #14370: pgagent_96 service typo?

You need to report this to the PGAdmin team:

http://www.pgadmin.org/support/

Thanks.

---------------------------------------------------------------------------

On Fri, Oct 14, 2016 at 10:22:03AM +0000, alf@svada.com wrote:

The following bug has been logged on the website:

Bug reference: 14370
Logged by: Alf Normann Klausen
Email address: alf@svada.com
PostgreSQL version: 9.6.0
Operating system: CentOs 7
Description:

[root@tvm-alfkla ~]# systemctl start pgagent_96.service
Job for pgagent_96.service failed because the control process exited with
error code. See "systemctl status pgagent_96.service" and "journalctl -xe"
for details.

[root@tvm-alfkla ~]# journalctl -u pgagent_96
systemd[27365]: Failed at step EXEC spawning /usr/bin/pgagent_95: No such
file or directory
okt. 14 12:07:50 tvm-alfkla systemd[1]: pgagent_96.service: control process
exited, code=exited status=203
okt. 14 12:07:50 tvm-alfkla systemd[1]: Failed to start PgAgent for
PostgreSQL 9.6.
okt. 14 12:07:50 tvm-alfkla systemd[1]: Unit pgagent_96.service entered
failed state.
okt. 14 12:07:50 tvm-alfkla systemd[1]: pgagent_96.service failed.

[root@tvm-alfkla ~]# grep pgagent_95
/usr/lib/systemd/system/pgagent_96.service
Environment=LOGFILE=/var/log/pgagent_95.log
ExecStart=/usr/bin/pgagent_95 -s ${LOGFILE} hostaddr=${DBHOST}
dbname=${DBNAME} user=${DBUSER} port=${DBPORT}
ExecStop=/usr/bin/kill -TERM /usr/bin/pgagent_95
[root@tvm-alfkla ~]#

So the fix that works for me is:
[root@tvm-alfkla ~]# sed -i 's/pgagent_95/pgagent_96/g'
/usr/lib/systemd/system/pgagent_96.service

[root@tvm-alfkla ~]# systemctl daemon-reload
[root@tvm-alfkla ~]#

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+                      Ancient Roman grave inscription +

--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Hi,

On Fri, 2016-10-14 at 10:22 +0000, alf@svada.com wrote:

[root@tvm-alfkla ~]# systemctl start pgagent_96.service 
Job for pgagent_96.service failed because the control process exited with
error code. See "systemctl status pgagent_96.service" and "journalctl -xe"
for details.

[root@tvm-alfkla ~]# journalctl -u pgagent_96
systemd[27365]: Failed at step EXEC spawning /usr/bin/pgagent_95: No such
file or directory

:-( Thanks for the report. Just pushed updated packages to yum repository. They
will appear in next hour.

Sorry for the inconvenience.

Regards,
--
Devrim GÜNDÜZ
EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR

Dear Devrim,

Great to know that you fixed the issue, thanks a lot!

Vennlig hilsen,

Alf Normann Klausen

http://no.linkedin.com/in/alfklausen

Mobil: 48 00 14 94

2016-10-19 21:51 GMT+02:00 Devrim Gündüz <devrim@gunduz.org>: