PostgreSQL 9.6.0 锟街诧拷
锟斤拷一页锟斤拷一锟斤拷锟斤拷 19. 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一页

19.6. 锟斤拷锟斤拷

锟斤拷些锟斤拷锟矫匡拷锟斤拷锟节斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟皆ｏ拷锟斤拷锟斤拷 26.2.5 锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟截凤拷锟斤拷锟斤拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷鼗锟斤拷芊锟斤拷锟斤拷锟斤拷荩锟斤拷锟斤拷蟊富锟斤拷锟斤拷潜锟斤拷锟斤拷锟斤拷锟斤拷莸慕锟斤拷锟斤拷摺锟斤拷锟绞癸拷眉锟斤拷锟斤拷锟斤拷疲锟斤拷锟�锟斤拷 26.2.7 锟斤拷锟斤拷时锟斤拷锟襟备凤拷锟斤拷锟斤拷也锟斤拷锟斤拷锟角凤拷锟斤拷锟竭ｏ拷同时也锟角斤拷锟斤拷锟竭★拷锟斤拷些锟斤拷锟斤拷锟斤拷要锟斤拷锟节凤拷锟酵凤拷锟斤拷锟斤拷锟酵后备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷某些只锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟藉。锟斤拷锟斤拷斜锟揭拷锟斤拷锟斤拷每锟斤拷锟斤拷诩锟饺猴拷斜浠拷锟斤拷锟斤拷锟斤拷锟斤拷狻�

19.6.1. 锟斤拷锟酵凤拷锟斤拷锟斤拷

锟斤拷些锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿何凤拷锟酵革拷锟斤拷锟斤拷锟捷革拷一锟斤拷锟斤拷锟斤拷锟襟备凤拷锟斤拷锟斤拷锟侥凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷锟斤拷锟截伙拷锟斤拷锟斤拷一锟斤拷锟斤拷锟酵凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟斤拷锟斤拷锟揭拷锟斤拷锟斤拷鼗锟斤拷锟斤拷锟斤拷谩锟斤拷锟叫╋拷锟斤拷锟斤拷慕锟缴拷秃锟斤拷宀伙拷锟斤拷锟揭伙拷锟斤拷蟊富锟斤拷锟斤拷锟斤拷锟截伙拷锟斤拷谋洹�

max_wal_senders (integer)

指锟斤拷锟斤拷锟皆后备凤拷锟斤拷锟斤拷锟斤拷锟斤拷式锟斤拷锟斤拷锟斤拷锟捷客伙拷锟剿的诧拷锟斤拷锟斤拷锟接碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟酵憋拷锟斤拷锟� WAL 锟斤拷锟酵斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥拷锟街碉拷锟斤拷悖拷锟斤拷锟轿讹拷沤锟斤拷酶锟斤拷啤锟絎AL 锟斤拷锟酵斤拷锟教憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟节ｏ拷锟斤拷烁貌锟斤拷锟� 锟斤拷锟杰憋拷锟斤拷锟斤拷为锟斤拷锟斤拷max_connections锟斤拷值锟斤拷突然锟斤拷锟斤拷锟酵伙拷锟剿断匡拷 锟斤拷锟接匡拷锟杰碉拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟接槽ｏ拷知锟斤拷锟斤到锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷应锟斤拷锟斤拷锟矫碉拷锟皆革拷锟斤拷锟斤拷锟酵伙拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较匡拷锟斤拷锟接的客伙拷锟剿匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接★拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷诜锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷锟斤拷谩锟� wal_level锟斤拷锟斤拷锟斤拷锟斤拷为archive锟斤拷锟斤拷呒锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷院蟊阜锟� 锟斤拷锟斤拷锟斤拷锟斤拷锟接★拷

max_replication_slots (integer)

指锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷支锟街的革拷锟狡槽ｏ拷锟斤拷锟斤拷 26.2.6 锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟斤拷锟侥拷锟街滴拷恪ｏ拷锟斤拷锟斤拷锟斤拷只锟斤拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷锟矫★拷要锟斤拷锟斤拷使锟矫革拷锟狡槽ｏ拷 wal_level锟斤拷锟诫被锟斤拷锟斤拷为archive锟斤拷 锟斤拷锟竭★拷锟斤拷锟斤拷锟斤拷值锟斤拷锟斤拷为锟斤拷锟斤拷锟斤拷锟叫革拷锟狡槽碉拷锟斤拷锟斤拷锟斤拷锟斤拷止锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

wal_keep_segments (integer)

指锟斤拷锟节后备凤拷锟斤拷锟斤拷锟斤拷要为锟斤拷锟斤拷锟狡伙拷取锟斤拷志锟斤拷锟侥硷拷锟斤拷锟斤拷锟斤拷拢锟�pg_xlog目录锟斤拷锟斤拷锟杰憋拷锟斤拷锟侥癸拷去锟斤拷志锟侥硷拷锟轿碉拷锟斤拷小锟斤拷目锟斤拷每锟斤拷锟斤拷通锟斤拷锟斤拷 16 锟斤拷锟街节★拷锟斤拷锟揭伙拷锟斤拷锟斤拷拥锟斤拷锟斤拷头锟斤拷锟斤拷锟斤拷暮蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟剿筹拷锟斤拷wal_keep_segments锟斤拷锟轿ｏ拷锟斤拷锟酵凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡筹拷一锟斤拷锟襟备伙拷锟斤拷然锟斤拷要锟斤拷 WAL 锟轿ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷赂锟斤拷锟斤拷锟斤拷咏锟斤拷锟斤拷卸稀锟斤拷锟斤拷战锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟斤拷锟斤拷失锟杰ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞癸拷锟� WAL 锟介档锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟接归档锟斤拷取锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷

只锟斤拷锟斤拷pg_xlog锟叫憋拷锟斤拷锟斤拷锟侥硷拷锟轿碉拷锟斤拷小锟斤拷目锟斤拷系统锟斤拷锟斤拷锟斤拷要为 WAL 锟介档锟斤拷锟揭伙拷锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷巍锟斤拷锟斤拷wal_keep_segments为锟姐（默锟斤拷值锟斤拷锟斤拷 锟斤拷锟斤拷目占锟斤拷锟� 锟斤拷锟絎AL锟介档锟斤拷锟揭伙拷锟斤拷锟斤拷锟街革拷锟斤拷锟斤拷锟絯al_keep_segments锟斤拷锟姐（缺省锟斤拷锟斤拷 系统锟斤拷锟斤拷为锟斤拷目锟侥憋拷锟斤拷锟轿何讹拷锟斤拷亩危锟斤拷锟剿后备凤拷锟斤拷锟斤拷锟斤拷锟矫的撅拷 WAL 锟轿碉拷锟斤拷锟斤拷锟斤拷一锟斤拷锟较革拷锟斤拷锟斤拷位锟矫猴拷 WAL 锟介档状态锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

wal_sender_timeout (integer)

锟叫讹拷锟斤拷些停止锟筋动锟斤拷锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟侥革拷锟斤拷锟斤拷锟接★拷锟斤拷苑锟斤拷头锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟襟备伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫讹拷锟斤拷锟矫★拷锟斤拷值锟斤拷锟斤拷锟矫该筹拷时锟斤拷锟狡★拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷默锟斤拷值锟斤拷 60 锟诫。

track_commit_timestamp (bool)

锟斤拷录锟斤拷锟斤拷锟结交时锟戒。锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷 锟斤拷锟竭凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷缺省值锟斤拷off锟斤拷

19.6.2. 锟斤拷锟斤拷锟斤拷锟斤拷

锟斤拷些锟斤拷锟斤拷锟斤拷锟斤拷锟节凤拷锟酵革拷锟斤拷锟斤拷锟捷革拷一锟斤拷锟斤拷锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷/锟斤拷要锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷注锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟街拷猓拷锟斤拷锟斤拷胤锟斤拷锟斤拷锟斤拷媳锟斤拷锟斤拷锟斤拷煤锟斤拷实锟�wal_level锟斤拷锟斤拷锟斤拷也锟斤拷锟矫匡拷选锟斤拷 WAL 锟介档锟斤拷锟斤拷锟斤拷 19.5.3 锟斤拷锟斤拷锟斤拷锟斤拷些锟斤拷锟斤拷值锟斤拷蟊阜锟斤拷锟斤拷锟斤拷薰兀锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷希锟斤拷为锟斤拷准锟斤拷锟斤拷一锟斤拷锟襟备伙拷转锟斤拷锟斤拷锟斤拷鼗锟斤拷锟斤拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟斤拷锟�

synchronous_standby_names (string)

锟斤拷锟斤拷 26.2.8 锟斤拷锟斤拷锟斤拷锟斤拷 锟斤拷锟斤拷锟斤拷锟街革拷锟揭伙拷锟街э拷锟�同锟斤拷锟斤拷锟斤拷锟侥后备凤拷锟斤拷锟斤拷锟斤拷锟叫憋拷锟斤拷 锟斤拷锟杰伙拷锟斤拷一锟斤拷锟斤拷锟竭讹拷锟斤拷疃拷锟酵拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟� 锟斤拷锟斤拷些锟襟备凤拷锟斤拷锟斤拷确锟斤拷锟秸碉拷锟斤拷锟角碉拷锟斤拷锟斤拷之锟襟，等达拷锟结交锟斤拷锟斤拷锟今将憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷去锟斤拷 同锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷些锟斤拷锟街筹拷锟斤拷锟斤拷锟斤拷锟斤拷斜锟角帮拷妫� 锟斤拷锟揭碉拷前锟斤拷锟斤拷锟接诧拷锟斤拷锟斤拷锟斤拷实时锟斤拷锟斤拷锟斤拷锟斤拷锟捷ｏ拷锟斤拷 pg_stat_replication锟斤拷图锟斤拷streaming 锟斤拷状态锟斤拷示锟斤拷锟侥凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷斜锟斤拷泻锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷些锟襟备凤拷锟斤拷锟斤拷锟斤拷示潜锟节碉拷 同锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷魏蔚锟角帮拷锟酵拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟侥筹拷锟皆拷锟较匡拷锟斤拷锟接ｏ拷 锟斤拷锟斤拷锟斤拷锟教憋拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷燃锟斤拷暮蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 指锟斤拷锟斤拷锟斤拷一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟狡匡拷锟斤拷实锟街很高的匡拷锟斤拷锟皆★拷

锟斤拷锟斤拷锟斤拷锟绞癸拷锟斤拷锟斤拷锟斤拷锟斤法之一锟斤拷指锟斤拷一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟叫憋拷锟斤拷 

num_sync ( standby_name [, ...] )
standby_name [, ...]

锟斤拷锟斤拷num_sync 锟斤拷锟斤拷锟斤拷锟斤拷要锟饺达拷锟斤拷馗锟斤拷锟酵拷锟斤拷蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�standby_name 锟斤拷一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡★拷锟斤拷锟界，锟斤拷锟斤拷3 (s1, s2, s3, s4) 锟斤拷锟斤拷锟斤拷锟斤拷锟结交锟饺达拷锟斤拷直锟斤拷锟斤拷锟角碉拷 WAL 锟斤拷录锟斤拷锟襟备凤拷锟斤拷锟斤拷s1锟斤拷s2锟斤拷 s3锟斤拷s4锟斤拷选锟斤拷锟斤拷锟斤拷锟斤拷锟较革拷锟斤拷锟饺硷拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟秸碉拷锟斤拷

PostgreSQL锟芥本 9.6 之前使锟矫癸拷锟节讹拷锟斤拷锟斤法锟斤拷目前也锟斤拷然支锟街★拷 锟斤拷锟酵碉拷一锟斤拷锟斤法锟斤拷同锟斤拷锟斤拷锟斤拷num_sync 锟斤拷锟斤拷 1锟斤拷锟斤拷锟界，1 (s1, s2)锟斤拷s1, s2锟斤拷锟斤拷锟斤拷同锟侥猴拷锟藉： s1锟斤拷锟斤拷s2锟结被选锟斤拷锟斤拷为同锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷

锟斤拷锟节达拷目锟侥碉拷一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟角后备凤拷锟斤拷锟斤拷锟斤拷application_name锟斤拷锟矫ｏ拷 锟斤拷锟斤拷锟节后备伙拷锟斤拷 WAL 锟斤拷锟秸斤拷锟教碉拷primary_conninfo锟斤拷锟斤拷锟斤拷锟矫的★拷 锟斤拷锟斤拷没锟叫伙拷锟狡匡拷锟斤拷强锟斤拷唯一锟皆★拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷拢锟狡ワ拷锟侥后备伙拷之一锟斤拷锟斤拷选锟斤拷为同锟斤拷锟襟备伙拷锟斤拷 锟斤拷锟角撅拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷选锟斤拷锟斤拷锟睫凤拷锟叫断的★拷锟斤拷锟斤拷锟斤拷*锟斤拷匹锟斤拷锟斤拷锟斤拷 application_name锟斤拷锟斤拷锟斤拷walreceiver锟斤拷默锟斤拷应锟斤拷锟斤拷锟狡★拷

注锟斤拷: 每一锟斤拷standby_name 锟斤拷应锟矫撅拷锟叫合凤拷 SQL 锟斤拷识锟斤拷锟斤拷锟斤拷式锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷*锟斤拷 锟斤拷锟斤拷锟揭拷锟斤拷锟斤拷使锟斤拷双锟斤拷锟脚★拷锟斤拷锟斤拷注锟斤拷锟节比斤拷 standby_name 锟酵后备伙拷应锟矫筹拷锟斤拷锟斤拷锟斤拷时锟角达拷小写锟斤拷锟斤拷锟叫的ｏ拷锟斤拷锟斤拷锟斤拷没锟斤拷双锟斤拷锟脚ｏ拷锟斤拷

锟斤拷锟斤拷锟斤拷锟矫伙拷锟街革拷锟酵拷锟斤拷蟊富锟斤拷锟斤拷疲锟斤拷锟矫赐拷锟斤拷锟斤拷撇锟斤拷鼙锟斤拷锟斤拷貌锟斤拷锟斤拷锟斤拷锟斤拷峤伙拷锟斤拷锟斤拷锟饺达拷锟斤拷锟狡★拷锟斤拷锟斤拷默锟较碉拷锟斤拷锟矫★拷锟斤拷锟姐当同锟斤拷锟斤拷锟狡憋拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷也锟斤拷锟皆憋拷锟斤拷锟斤拷为锟斤拷锟饺达拷锟斤拷锟狡ｏ拷锟斤拷锟斤拷锟角斤拷synchronous_commit锟斤拷锟斤拷锟斤拷锟斤拷为local锟斤拷off锟斤拷

锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

vacuum_defer_cleanup_age (integer)

指锟斤拷VACUUM锟斤拷HOT锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷邪姹局帮拷锟接︼拷锟斤拷瞥俣锟矫ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡ｏ拷锟斤拷默锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷瘢锟绞撅拷锟斤拷锟斤拷邪姹撅拷锟斤拷锟斤拷锟斤拷锟斤拷芸锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷遣锟斤拷俣锟斤拷魏未蚩锟斤拷锟斤拷锟缴硷拷时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟街э拷锟斤拷群蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷希锟斤拷锟斤拷锟斤拷希锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿伙拷锟斤拷锟斤拷锟街碉拷锟斤拷锟�锟斤拷 26.5 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟襟备伙拷锟较的诧拷询锟叫革拷锟斤拷时锟斤拷锟斤拷锟斤拷啥锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟角帮拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷突锟斤拷锟斤拷锟角ｏ拷锟斤拷锟节革拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟较凤拷锟斤拷锟斤拷写锟斤拷锟斤拷锟斤拷锟侥匡拷锟斤拷锟斤拷模锟斤拷锟斤拷锟皆わ拷锟皆后备伙拷锟斤拷询锟斤拷锟矫的革拷锟斤拷时锟戒到锟斤拷锟角讹拷锟劫★拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

锟斤拷也锟斤拷锟皆匡拷锟斤拷锟斤拷锟矫后备凤拷锟斤拷锟斤拷锟较碉拷hot_standby_feedback锟斤拷为使锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷

锟斤拷锟睫凤拷锟斤拷止锟窖撅拷锟斤到old_snapshot_threshold 锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷斜锟斤拷锟斤拷锟斤拷

19.6.3. 锟襟备凤拷锟斤拷锟斤拷

锟斤拷些锟斤拷锟矫匡拷值锟斤拷锟秸革拷锟斤拷锟斤拷锟捷碉拷一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷锟角碉拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟睫关★拷

hot_standby (boolean)

指锟斤拷锟节恢革拷锟节间，锟斤拷锟角凤拷锟杰癸拷锟斤拷锟接诧拷锟斤拷锟叫诧拷询锟斤拷锟斤拷锟斤拷 26.5 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷默锟斤拷值锟斤拷off锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷诜锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷谩锟斤拷锟街伙拷诠榈碉拷指锟斤拷诩锟斤拷蟊富锟侥Ｊ斤拷虏锟斤拷锟叫э拷锟�

max_standby_archive_delay (integer)

锟斤拷锟饺后备伙拷锟斤拷锟节活动状态时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺★拷锟斤拷锟叫╋拷爰达拷锟接︼拷玫锟� WAL 锟斤拷锟酵伙拷暮蟊富锟斤拷锟窖帮拷锟斤拷蟊阜锟斤拷锟斤拷锟接︼拷玫却锟斤拷锟矫ｏ拷锟斤拷锟斤拷 26.5.2 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 WAL 锟斤拷锟捷憋拷锟斤拷 WAL 锟介档锟斤拷锟斤拷锟斤拷锟斤拷瞬锟斤拷堑锟角帮拷锟� WAL锟斤拷时锟斤拷max_standby_archive_delay锟斤拷锟斤拷应锟矫★拷默锟斤拷值锟斤拷 30 锟诫。锟斤拷锟矫伙拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿伙拷呛锟斤拷搿Ｖ� -1 锟斤拷锟斤拷锟襟备伙拷一直锟饺碉拷锟斤拷突锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

注锟解，max_standby_archive_delay锟斤拷取锟斤拷之前一锟斤拷锟斤拷询锟杰癸拷锟斤拷锟叫碉拷锟筋长时锟戒不同锟斤拷锟斤拷锟斤拷示应锟斤拷锟轿猴拷一锟斤拷 WAL 锟斤拷锟斤拷锟斤拷锟杰癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟筋长锟斤拷时锟戒。锟斤拷耍锟斤拷锟斤拷一锟斤拷锟斤拷询锟斤拷锟斤拷 WAL 锟轿碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接迟ｏ拷锟斤拷锟斤拷锟斤拷突锟斤拷询锟斤拷只锟叫革拷锟劫碉拷时锟戒。

max_standby_streaming_delay (integer)

锟斤拷锟饺后备伙拷锟斤拷锟节活动状态时锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺★拷锟斤拷锟叫╋拷爰达拷锟接︼拷玫锟� WAL 锟斤拷锟酵伙拷暮蟊富锟斤拷锟窖帮拷锟斤拷蟊阜锟斤拷锟斤拷锟接︼拷玫却锟斤拷锟矫ｏ拷锟斤拷锟斤拷 26.5.2 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 WAL 锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟狡憋拷锟斤拷锟斤拷时锟斤拷max_standby_streaming_delay锟斤拷锟斤拷应锟矫★拷默锟斤拷值锟斤拷 30 锟诫。锟斤拷锟矫伙拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿伙拷呛锟斤拷搿Ｖ� -1 锟斤拷锟斤拷锟襟备伙拷一直锟饺碉拷锟斤拷突锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

注锟解，max_standby_streaming_delay锟斤拷取锟斤拷之前一锟斤拷锟斤拷询锟杰癸拷锟斤拷锟叫碉拷锟筋长时锟戒不同锟斤拷锟斤拷锟斤拷示锟节达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟秸碉拷 WAL 锟斤拷锟捷诧拷锟斤拷锟斤拷应锟斤拷锟斤拷锟杰癸拷锟斤拷锟斤拷锟斤拷锟斤拷锟筋长锟斤拷时锟戒。锟斤拷耍锟斤拷锟斤拷一锟斤拷锟斤拷询锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟接迟ｏ拷锟斤拷锟斤拷锟斤拷突锟斤拷询锟斤拷只锟叫革拷锟劫碉拷时锟戒，直锟斤拷锟襟备凤拷锟斤拷锟斤拷锟劫次革拷锟较斤拷锟饺★拷

wal_receiver_status_interval (integer)

指锟斤拷锟节后备伙拷锟较碉拷 WAL 锟斤拷锟斤拷锟竭斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿后备伙拷锟斤拷锟斤拷锟叫关革拷锟狡斤拷锟饺碉拷锟斤拷息锟斤拷锟斤拷小频锟饺ｏ拷锟斤拷锟斤拷锟斤拷使锟斤拷pg_stat_replication锟斤拷图锟斤拷锟斤拷锟斤拷锟襟备伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟窖撅拷写锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟街疚伙拷谩锟斤拷锟斤拷丫锟剿拷锟斤拷锟斤拷痰锟斤拷锟揭伙拷锟轿伙拷锟斤拷约锟斤拷锟斤拷丫锟接︼拷玫锟斤拷锟斤拷一锟斤拷位锟矫★拷锟斤拷锟斤拷锟斤拷锟斤拷锟街碉拷潜锟斤拷锟街拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡★拷每锟斤拷写锟斤拷锟剿拷锟轿伙拷酶谋锟绞憋拷岱拷锟阶刺拷锟斤拷拢锟斤拷锟斤拷锟斤拷锟斤拷侔锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷指锟斤拷锟斤拷频锟饺凤拷锟酵★拷锟斤拷耍锟接︼拷锟轿伙拷每锟斤拷鼙锟斤拷锟绞滴伙拷锟斤拷锟轿拷秃蟆＝锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟姐将锟斤拷全锟斤拷锟斤拷状态锟斤拷锟铰★拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷默锟斤拷值锟斤拷 10 锟诫。

hot_standby_feedback (boolean)

指锟斤拷一锟斤拷锟饺后备伙拷锟角否将伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿后备伙拷锟斤拷锟斤拷锟叫癸拷锟节后备伙拷锟较碉拷前锟斤拷锟斤拷执锟叫的诧拷询锟侥凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷员锟斤拷锟斤拷锟斤拷懦锟斤拷锟斤拷诩锟铰硷拷锟斤拷锟斤拷锟铰的诧拷询取锟斤拷锟斤拷锟斤拷锟角匡拷锟杰碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷某些锟斤拷锟截碉拷锟斤拷锟捷匡拷锟斤拷锟酵★拷锟斤拷锟斤拷锟斤拷息锟侥凤拷锟斤拷频锟饺诧拷锟斤拷锟斤拷锟矫匡拷锟�wal_receiver_status_interval锟斤拷锟节凤拷锟斤拷一锟轿★拷默锟斤拷值锟斤拷off锟斤拷锟斤拷锟斤拷锟斤拷锟街伙拷锟斤拷锟�postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷

锟斤拷锟绞癸拷眉锟斤拷锟斤拷锟斤拷疲锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷未锟斤拷锟街憋拷锟斤拷锟斤拷锟襟到达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟襟备伙拷锟节斤拷锟秸碉拷锟斤拷锟斤拷之锟斤拷锟斤拷舜锟斤拷莞锟斤拷锟斤拷尾锟斤拷锟斤拷锟斤拷魏锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�

锟斤拷锟斤拷锟斤拷貌锟斤拷岣诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷系锟�old_snapshot_threshold锟斤拷锟斤拷为锟斤拷 锟襟备凤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷值锟侥匡拷锟秸匡拷锟杰伙拷锟矫诧拷锟斤拷锟矫ｏ拷 锟斤拷锟铰后备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟饺★拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿�old_snapshot_threshold 锟斤拷为锟剿讹拷锟斤拷锟斤拷锟斤拷锟杰癸拷锟斤拷锟节碉拷时锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷疲锟� 锟斤拷然锟酵伙拷锟斤拷为一锟斤拷锟襟备凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫讹拷锟斤拷违锟斤拷锟斤拷

wal_receiver_timeout (integer)

锟斤拷止锟斤拷锟节非活动状态锟斤拷锟斤拷指锟斤拷锟斤拷锟斤拷锟斤拷锟侥革拷锟斤拷锟斤拷锟接★拷锟斤拷锟斤拷锟斤拷锟斤拷诮锟斤拷盏暮蟊阜锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷峡锟斤拷锟斤拷谩锟街碉拷锟斤拷锟斤拷贸锟绞憋拷锟斤拷啤锟斤拷锟斤拷锟斤拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟叫伙拷锟节凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫★拷默锟斤拷值锟斤拷 60 锟诫。

wal_retrieve_retry_interval (integer)

指锟斤拷锟饺达拷锟斤拷锟斤拷锟斤拷应锟饺达拷锟洁长时锟斤拷时锟斤拷 锟斤拷锟斤拷锟皆硷拷锟斤拷WAL锟斤拷锟斤拷之前锟斤拷锟斤拷锟轿猴拷源 锟斤拷锟斤拷锟斤拷锟狡ｏ拷锟斤拷锟斤拷pg_xlog锟斤拷锟斤拷WAL锟介档锟斤拷锟斤拷WAL锟斤拷锟捷诧拷锟斤拷锟矫★拷 锟剿诧拷锟斤拷只锟斤拷锟斤拷postgresql.conf锟侥硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷谩锟� 缺省值锟斤拷5锟诫。锟斤拷锟矫伙拷锟街革拷锟斤拷锟斤拷锟轿伙拷呛锟斤拷搿�

锟剿诧拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫恢革拷锟节碉拷锟斤拷频却锟斤拷碌锟絎AL锟斤拷锟捷匡拷锟矫碉拷时锟斤拷锟斤拷锟斤拷 锟斤拷锟界，锟节归档锟街革拷锟叫ｏ拷通锟斤拷锟斤拷锟劫此诧拷锟斤拷锟斤拷值锟斤拷锟揭伙拷锟斤拷碌锟絎AL锟斤拷志锟侥硷拷锟斤拷使锟矫恢革拷锟斤拷锟斤拷锟斤拷锟叫ｏ拷 锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫匡拷锟杰的★拷锟斤拷一锟斤拷锟斤拷WAL锟筋动系统锟叫ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟剿憋拷要锟侥凤拷锟斤拷WAL锟介档锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷 一些锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟狡伙拷锟斤拷锟叫凤拷锟绞伙拷锟斤拷锟斤拷施锟斤拷时锟斤拷锟斤拷要锟斤拷锟斤拷锟斤拷锟节★拷

锟斤拷一页锟斤拷始页锟斤拷一页
预写式锟斤拷志锟斤拷一锟斤拷锟斤拷询锟芥划