*********************************************************************************************

https://open.weixin.qq.com/
微信开放平台账号
wubin@dsideal.com
DsideaL4r5t6y7u!@#

*********************************************************************************************

192.168.15.215 (openEuler release 22.03 LTS)
root
DsideaL4r5t6y7u!@#


PostgreSQL
端口：5432
用户名：postgres
密码：DsideaL147258369
启动脚本
systemctl start postgresql.service
systemctl stop postgresql.service


#=====iptables配置======================================
iptables -P INPUT ACCEPT
iptables -F
iptables -X
iptables -Z
iptables -A INPUT -i lo -j ACCEPT
iptables -A INPUT -p icmp -m icmp --icmp-type 8 -j ACCEPT
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
iptables -A INPUT -s 192.168.15.217 -j ACCEPT
iptables -A INPUT -s 192.168.15.68 -j ACCEPT
iptables -P INPUT DROP


service iptables save 
systemctl restart iptables.service
chkconfig iptables on
#===========================================

*********************************************************************************************

192.168.15.29 (openEuler release 22.03 LTS)
root
Dsideal4r5t6y7u

用途：PostgreSQL 主

PostgreSQL
端口：5432
用户名：postgres
密码：DsideaL147258369
启动脚本
systemctl start postgresql.service
systemctl stop postgresql.service


#=====iptables配置======================================
iptables -P INPUT ACCEPT
iptables -F
iptables -X
iptables -Z
iptables -A INPUT -i lo -j ACCEPT
iptables -A INPUT -p icmp -m icmp --icmp-type 8 -j ACCEPT
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
iptables -A INPUT -s 192.168.15.217 -j ACCEPT
iptables -A INPUT -s 192.168.15.68 -j ACCEPT
iptables -A INPUT -s 192.168.15.154 -j ACCEPT
iptables -P INPUT DROP


service iptables save 
systemctl restart iptables.service
chkconfig iptables on
#===========================================

*********************************************************************************************

192.168.15.154 (openEuler release 22.03 LTS)
root
Dsideal4r5t6y7u

用途：PostgreSQL 从

PostgreSQL
端口：5432
用户名：postgres
密码：DsideaL147258369
启动脚本
systemctl start postgresql.service
systemctl stop postgresql.service


#=====iptables配置======================================
iptables -P INPUT ACCEPT
iptables -F
iptables -X
iptables -Z
iptables -A INPUT -i lo -j ACCEPT
iptables -A INPUT -p icmp -m icmp --icmp-type 8 -j ACCEPT
iptables -A INPUT -m state --state ESTABLISHED,RELATED -j ACCEPT
iptables -A INPUT -s 192.168.15.217 -j ACCEPT
iptables -A INPUT -s 192.168.15.68 -j ACCEPT
iptables -A INPUT -s 192.168.15.29 -j ACCEPT
iptables -P INPUT DROP


service iptables save 
systemctl restart iptables.service
chkconfig iptables on
#===========================================