CentOS 7 postgreSQL12 排程pgAgent
Oct 16, 2020
安裝postgreSQL的排程工具pgAgent
安裝套件
sudo yum -y install pgagent_12.x86_64
修改 pgagent 配置
vi /etc/pgagent/pgagent_12.confDBNAME=postgres
DBUSER=postgres
DBHOST=127.0.0.1
DBPORT=5432
PASSWORD=你的密碼 # 新增
LOGFILE=/var/log/pgagent_12.logvi /usr/lib/systemd/system/pgagent_12.service
--- 新增 password
ExecStart=/usr/bin/pgagent_12 -s ${LOGFILE} hostaddr=${DBHOST} dbname=${DBNAME} user=${DBUSER} port=${DBPORT} password=${PASSWORD}----
修改 pg_hba.conf
vi /var/lib/pgsql/12/data/pg_hba.conf# IPv4 local connections:
host all all 127.0.0.1/32 md5 # 原 ident
安裝pgAdmin管理套件pgagent
su - postgreslpsql -Upostgres CREATE EXTENSION pgagent;
啟動服務
systemctl enable pgagent_12
systemctl start pgagent_12
— 完成 —