Re: 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(at)svada(dot)com wrote:
> The following bug has been logged on the website:
>
> Bug reference: 14370
> Logged by: Alf Normann Klausen
> Email address: alf(at)svada(dot)com
> PostgreSQL version: 9.6.0
> Operating system: CentOs 7
> Description:
>
> [root(at)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(at)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(at)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(at)tvm-alfkla ~]#
>
> So the fix that works for me is:
> [root(at)tvm-alfkla ~]# sed -i 's/pgagent_95/pgagent_96/g'
> /usr/lib/systemd/system/pgagent_96.service
>
> [root(at)tvm-alfkla ~]# systemctl daemon-reload
> [root(at)tvm-alfkla ~]#
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs

--
Bruce Momjian <bruce(at)momjian(dot)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 +