pgAgent是PostgreSQL的一个job引擎，可以执行数据库job任务。本文简述其安装步骤

一 安装cmake

#检查是否安装
[root@bogon ~]# cmake --version
cmake version 2.8.11

#如果未安装执行下面的语句
wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz
tar -zxvf cmake-2.8.5.tar.gz
cd /root/src/cmake-2.8.5
./bootstrap
make 
make install

二 安装wxGTK-2.8.12

wget https://github.com/wxWidgets/wxWidgets/releases/download/v2.8.12/wxGTK-2.8.12.tar.gz
#注意编译的时候一定要支持unicode 与 静态编译
 ./configure   --enable-shared=no --enable-unicode=yes
make
make install

./configure可能报错如下：

*** Could not run GTK+ test program, checking why...
*** The test program failed to compile or link. See the file config.log for the
*** exact error that occured. 
This usually means GTK+ is incorrectly installed.
configure: error:The development files for GTK+ were not found. For GTK+ 2, please

需要安装gkt+，笔者源码安装又发现一堆依赖，这里先不管了，直接yum安装

yum install gtk2-devel

然后编译就通过了。

三 安装pgAgent

#在root账户下执行
# tar -zxvf pgAgent-3.0.1-Source.tar.gz
# source /home/postgres/.bashrc #引入postgres的环境变量
# cmake ./
# make
# make install

cmake可能报错如下：

/bin/ld:cannot find -lcrypto

简单的执行以下语句：

yum install openssl-devel

成功后用pgsql 用户登录数据库执行

[postgres@bogon ~]$ psql
psql (9.6.0)
Type "help" for help.

postgres=# \i /usr/local/share/pgagent.sql
postgres=# \i /usr/local/share/pgagent_upgrade.sql