異步流復(fù)制 [root@wallet01?~]#?su?-?postgres [postgres@wallet01?~]$?vi?/var/lib/pgsql/9.6/data/pg_hba.conf host????replication?????postgres????????192.168.1.0/24??????????md5 [postgres@wallet01?~]$?vi?/var/lib/pgsql/9.6/data/postgresql.conf listen_addresses?=?'0.0.0.0' max_wal_senders?=?5 wal_level?=?hot_standby? [postgres@wallet01?~]$?pg_ctl?restart waiting?for?server?to?shut?down....?done server?stopped server?starting [root@wallet02?~]#?su?-?postgres [postgres@wallet02?~]$?pg_basebackup?-h?192.168.1.201?-U?postgres?-F?p?-P?-x?-R?-D?/var/lib/pgsql/9.6/data? Password:? 2161085/2161085?kB?(100%),?1/1?tablespace [postgres@wallet02?~]$?vi?/var/lib/pgsql/9.6/data/postgresql.conf hot_standby?=?on [postgres@wallet02?~]$?vi?/var/lib/pgsql/9.6/data/recovery.conf standby_mode?=?'on' primary_conninfo?=?'user=postgres?password=postgres?host=192.168.1.201?port=5432?sslmode=disable? sslcompression=1?krbsrvname=postgres' [postgres@wallet02?~]$?pg_ctl?start server?starting [postgres@wallet01?~]$?psql psql?(9.6.12) Type?"help"?for?help. postgres=#?select?pid,state,client_addr,sync_priority,sync_state?from?pg_stat_replication; ?pid??|???state???|??client_addr??|?sync_priority?|?sync_state? ------+-----------+---------------+---------------+------------ ?2055?|?streaming?|?192.168.1.202?|?????????????0?|?async (1?row)

目前創(chuàng)新互聯(lián)已為上1000+的企業(yè)提供了網(wǎng)站建設(shè)、域名、虛擬主機(jī)、網(wǎng)站托管、服務(wù)器租用、企業(yè)網(wǎng)站設(shè)計(jì)、德化網(wǎng)站維護(hù)等服務(wù)，公司將堅(jiān)持客戶導(dǎo)向、應(yīng)用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶和合作伙伴齊心協(xié)力一起成長，共同發(fā)展。同步流復(fù)制 [root@wallet01?~]#?su?-?postgres [postgres@wallet01?~]$?vi?/var/lib/pgsql/9.6/data/pg_hba.conf host????replication?????postgres????????192.168.1.0/24??????????md5 [postgres@wallet01?~]$?vi?/var/lib/pgsql/9.6/data/postgresql.conf max_wal_senders?=?5? wal_level?=?hot_standby synchronous_standby_names?=?'wallet02,wallet03' [root@wallet01?~]#?su?-?postgres [postgres@wallet01?~]$?pg_ctl?reload server?signaled [root@wallet02?~]#?su?-?postgres [postgres@wallet02?~]$?pg_basebackup?-h?192.168.1.201?-U?postgres?-F?p?-P?-x?-R?-D?/var/lib/pgsql/9.6/data? Password:? 2161085/2161085?kB?(100%),?1/1?tablespace [postgres@wallet02?~]$?vi?/var/lib/pgsql/9.6/data/postgresql.conf hot_standby?=?on [postgres@wallet02?~]$?vi?/var/lib/pgsql/9.6/data/recovery.conf standby_mode?=?'on' primary_conninfo?=?'application_name=wallet02?user=postgres?password=postgres?host=192.168.1.201?port=5432?sslmode=disable?sslcompression=1' [postgres@wallet02?~]$??pg_ctl?start server?starting [root@wallet03?~]#?su?-?postgres [postgres@wallet03?~]$?pg_basebackup?-h?192.168.1.201?-U?postgres?-F?p?-P?-x?-R?-D?/var/lib/pgsql/9.6/data? Password:? 2161215/2161215?kB?(100%),?1/1?tablespace [postgres@wallet03?~]$?vi?/var/lib/pgsql/9.6/data/postgresql.conf hot_standby?=?on [postgres@wallet03?~]$?vi?/var/lib/pgsql/9.6/data/recovery.conf standby_mode?=?'on' primary_conninfo?=?'application_name=wallet03?user=postgres?password=postgres?host=192.168.1.201?port=5432?sslmode=disable?sslcompression=1' [postgres@wallet03?~]$??pg_ctl?start server?starting [postgres@wallet01?~]$?psql psql?(9.6.12) Type?"help"?for?help. postgres=#?select?pid,state,client_addr,sync_priority,sync_state?from?pg_stat_replication; ?pid??|???state???|??client_addr??|?sync_priority?|?sync_state? ------+-----------+---------------+---------------+------------ ?1968?|?streaming?|?192.168.1.202?|?????????????1?|?sync ?2018?|?streaming?|?192.168.1.203?|?????????????2?|?potential

另外有需要云服務(wù)器可以了解下創(chuàng)新互聯(lián)cdcxhl.cn，海內(nèi)外云服務(wù)器15元起步，三天無理由+7*72小時(shí)售后在線，公司持有idc許可證，提供“云服務(wù)器、裸金屬服務(wù)器、高防服務(wù)器、香港服務(wù)器、美國服務(wù)器、虛擬主機(jī)、免備案服務(wù)器”等云主機(jī)租用服務(wù)以及企業(yè)上云的綜合解決方案，具有“安全穩(wěn)定、簡單易用、服務(wù)可用性高、性價(jià)比高”等特點(diǎn)與優(yōu)勢，專為企業(yè)上云打造定制，能夠滿足用戶豐富、多元化的應(yīng)用場景需求。

網(wǎng)站名稱：【PostgreSQL】數(shù)據(jù)庫復(fù)制-創(chuàng)新互聯(lián)
網(wǎng)頁鏈接：http://www.rwnh.cn/article8/csdhop.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供品牌網(wǎng)站建設(shè)、微信小程序、全網(wǎng)營銷推廣、品牌網(wǎng)站設(shè)計(jì)、關(guān)鍵詞優(yōu)化、建站公司

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)