概述
pgagent 作为postgresql的一个任务调度代理，在postgresql 9.0 以前 是附带在pgadmin 包下面的，只是默认不安装，9.0之后作为了一个单独是的安装包。所以要使用pgagent定时任务调度的话还得单独安装。
因为某些系统的yum源中不含有pgaent包，或者版本不适配。可以进行编译安装
需要下载
这里我选择的软件版本分别是：
postgresql 10.3
pgagent-3.4.0下载地址：https://www.pgadmin.org/download/pgagent.php
cmake-3.12.2 下载地址：http://cmake.org/download/
wxWidgets-3.1.1 下载地址：http://www.wxwidgets.org/downloads/安装步骤
postgresql的安装
（略）
cmake安装
将安装包上传至服务器并解压，解压后进入解压后生成的cmake-3.12.2目录，执行以下命令。
[root@lsrac97 ~]# tar zxvf cmake-3.12.2.tar.gz
[root@lsrac97 ~]# cd cmake-3.12.2
[root@lsrac97 cmake-2.8.5]# ./bootstrap && gmake && gmake installwxWidgets的安装
先配置.bash_profile文件
[root@lsrac97 ~]#vi .bash_profile
#加入以下内容：
PATH=$PATH:$HOME/bin:/usr/local/wxWidgets-3.1.1/bin
export LD_LIBRARY_PATH=/usr/local/wxWidgets-3.1.1/lib:$LD_LIBRARY_PATH
#并生效参数文件，命令如下：
[root@lsrac97 ~]#source .bash_profile接着解压该安装包并进入其目录，然后编译和安装
[root@lsrac97 wxGTK-2.8.12 ]# ./configure --enable-shared=no --enable-unicode=yes --prefix=/usr/local/wxWidgets-3.1.1
[root@lsrac97 wxGTK-2.8.12 ]# make && make install可能会报错
configure: error:
The development files for GTK+ were not found. For GTK+ 2, please
ensure that pkg-config is in the path and that gtk+-2.0.pc is
installed. For GTK+ 1.2 please check that gtk-config is in the path,
and that the version is 1.2.3 or above. Also check that the
libraries returned by 'pkg-config gtk+-2.0 --libs' or 'gtk-config
--libs' are in the LD_LIBRARY_PATH or equivalent.
解决方法
yum install gtk*显示以下内容表示编译安装完成
/usr/bin/install -c -m 644 ./include/$f /usr/local/wxWidgets-3.1.1/include/wx-3.1/$f; \
done
------------------------------------------------------
The installation of wxWidgets is finished. On certain
platforms (e.g. Linux) you'll now have to run ldconfig
if you installed a shared library and also modify the
LD_LIBRARY_PATH (or equivalent) environment variable.
wxWidgets comes with no guarantees and doesn't claim
to be suitable for any purpose.
Read the wxWindows Licence on licencing conditions.
------------------------------------------------------
[root@stephen wxWidgets-3.1.1]# pgagent的安装
上传安装包至服务器并解压,进入目录执行如下命令：
[root@lsrac97 pgAgent-4.0.0-Source]# cmake ./可能会报错：
-- Found Threads: TRUE
CMake Error at cmake/FindBoost.cmake:2044 (message):
Unable to find the requested Boost libraries.
Unable to find the Boost header files. Please set BOOST_ROOT to the root
directory containing Boost or BOOST_INCLUDEDIR to the directory containing
Boost's headers.
Call Stack (most recent call first):
CMakeLists.txt:112 (FIND_PACKAGE)
CMake Error at CMakeLists.txt:118 (MESSAGE):
Boost library not found.
-- Configuring incomplete, errors occurred!
See also "/tmp/pgAgent-4.0.0-Source/CMakeFiles/CMakeOutput.log".
See also "/tmp/pgAgent-4.0.0-Source/CMakeFiles/CMakeError.log".解决方法
yum install boost*再次执行cmake ./
[root@stephen pgAgent-4.0.0-Source]# cmake ./
-- Boost version: 1.53.0
-- Found the following Boost libraries:
-- filesystem
-- regex
-- date_time
-- thread
-- system
-- chrono
-- atomic
--
-- ================================================================================
-- Configuration summary:
--
-- Project : pgagent
-- Description : pgAgent is a job scheduling engine for PostgreSQL
-- Version : 4.0.0
--
-- PostgreSQL version string : PostgreSQL 9.6.0
-- PostgreSQL version parts : 9.6
-- PostgreSQL path : /usr/local/pgsql-9
-- PostgreSQL config binary : /usr/local/pgsql-9/bin/pg_config
-- PostgreSQL include path : /usr/local/pgsql-9.6/include
-- PostgreSQL library path : /usr/local/pgsql-9.6/lib
-- PostgreSQL share path : /usr/local/pgsql-9.6/share
--
-- Boost version : 1.53.0
-- Boost path : /usr/include
-- Boost include directory : /usr/include
-- Boost library directory : /usr/lib64
-- Boost Static linking : NO
-- ================================================================================
--
-- Configuring done
-- Generating done
-- Build files have been written to: /tmp/pgAgent-4.0.0-Source编译完成
然后编译安装 make && make install即可
[root@stephen pgAgent-4.0.0-Source]# make
Scanning dependencies of target run
[ 11%] Generating pgagent--4.0.sql, pgagent.control
[ 11%] Built target run
Scanning dependencies of target pgagent
[ 22%] Building CXX object CMakeFiles/pgagent.dir/connection.cpp.o
[ 33%] Building CXX object CMakeFiles/pgagent.dir/job.cpp.o
[ 44%] Building CXX object CMakeFiles/pgagent.dir/misc.cpp.o
[ 55%] Building CXX object CMakeFiles/pgagent.dir/pgAgent.cpp.o
[ 66%] Building CXX object CMakeFiles/pgagent.dir/precomp.cpp.o
[ 77%] Building CXX object CMakeFiles/pgagent.dir/unix.cpp.o
[ 88%] Building CXX object CMakeFiles/pgagent.dir/win32.cpp.o
[100%] Linking CXX executable pgagent
[100%] Built target pgagent
[root@stephen pgAgent-4.0.0-Source]# make install
[ 11%] Built target run
[100%] Built target pgagent
Install the project...
-- Install configuration: ""
-- Installing: /usr/local/bin/pgagent
-- Set runtime path of "/usr/local/bin/pgagent" to ""
-- Installing: /usr/local/share/pgagent.sql
-- Installing: /usr/local/./README
-- Installing: /usr/local/./LICENSE
-- Installing: /usr/local/pgsql-9.6/share/extension/pgagent--4.0.sql
-- Installing: /usr/local/pgsql-9.6/share/extension/pgagent.control
-- Installing: /usr/local/pgsql-9.6/share/extension/pgagent--3.4--4.0.sql
-- Installing: /usr/local/pgsql-9.6/share/extension/pgagent--unpackaged--4.0.sql配置pgagent
创建拓展
postgres=# create extension pgagent ;
CREATE EXTENSION启动pgagent进程
postgres@stephen ~]$ pgagent hostaddr=127.0.0.1 dbname=postgres user=postgres password=postgres
[postgres@stephen ~]$ 配置定时任务
连接pgadmin
用你的账号信息连接
如果正确安装了pgagent，就会有个pgagent任务
创建任务
步骤里主要写好基础设置，和需要执行的代码
时间表的信息就可以设置时间的重复。
