????postgres??????????
????postgres??9.0??????????????????????????ν??????????????tcp???????????????????????postgres????????????????????Ч???3w??????qps??
????postgres????????????primary??????stand_by???????????????????????????postgres??汾?????????????????￡??????????????????????
????postgres????????
????????10.12.12.10???????
?????????????????????????????????
???????pg_hba.conf??????replica??????????????
????host    replication     replica     10.12.12.12/32                 md5
????????????????replica???????????10.12.12.12 ????????ν?????????????
??????postgres????????????????????
????postgres# CREATE ROLE replica login replication encrypted password 'replica'
???????postgresql.conf??????????????漸???????
????wal_level = hot_standby  # ????????????wal??????
????max_wal_senders = 32 # ??????????????м???????????????????м?????????ü???
????wal_keep_segments = 256 ?? ????????????????xlog???
????wal_sender_timeout = 60s ?? ????????????????????????????
????max_connections = 100 # ????????????￡?????max_connections??????????????
??????????
????pg_ctl restart
????postgres???????
????????10.12.12.12???????
????????????? /data/pgsql/data2
????pg_basebackup -F p --progress -D /data/pgsql/data2 -h 10.12.12.10 -p 5432 -U replica --password
?????????????pg_basebackup???????/data/pgsql/data2?????????
???????????????????????????е????????????????
????????/data/pgsql/data2????????recovery.conf?????????????pg????????share??????л????????
????cp /usr/local/postgres94/share/recovery.conf.sample /data/pgsql/data2/recovery.conf
???????recovery.conf?????????????????
????standby_mode = on  # ?????????????????
????primary_conninfo = 'host=10.12.12.10 port=5432 user=replica password=replica'  # ????????????????????????
????recovery_target_timeline = 'latest' # ?????????????????????μ?????
????postgresql.conf????м??????????????
????max_connections = 1000 ?? ???????д????????????????????
????hot_standby = on  ?? ??????????????????????????鵵?????????????
????max_standby_streaming_delay = 30s # ??????????????????
????wal_receiver_status_interval = 1s  # ?????????????δ??????????????????????????????????????????????ó????????
????hot_standby_feedback = on # ????д??????????????????????з???
???????????????????