usr/bin/sudo /sbin/ip addr del $VIP/24 dev $DEVICEĮOF chown postgres:postgres /etc/pgpool-II/escalation.shĬhown postgres:postgres /etc/pgpool-II/*.confįailover_command = '/etc/pgpool-II/failover.sh %d %h %p %D %m %H %M %P %r %R %N %S'įollow_primary_command = '/etc/pgpool-II/follow_primary.sh %d %h %p %D %m %H %M %P %r %R' Ssh -T -o StrictHostKe圜hecking=no -o UserKnownHostsFile=/dev/null -i ~/.ssh/id_rsa_pgpool "
# before bringing up the virtual IP on the new active pgpool node.
# This script is run by wd_escalation_command to bring down the virtual IP on other pgpool nodes Pg_md5 -md5auth -username =postgres "postgres123" # 看门狗 cat > /etc/pgpool-II/escalation.sh << "EOF" Pg_md5 -md5auth -username =pgpool "postgres123" Mkdir -p /u01/apps/pgsql15/archivedir/ -归档日志目录Ĭat > /u01/apps/pgsql15/data/nf /u01/apps/pgsql15/.pgpass /u01/apps/pgsql15/data/.pcppassĬhmod 600 /u01/apps/pgsql15/data/.pcppassĬhown postgres.postgres /u01/apps/pgsql15/data/.pcppassĮcho 'pgpool:' `pg_md5 -u =pgpool postgres123 ` > /etc/pgpool-II/pcp.confĮcho “2” > /etc/pgpool-II/pgpool_node_id Pgpool-II参数配置 cat > /etc/pgpool-II/nf > /etc/pgpool-II/pool_hba.conf Sed -i "/^Environment=PGDATA/cEnvironment=PGDATA=\/u01\/apps\/pgsql15\/data\/" /usr/lib/systemd/system/rviceįirewall-cmd -permanent -zone=public -add-service=postgresqlįirewall-cmd -permanent -zone=public -add-port=5432/tcpĬhown -R postgres:postgres /u01/apps/pgpool/ Vim /usr/lib/systemd/system/rvice # Location of database directoryĮnvironment=PGDATA=/u01/apps/pgsql15/data/ usr/pgsql-15/bin/initdb -D /u01/apps/pgsql15/data 安装pg15 sudo yum install -y postgresql15 -serverĬhown -R postgres:postgres /u01/apps/pgsql15/
0 kommentar(er)
