pgAgent (PostgreSQL定时任务)

简介

在pgAdminIII v1.4中引入的pgAgent是一个用于PostgreSQL的作业调度代理，可用于执行操作系统批处理脚本和SQL任务。

从pgAdmin 1.9开始，pgAgent独立于pgAdmin单独安装。

环境：

• PostgreSQL 9.6.6
• pgAgent 3.4.0
• cmake 2.8.11
• wxWidgets 2.8.12

先安装PG、wxGTK、cmake

安装pgAgent

[yangjie@young-1 package]$ tar zxvf pgAgent-3.4.0-Source.tar.gz 
[yangjie@young-1 package]$ cd pgAgent-3.4.0-Source/
[yangjie@young-1 pgAgent-3.4.0-Source]$ cmake ./
--  
-- ================================================================================
-- Configuration summary:
--  
--   Project                     : pgagent
--   Description                 : pgAgent is a job scheduling engine for PostgreSQL
--   Version                     : 3.4.0
--  
--   PostgreSQL version string   : PostgreSQL 9.6.6
--   PostgreSQL version parts    : 9.6.6
--   PostgreSQL path             : /work/pgsql/pg96
--   PostgreSQL config binary    : /work/pgsql/pg96/bin/pg_config
--   PostgreSQL include path     : /work/pgsql/pg96/include
--   PostgreSQL library path     : /work/pgsql/pg96/lib
--   PostgreSQL share path       : /work/pgsql/pg96/share
--  
--   wxWidgets version           : 2.8.12
--   wxWidgets path              : /usr/local
--   wxWidgets config binary     : /usr/local/bin/wx-config
--   wxWidgets Static linking    : YES
--   wxWidgets Debug?            : NO
-- ================================================================================
--  
-- Configuring done
-- Generating done
-- Build files have been written to: /work/extension/pgAgent-3.4.0-Source
[yangjie@young-1 pgAgent-3.4.0-Source]$ make; make install;

数据库配置

创建pgagent扩展

[yangjie@young-1 bin]$ pwd
/work/pgsql/pg96/bin
[yangjie@young-1 bin]$ ./psql 
psql (9.6.6)
Type "help" for help.

yangjie=# create extension pgagent ;
CREATE EXTENSION
yangjie=# \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description          
---------+---------+------------&