mysql 主从切换丢失数据_关于PostgreSQL同步复制下主从切换时的数据丢失问题

[root@node73 ~]# ps -ef|grep postgres

root 1228 25775 0 14:09 pts/2 00:00:00 su - postgres

postgres 1229 1228 0 14:09 pts/2 00:00:00 -bash

postgres 3339 31673 17 14:10 ? 00:00:07 postgres: postgres postgres 192.168.1.245(41991) UPDATE waiting for 1/FE556260

postgres 4105 31673 41 14:10 ? 00:00:11 postgres: postgres postgres 192.168.1.245(41994) idle

root 5612 25754 0 14:11 pts/1 00:00:00 grep postgres

postgres 9168 31673 0 13:49 ? 00:00:05 postgres: wal sender process postgres 192.168.1.248(53883) streaming 1/FE556260

postgres 24589 31673 0 13:57 ? 00:00:03 postgres: wal sender process postgres 192.168.1.245(41904) streaming 1/FE5562E8

postgres 31673 1 0 13:45 ? 00:00:00 /opt/PostgreSQL/9.4.5/bin/postgres -D /data/pgsql -c config_file=/data/pgsql//postgresql.conf -p 5432

postgres 31694 31673 0 13:45 ? 00:00:00 postgres: logger process

postgres 31706 31673 0 13:45 ? 00:00:00 postgres: checkpointer process

postgres 31707 31673 0 13:45 ? 00:00:00 postgres: writer process

postgres 31708 31673 0 13:45 ? 00:00:00 postgres: wal writer process

postgres 31709 31673 0 13:45 ? 00:00:00 postgres: autovacuum launcher process

postgres 31710 31673 0 13:45 ? 00:00:00 postgres: stats collector process

[root@n73 ~]# kill -9 31673

[root@node73 ~]# ps -ef|grep postgres

root 1228 25775 0 14:09 pts/2 00:00:00 su - postgres

postgres 1229 1228 0 14:09 pts/2 00:00:00 -bash

postgres 4105 1 38 14:10 ? 00:00:18 postgres: postgres postgres 192.168.1.245(41994) idle

root 7017 25754 0 14:11 pts/1 00:00:00 grep postgres

postgres 31694 1 0 13:45 ? 00:00:00 postgres: logger process