PostgreSQL13基于流复制搭建后备服务器的方法

vim /usr/local/pgsql/data/postgresql.conf

listen_addresses = '*'
wal_level = hot_standby
max_wal_senders = 10
max_replication_slots = 10
hot_standby = on # 主要用来备库配置，主库配置无影响
wal_keep_size = 1GB  #pg13后配置，之前是wal_keep_segments
wal_log_hints = on  #pg_rewind必须参数
full_page_writes = on

vim /usr/local/pgsql/data/pg_hba.conf
host    replication     all      0.0.0.0/0     trust #新增

pg_basebackup -D ../data1 -U postgres  -Fp -X stream -R  -P -v -p54321 -h 127.0.0.1

echo "port=54322" >> /usr/local/pgsql/data1/postgresql.conf
pg_ctl -D /usr/local/pgsql/data1 start

psql -Upostgres -dpostgres -p54321
select * from pg_stat_replication;

./psql -Upostgres -dpostgres -p54321
create table t1 (id int ,name varchar);
insert into t1 values (1,'cli');

psql -Upostgres -dpostgres -p54322
select * from t1;