CentOS Trigger配置因具体场景而异,常见的有数据库触发器和系统服务触发器,以下是相关配置步骤:
sudo yum install postgresql-server postgresql-contrib
(CentOS 7)或sudo dnf install postgresql-server postgresql-contrib
(CentOS 8)进行安装。sudo postgresql-setup --initdb
,然后sudo systemctl start postgresql
和sudo systemctl enable postgresql
。sudo -u postgres createuser --interactive
,sudo -u postgres createdb <数据库名>
。CREATE OR REPLACE FUNCTION
语句,如CREATE OR REPLACE FUNCTION update_timestamp() RETURNS TRIGGER AS $$ BEGIN NEW.updated_at = NOW(); RETURN NEW ; END;$$ LANGUAGE plpgsql;
。CREATE TRIGGER <触发器名> BEFORE INSERT OR UPDATE ON <表名> FOR EACH ROW EXECUTE FUNCTION <函数名>();
。sudo nano /etc/systemd/system/<服务名>.service
,添加[Unit]
、[Service]
、[Install]
等配置段。sudo systemctl daemon-reload
,sudo systemctl enable <服务名>.service
,sudo systemctl start <服务名>.service
。systemd-run
命令,如sudo systemd-run --on-active=1min /path/to/script.sh
。