1.创建目录存放pg_agent扩展所需插件:
mkdir /pgsoft/pgagent
chown -R postgres:postgres /pgsoft/pgagent
2. 将安装pg_agent扩展所需安装包上传至pgagent文件夹下;
3. 先解压cmake压缩包:
tar -xvf cmake-3.21.3.tar.gz
./bootstrap or ./configure
出现上面错误,是因为没有安装gcc或者版本过低,需执行以下语句:
yum -y install gcc-c++ (yum install gcc-c++ libstdc++-devel)
./bootstrap
yum install -y openssl openssl-devel
./configure
make && make install
4. 先解压wxWidgets压缩包:
tar -xvf wxWidgets-3.1.5.tar.bz2
需安装bzip2进行解压文件
yum install bzip2
bzip2 -d wxWidgets-3.1.5.tar.bz2
tar -xvf wxWidgets-3.1.5.tar
cd wxWidgets-3.1.5.tar
配置.bash_profile参数文件
vi ~/.bash_profile
PATH=$PATH:$HOME/bin:/usr/local/wxWidgets-3.1.5/bin
export LD_LIBRARY_PATH=/usr/local/wxWidgets-3.1.5/lib:$LD_LIBRARY_PATH
使配置文件生效:
source ~/.bash_profile
./configure --prefix=/usr/local/wxWidgets-3.1.5
yum install gtk*
./configure --prefix=/usr/local/wxWidgets-3.1.5
make && make install
5. 修改配置文件,解压 pgAgent压缩包:
tar -xvf pgAgent-4.0.0-Source.tar.gz
cd pgAgent-4.0.0-Source
vi /home/postgres/.bash_profile (添加postgre的环境变量)
PATH=/pgsoft/pgsql/bin:$PATH
export PATH
source /home/postgres/.bash_profile
cmake ./
yum install boost*
cmake ./
make && make install
7.进入postgres,重启服务:
su postgres
/pgsoft/pgsql/bin/pg_ctl restart -D /pgsoft/pgsql/data/
8.进入数据库,安装扩展:
/pgsoft/pgsql/bin/psql
create extension pgagent;