postgresql数据库主从恢复的实现

df -h

pg_ctl status

ps -ef | grep wal

su - postgresql -c "repmgr -f /repmgr/repmgr.conf cluster show" 

su - postgres -c "psql -c 'select client_addr,count(*) from pg_stat_activity group by 1 order by 2 desc;'"

ll /dev/sd* > /tmp/sd_info_2025xxxx.log
df -th >>/tmp/df_info.log
mount >>/tmp/mount_info.log
free -g >>/tmp/free_info.log
multipath -ll >> /tmp/multipath_info.log
uptime>>/tmp_uptime_info.log
vgs>> /tmp/vgs_info.log
pvs>> /tmp/pvs_info.log
lvs>>> /tmp/lvs_info.log

su - postgres
pg_ctl stop
pg_ctl status

su - postgres
mv /pg/data  /pg/data_2025xxxx

su - postgres
nohup repmgr -h $hostname -d repmgr -c --replication-user=postgres -d /pg/data standby clone --upstream-node-id=1 > /tmp/repmgr.log 2> /tmp/repmgr.err &

pg_ctl start
pg_ctl status

su - postgres
repmgr -f /repmgr/repmgr.conf standby register -f
repmgr -f /repmgr/repmgr.conf standby cluster show

tail -1000f /pg/data/pg_log/postgresql-2025-xx-xx.csv