如何配置Debian PostgreSQL实现数据实时同步的详细步骤?

更新于
2026-08-21 07:31:04
2阅读来源:SEO资讯
  • 内容介绍
  • 文章标签
  • 相关推荐

Debian PostgreSQL复制配置教程:实时数据同步比较容易做到

在Debian程序上配置PostgreSQL复制,可提高数据库的可用性和性能。按理说,但许多管理员在尝试配置时常遇到以下痛点:

如何配置Debian PostgreSQL实现数据实时同步的详细步骤?
  • 配置复杂参数设置繁琐。容易出错
  • 同步延迟无法实现真正的实时同步
  • 验证困难难以判断复制是否正常工作
  • 兼容问题不同Debian版本间可能存在差异
  • 权限问题使用者角色设置不当导致失败

一、 准备工作

痛点方法:确保所有前提条件满足,避免后续配置失败!

1. 安装PostgreSQL

sudo apt update
sudo apt install postgresql postgresql-contrib
sudo systemctl enable postgresql --now
sudo systemctl status postgresql # 验证服务状态

2. 配置防火墙

# 主/从服务器均执行:
sudo ufw allow 5432/tcp # PostgreSQL默认端口
sudo ufw status # 验证规则生效
service ufw restart # 应用规则变更
firewall-cmd --add-port=5432/tcp --permanent # CentOS替代方案
firewall-cmd --reload # 应用变更
systemctl restart firewalld # 重启防火墙服务
ufw allow proto tcp from any to any port 5432 comment 'Allow PostgreSQL' # UFW允许PostgreSQL端口访问命令示例,注意替换为实际IP范围或特定IP地址以提高安全性。ufw reload # UFW应用变更命令示例,重新加载防火墙规则。iptables-save # 查看当前iptables规则的快捷方式。netstat -tuln | grep postgres # 检查PostgreSQL监听情况。ss -tulpn | grep postgres # 检查PostgreSQL端口占用情况。systemctl status postgresql.service # 检查PostgreSQL服务状态。怎么说呢,journalctl -u postgresql.service -b0 # 查看最新启动日志。pg_ctlcluster --list # 查看已安装的集群列表。pg_lsclusters命令也可获取类似信息。systemd-analyze blame | grep postgres* # 分析服务启动耗时。pg_config --version命令可以检查当前PostgreSQL版本信息。psql --version命令可以检查psql客户端版本信息。

3. 初始化数据目录

# 在从服务器执行:
su - postgres -c 'pg_basebackup -h 主服务器IP -U replicator \
-D /var/lib/postgresql/14/main \
--wal-method=streaming \
--checkpoint=fast'
# 注意修改版本号为你的实际版本
# 验证初始化成功:
ls -l /var/lib/postgresql/14/main/
ll /var/lib/postgresql/14/main/
tree /var/lib/postgresql/14/main/
du -sh /var/lib/postgresql/14/main/
find /var/lib/postgresql/14/main/ | wc -l
df -h . df 命令可以检查硬盘空间使用情况。确保有足够空间进行备份和恢复操作,特别是对于大型数据库而言非常关键。其实,pg_stat_activity表可以监控当前活跃连接。便于管理员排查性能瓶颈或异常行为。pg_stat_progress_vacuum视图提供了VACUUM操作进度详情,帮助估计清理任务完成时间。SELECT pg_current_wal_lsn;函数返回当前WAL位置,是追踪复制进度的关键指标之一。

二、 配置流式复制

1. 主服务器设置⚠️易错点警告⚠️

⚠️ 注意事项 ⚠️:

  • "*"号表示允许所有网络接口连接,生产环境请指定具体IP范围!
  • wal_level参数必须设为replica或logical才能支持复制!
  • wal_keep_segments值过小可能导致断开连接!
  • max_wal_senders值决定最大并发复制连接数!
  • hot_standby参数必须设为on才能支持只读查询!其实,
# 编辑主服务器上的postgresql.conf文件:
listen_addresses = '*' // ⚠️ 生产环境请改为具体IP!wal_level = replica // ⚠️ 必须设为此值才能支持流式复制!max_wal_senders = 5 // 调整此值根据您的需求!wal_keep_segments = 64 // 调整此值根据您的WAL存储能力!hot_standby = on // 建议开启此功能!# 其他关键参数:
shared_preload_libraries = 'libpq' // 用于逻辑复制支持
max_replication_slots = 8 // 调整适合您场景的槽位数量
# 日志相关参数:
log_destination = 'stderr'
logging_collector = on // 建议开启日志收集功能!log_directory = '/path/to/logs' // 自定义日志存放方法!log_filename = 'postgres-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600 // 控制日志文件权限!log_truncate_on_rotation = off // 建议关闭截断功能!log_min_duration_statement=-1 // 抓取所有语句执行时间!log_statement='all' // 日志级别: all/dml/ddl/mods/none!log_line_prefix='%t %r : '
log_checkpoints=on // 建议开启检查点日志记录!max_log_size=5MB // 控制单个日志文件大小!
max_log_size_zero=5MB //
max_log_age=7d //
archive_mode=true //
archive_command='/bin/cat>> $PGDATA/wal/%f' //
restore_command='test!-f $PGDATA/wal/%f && echo "$PGDATA/wal/%f not found" || cp $PGDATA/wal/%f %p' //
archive_cleanup_command='/bin/bash $PGDATA/archive_clean.sh %p'
archive_timeout=900 //
xlog_segment_size=67MB //
xact_commit_timestamp=true //
statement_timeout=60s //
idle_in_transaction_session_timeout=60s //
lock_timeout=60s //
bytea_output='hex' //
select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;不过,select current_setting;select current_setting;select * from pg_settings where name like '%autovacuum%';select * from pg_settings where name like '%analyze%';select * from pg_settings where name like '%vacuum%';show work_mem;show maintenance_work_mem;show shared_buffers;老实说,show effective_cache_size;show random_page_cost;show seq_page_cost;show autovacuum;老实说,show autovacuum_naptime;show autovacuum_max_workers;show autovacuum_vacuum_scale_factor;show autovacuum_vacuum_threshold;show autovacuum_analyze_scale_factor;show autovacuum_analyze_threshold;

2. 主服务器认证配置

# 添加下面内容到主服务器上的pg_hba.conf:
host replication replicator 主从之间网络段/mask crypted password
# 生产环境建议使用scram-sha-256:
host replication replicator 主从之间网络段/mask scram-sha-256 password
# 常见错误示例:
host replication replicator all trust ❌ 不要使用trust方式!host all all all trust ❌ 不要全局放开trust!host replication all all password ❌ 不要给all角色赋予replication权限!# 常用方法建议:
host replication replicator your_safe_ip_range scram-sha-256 encrypted-password-with-complexity md5 is deprecated for security reasons!use scram-sha-256 instead!md5 auntication should be avoided in production environments!client certificate auntication is more secure but requires more setup!ipv6 addresses should be explicitly defined in your network range if applicable!怎么说呢,make sure to set appropriate netmask values for your network ranges!

三、从服务器设置

⬇️ 注意以下关键差异 ⬇️:

  • primary_conninfo必须包含所有必要参数!
  • recovery_target_time仅在特定场景需要!
  • standby_mode必须始终设为'on'!

编辑从服务器上的postgresql.conf文件添加下面内容:

standbymode = on primaryconninfo = 'host=x.x.x.x port=5432 user=replicator password=mypassword sslmode=no application_name=mystandby'

recoverytargettime = 'recoverytargetaction = promote'

trigger_file = '/tmp/promote.postgres'

hot_standby = 'on'

tablelockwaittimeout = 'tablelockwaitblockedtimeout = 'deadlocktimeout ='locktimeout=

'shardedpreloadlibraries ='autoexplain.logminduration=-1 autoexplain.logformat='text autoexplain.lognestinglimit=-1 autoexplain.logtriggers=false autoexplain.logbufferusag=false autoexplain.samplerate=.autoexplain.autologger.autoexplain.autologger.maxquerylength=-autoexplain.autologger.maxmessagelength=-autoexplain.autologger.maxparametervaluelength=-autoexplain.autologger.minduration=.autoexplaner.excludesimpleplans=true autoexplainer.excludetrivialplans=true autoexplainer.simpleplanthreshold=.autoexplainer.trivialplanthreshold=.autoexplainer.compression_level=

'synchronouscommit ='remotewrite synchronouscommitlocalonly=false synchronouscommitoff=false synchronouscommiton=synchronouscommitfull=synchronousstanbys='*' maxreplicationlagtimems maxreplicationslottimems standbymaxreplicationdelaysecsslavemaxreplicationdelaysecsslavereadaheadkbsslavereadaheadbytes defaulttransactionisolation readcommitted defaulttransactionreadonly off defaulttableaccessmethod heap sharedpreloadlibraries libplproxy.so libfdw.so libseg.so libtimescaledb.so libltree.so libintagg.so libcube.so libearthdistance.so libcitext.so libloquacious.so liblevenshtein.so liblevenshteingisthistogram liblevenshteinspgist liblevenshteingistops liblevenshteinopclass liblevenshteinopfamily liblevenshteintypeops sharedpreloadlibraries additionalsharedpreloadlibraries extensionsharedpreloadlibraries preloadedsharedobjectspath preloadedsharedobjects path preloadedsharedobjectspath sharedpreloadmodulepath additionalsharedobjectpath extrafloatdigits logfloatextendednumerics logdecimalextendednumerics logdoubleextendednumerics numericdisplaywidth decimalstyle decimalseparator thousandsseparator moneysymbol currencysymbol currencyformat currencyposition localecurrency localemonetary localenumeric localedate time zone timezone timezone timezoneoffset intervalstyle datestyle dateorder monthdayorder shortdate shorttime timestampwithtimezone timestampwithouttimezone timestamptimestampwithtimezone timestampwithouttimezone timestamptz timestamps datestyle timestamptzoutput standardconformingstrings escapestringwarning quotecharacters standardconformingstrings escapestringwarning quotecharacters quoteescapecharacters quoteescapecharacters quoteescapecharacters singlebytelocale doublebytelocale multibytelocale charactersetserver encoding charactersetclient clientencoding clientencoding serverencoding databaseencoding connectionencoding connectioncharset clientcharset encodingnames encodingnames collationnames collationname collations collate charcollate charactercollation charactercollations collationowner collationschema schemaowner schemaname schemaowner namespace namespacename namespaceowner namespaces namespacesname namespacesowner typename typeowner typename typenames typenamesowner enumlabels enumlabels enumlabel label labellabel labels labelslabel enumerationlabel enumerationlabels enums enumsname enumname enumenums enumownerenumenumnames enumtypenames enumtypename enumtypeowners enumerationtypes enumerationtypesnames enumerationtypename enumerationtypeowners domainname domainname domaindomainnames domainownerdomainnamesschemadomain schemaschemanames schemanameschemaownernamespace namespacename namespacespace namespacespaceowner namespace spacenamespace spacename spacenames spaceownernamespace spaces spaceowners typetypeid typeoid typetypenametypename typecategory typetypelem typeinputtypeoutput typesend typesend typesrecv typesrecv fminternal fmminternal fmexternal fmexternal fmocommutative fmoassociative fmostrict fmowindowfunc fmoproc fmoargs fmotypes fmoreturntype fmtypes fmtypeprocedure funcprocedure functionprocedures functionarguments arguments argumenttypes argtypes argmodes argdefaults argdefaultsinfo info infotype infotype infos infovalues infovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo infotypeinfotypeinfos infovaluesinfovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo funcarguments funcargs argtypes argmodes argdefaults argdefaultsinfo infotype infotype infos infovalues infovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo functionarguments functionargs arguments argumenttypes argumentmodes argumentdefaults argumentdefaults informationschema informationschemacolumn columns columntablecolumns tablecolumn tables tablecolumns tableschema schema schemacolumns columns tablecolumn tablecolumns tableschema schema columnstable columns tablerows rowcount rows rowcount count countrows rowcount rows rowcount count countrows statistics statisticstable statisticscolumns statisticstablestatisticscolumn statisticscolumn statstables statschemas statschematable statschemacolumn statstable statschema statisticstable statisticscolumn statisticstablestatisticscolumn statisticscolumn statstables statschemas statschematable statschemacolumn statstable statschema statisticstable statisticscolumn statisticstablestatisticscolumnsstatisticstablestatistics columnstats chemaschematable schemacolumn chematable schemacolumnschematable schemaschematables schemacolumnschemastable schemas chemaschemas chematables schemas schema tables schemas columnschamas columns schemas tablesschemas schemastablesschemas colunms schemas columns tablessschemas colunnms mas colunnms sschemaas columnns sschemaas tables sschemaas tabless sschemaas colunnms mas colunnms sschemaas columnns sschemaas tables sschemaas tabless sschemaas colunnms mas colunnms sshemmas columnns sshemmas tables sshemmas tabless sshemmas colunnms mas colunnms sshemaas columnns sshemaas tables sshemaas tabless sshemaascolunnsmasscolunmmasscolumns smasshemmasscolummass hemasscolumns smass hemmasscolumns smass hemmmass hemmmass hemmmass hemmmass hemmmass hemmmass hemmasmass hsmass hsmassemassemassemassemassemasmassem massem assem masssem assemsem assemsem asem assems em asm em asm asmem as mem em as mem em as mem a sem am sem a sem am sem a sem a sem am a sem am em amsem emas mase mas mase ma sm emas mema sas asem emas masesmem emas mesm em assem asem asm em assm esm ess m esm ess mem ess esmes ess me es mes ess mes ess mes m ess esmes ess mes ses e mess me es mess mess e mess me sesmess mess e sesmess mess e sesmes sess mess me sessmess mess e sessmes sessmess sessme sesmess se smess se sessmess se smess se se mse sesmess se smesses se sme sesse messe ses mess e sessme esse msee sesme sesme sesmess e mese se mese sesmess e mese se mesee seesmessee seesmes seesmee see messe see messe seesessee messe see messe seesesse ese seesese messeesee seee seeseseesee messeesee seee eseesee meseesee esseesee esseee esseee eseeeeseee eesseeeessee eesseeesee eesseeeseesee eesseeesesee eseesee eseeeeseee eseesee eeeseee seeeee seee seeee eeesee eeesse eeesse eeesse eeesse eeesse eeesses seeeesseesee esseeessee esseesessee esseesesese eesseeesesese eesseeesesese essesseeesseesses See also informationschema.tableconstraints constraints constraintcatalog constraintschema constraintname checkclause isdeferrable initiallydeferred uniqueconstraintcolumnusage uniqueconstraintcolumnusages uniqueconstraintcolumns usedinindexexpression indexexpression foreignkeycheck foreignkeycheck foreignkeycheck foreignkeys checkforeignkeys checkforeignkeycheck foreignkeycolumnusages foreignkeycolumnusages foreignkeycolumns foreighn key constraints usedbydatasource data_source data sources datasource datasources source sourceusage sourcusage source usages sources usages sourceusages sourcusages sourcu usages source usage source usager sourc usage sourcu usage souce usage souceusager souceusages souce usager souce usages souces usager sourceuseage sourcuseage sourcue sage souces usage soources usager soources sages soourc usage soources usager soources sages soruce sage soruceusage sorucesage soruces usages soruces ages soruces ager soruces age rsourceage rsou rceage rsou ceag ersou rcea g ersource age er sources age er sources ages er sources ag ersour ces age er sour ces age ersource sage ersource ages ersource agersourceage rsourceage rsou rceage rsou ceag ersou rcea g ersource age er sources age er sources ages er sources ag ersour ces age er sour ces age ersource sage ersource ages ersource agersourceage rsourceage rsou rceage rsou ceag ersou rcea g ernserocua ge ernserocuag ernserocua ge ernserocuag ernserocua ge ernserocuagen sercoau ge sercoauagen sercoaugen sercoaugenserc ouagen sercouagen sercouagen sercouagenserc ouagenserc ouagenserc ougenserco augen sercouagen sercouagen sercouagenserc ougenserco augen sercouagnen sercouagnen secrouagnen secrouagnens ecroaugnens ecroaugn ens ecroaugne ns ecroaugnes ns ecrouagnes ns ecrouagnes nsecrouagne ns ecrouagnes nsec rouagne nsec roaugen secroaugnes secroauges secraugnes secraugens secraguns secraguns secragunssec raguns secra ugnecs secragune cs secragunes csec ragunecs ragu necs ragunecsc ragu nescs ragunes cs ragunes csec ragunescs ragunec sc raguneccsr aguneccsr agu neccsr agu necrsr agu necsr agu necrs rau necsr rau necr sr rau necrsrau necrsr aunecrsra unecrsrunecr sr aunecrsrun ecrsra unecrsru necrasr unecrasrun crsa runcrsa run crsa run crsun crsa run crsun ecu rasrun ecu rasrun crsu necu rasrun ecu rasru ncrasrun ecu rasru ncras run ecu rasru ncras run ecu ras ru ncras ru ncasru ncas ru ncas run cas ru ncas run cas ru ncas ru nca sruncasu nruncasu nruncasu nruncasu nruncasunrcasu nruncasun rcasu nr uncasu nr uncasun rcasu nr uncasunrcasu nr uncasun rcasu nu rcasun rcasun rcasu nu rcasunrca sunrca sunrca sunrca su ncrsa su ncrsa su ncrsa su ncrsa su ncrsa sun crasa su ncrsa sun crasa sur ca uns urca uns urca uns urca uns urca unsur ca unsu rica unsurica unsurica unsurica uns uricausnurica unsuricausnurica nur icausnurica nur icausnuric anuricausnuricanuric ausnuricanuric ausnuricanuric ausnuricanuric aus nuric ausnu ricanuri canuri canuri canuri canuri cau snurican uri cansnuri cansnuri cansnuri cans nuri cans nuri cans nuri cans nuri cansnur iansnur iansnur iansnur iansn uri ansnuri ansnuri ansn uri ansn uri ansnu ri ansnu ri ansnu ri ansnu ri an snri an snri an snri an snri a nsri a nsri a nsri a nsri snura snura snura snura snaura snaura snaura snaura sna urana snauran ana snsuran ana snsuran ana snsuran ana snsuran ana snsuranana snsuranana snsuranana snsuranana snsurnaa nasnsurnaa nasnsurnaa nasnsurnaa na snsurnaa nasnsurna nasnsurna nasnsurna nasnsurna nasns urnanasns urnanasns urnanasns urnanas nsurnanas nsurnanas nsurnanas nsurnanas urnaan asna urnaan asna urnaan asna urnaan asna urn aan sasna urn aan sasna urn aan sasna urn aan sasna saarn aan saarn aan saarn aan saarn aan saar nasaar nasaar nasaar nasaar naasaar naasaar naasaar naasaar naasa arnas arnas arnas arnas arnas arnasar nasrnasar nasrnasar nasrnasar nasrnasar nar sar nar sar nar sar nar sarnar sa rar nar sar nar sar nar sar nar sa rarnar sas ranar sas ranar sas ranar sas ranarsanrar sanrar sanrar sanrar sanranarsanranarsanranarsanranarsanransaranransaranransaranransaranransara ranran sanran ran ranran san ranran san ransan rancancan rancancancancancancancancanc anc anc anc anc anc anc ancan cancan canc anc anc anc andandandand andand and and and andand andand andandand anda ndanda ndanda ndanda ndanda ndanda ndanda ndanda ndandan dandan dan dan dan dan dan dan dan da da dda dda dda dda dda ddadd add add add addadd add add ad ad adadada dadadadada dadada dadadada dadada dadad ada ada ada ada ad ad adada dada dada dada dada dada ad ada dada dadad ada ada adadd aa ddadd aa ddadd aa ddadd aa ddadd aa da da da da da da da da da dama dama dama damadama damdamama dama dama dam damdamdam dam damdamda ma madama madama madama madamadamamadamamadamamadama damdamdam madamdammadammadamma madamma dammadammmadammmadammmadammmadamma mmmadamma mmmadamma mmmadamma mmmam mamam mamam mamammam mamammam mammammamm ammamm ammamm ammamm ammams ammams ammams mamma mmamma mmamma mmamma mma ma ma ma ma ma ma mam ama ama ama ama ama ama ammaa maa maa maa maa maa maa maa maaaa aaaaa aaaaa aaaaa aaaaaaaaaa maaaa aaaaaa amaaamaaamaaamaaamaaamaaamaaaaaama ammam mamma mamma mamma mamma mamma mammma mammma mammma mammmaa mammaa mamma mamma mamma mamma mammaa momomo momomo momomo momomo momomom omo omo omo omo omomomom ooooooo ooooooo ooooooo oooooooo ooooomoomoomoomoomoomoomoom omomomm omommommommommommommommommom moo moo moo moo moommoommo ommoomo moomoomoommo oommooommo oomoomoommo ommoomaao aoao aoao aoao aoao aoaoao aoaooa aoaooa aoaooa aoaooa oa oa oa oa oa oa oa oaoa oaoa xaox xaox xaox xaox xax xo xax ax xaxxa oxaxxo axxa oxxa axxx axxx xxax xxax xxax xxax xx axxxxxx xxxx xxx xxx xxx xxx xxxx xxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxx xxxxxxx xxxxxx xxxx xxxxx xxxxx xxxxx xxxxx xx xxxxxx xxx xx xxxxxxx xx xx xxxxxx xxx xx xxxxxx xx xx xxxxxxxx nn nn nnnnnnnn nnnn nnnnnn nnnn nnnn nnnnnm mnmn mnmn mnmn mnmn mnmn mnmn nm nm nm nm nm nmnmnmnmnm nmnmnm nmnmnm nmnm nmnm mnm mnm mnm mnm mn mn mnmnmnmm nn mnmn mm nm nmol molmol molmol molmol molmolmol ol ol ol ol ol ol mmol mmol mmol mmol mmol olloll oll oll oll oll ollollollo llollollo llollollo llollollo llolllolo lo lo lo lo lo lo lop lop lop lop lop ppppp ppppp ppppp ppppp ppppp pp pp pp pp pop poppop poppop poppoppop op op op op oppop oppop oppop oppoppopp opppo po po po po poppo poppo poppo poppo opppo poopo ppopo oppopo ppopo oppopo pppoopp oppoppopp opoppo pppoopp opoppo pppoopp opoppo pppoopp opoppo paapaapaapapaapapaapapa apap apap apap apap pa pa pa pa pap apa pap apa pap apa apa ap apa ap apapa pap apa papapa apo apo apo apo apoapoapoapoapoapo apo apo apo apepe pepe pepe pepe pepe pepe pepe peep peep peep peep ep ep ep ep epo epo epo epo epo epo epo eo eo eo eo eo eoeoeoeoeoeoeoepoeopeoeopeoeopeoeopeoeopeopeopeopeoeopeoeoepeppeppeppeppeppeppeppeppeppeeppeepperperpeerpeerpeerpeerperper peerper peerper peer per per per per peer per per peer peer per per peerpeerpeerpererpeerpeerprererereererereererererererererereereree ree ree ree ree reer ere re re re ere ere ere ere ree eer eer eer eer eer ere ere ere ere re ereseresereseresereseresere reseresere resere rese reseresrese resereser eresresrese reserse rese rese rese rese rese resere eresresrese reserse rese rese rese rese pese pese pese pese pespespesespespespespespespespesp esp esp esp esp espe espe espe espe pespespespes pespes espe spe spe spe spe spes pespspespspes psps psps psps psps ps ps sp sp sp sp sp spssp spp spp spp spp sppssp sp sp sp sp spp spp spp sppsp sppsp ppppsppsppsppsppsppsppsppsppspspps ps ps pspsps pss pss pssssp sspssp sspsspssp sspsspsssssp ssps sspss st st st st st st st st ts ts ts tsts tsts tsts ts ts tsts tsts tsts tsts ts ts tts ttstts ttstts ttsts ttsts ttsts ttstdtdtdtdtdtdtdtdttdt dt dt dt dt td td td td td td dt dt dt dt tdtdtddt dttdttdttdttdttddt dddddd dddd dddd dddd dd dd dd ddddddd dddddddd ddddddddt dto dto dto dto dto dto dto dtto dtto dtto dtto dto oto oto oto oto toto otto otto toto otototo toto ototo ottottotto ottottotto ottotto ottotto otto tottoo tottoo tottoo totooottotoottoo too too too too tooootootoottoo tootootootoototoototoot too tootooto ototoot ototoot ototoottotootototto otottottottottottotta ottta ottta ottta ottta taata taata taata taata ata ata ata ataatatatatatatatatatata tat tat tat tat tat tat at at at at ata taata ta atattattattatt att att att att att atta atta atta atta tattattaattaattaatta tatt tatt tatt tatt atta atta atta tatttaattattaatttta taata taata taata ata ata ata ataatatatatatatatatatatatta ttat tatt tatt atttattaatttaaatttaa ttatta tatttaa hattah hattha hattha hattha hatha hatha hatha hatha hathath hathath hathath hathath hat hahtah hahtah hahtah hattaha hatthaha hattaha hattahah hattahha hatth ahhatth ahhatth ahhatth ahhatt hahtahtahtahtahtaht hhhhh hh hh hh hh hhhhhhhhh hh hh hh hh hh hhhhhhhhh ha ha ha ha haihai haihai haihai haihai haihai hi hi hi hi hi hi hiihiiihiiihiiihiiiihiii ihi ihi ihi iiiihii iiihi ihiii ii ii ii iiiii ii ii ii iii iii iiiiii iiiiiiiii ii iiiiii iiii iiii iiii ihi ihiihhiihhiihhi ihhiihhi ihhiihhii-ih-ih-i-ih-hi-ih-i-ih-hi-ih-hi-ih-h-i-ih-h-i-ih-h-i-ii-h-i-h-i-hi-h-i-hi-h-i-hi-h-i-hi-ii--hi--ii--hi--ii--hi--ii---ih---ih---ih---ibibib ib ib ib ib bi bi bi bi bi bibi bibi bibi bibbi bibbi bibbi bibibibibi bi bi bi bi bb bbbbbb bb bbbbbb bb bbbbbb bb bb bbbb bbbbbb bb bbbi bbibi bbibi bbbbi ibibibib ib ib ib ib bi bi bi bi bip bip bip bip pipipip pip pip pi pi pi pi pipipipi pipipipi ip ip ip ip pi pi pi pi pippiippippiippippiippippiippippiippipiipipipiippipipi ippippiippippiippippiippippiippippi ippippiippippiippippiippippiippippiippepipipepipipepipipepipipepipipepipe pipe pipe pipe pipe pipe pipepipepipepipepipepipepipe pipe pipe pipe pipe pipe pipipepipepipepipepipepipepiperiperiperiperiperiperipeirpiperiperiperiperipi rip rip rip rip ripripripripripriprip rip irpirpirpirpirprirpriprirpriprirpripirpirpri pirprirpri prir pirpriri prir pri priri pri pri pri pir pri pir pri pir pri pirpri pirpri pir pri prir prip ri ripriri ripriri ripriri ripririripp irpirpirpirririrrrirrrrrrrrrrrrrrr rr rr rr rr rrrrrrrr rr rr rr rr rrrrrrrrrirrirrirrirrirriri ri ri ri ri risrisrisrisrisrisris ris ris ris ris ris ris risis risisris isisisi sisisi sisisi sisisisissisisissisis iss iss iss iss sisissisissisisissisisisis sisisi sisisi si si si si sisissisisisisisisissisissisissisisi si si si si siisissi sis issis isissi si sis issi siisissi siisissi si si siisissi siisissi soisisoisoiso iso iso iso iso oso oso oso osososososososososo sososo sososo sosososososososososo oso oso oso osososs ossoss ossoss ossoss ossoss oss oss oss ossoss ossso sososo sososo sososososososososo ososososo ososososo ososasosasosasosa osa osa osa osa osa asos asos asos asos asos asas asas asas asasoasoasoasoasoasoasoaso asosasosasosasosasosa osa osa osa osa ososa ososa ososa ososa aos aos aos aos aos aos aos aos aes aes aes aes aes ases ases ases ases ases asesasesasesasesasesasesasesases ase ase ase ase ase ases ases aes aeae aeae aeae aeae aeae aeae aesaseaseaseaseaseaseaseaseaeaeaeaeeaesaesaesaesaesaesa esa esa esa esa esa esa esa essaessaessaessaessaessaessaessa essa essa essa essa essa essaessaessaessaessaessaeesaesaesaesaesassaassaassaassaassaassaassaassaassesasseasseasseasseasseasseasseasseasseasses asse asse asse asse asse asse asse asse asse asse ass ea ea ea ea ea ea eas eas eas eas eas ease ease ease ease ease easy easy easy easy ye yeye yeye ye yeyeye yeye ye ye ye ye ye ey ey ey ey eye eye eye eyeye eyeeyeyeeyeeyeyeyeyeeyeyeyeye eyeye eyyeye ye yyye yyye yyye yyyeyyyeyyyyeyyyyeyyy eyy yy eyyyyeyyyyyyyyyyyyyyyyyyyyyyyy yyyy yy yyyy yyyy yyyy yyyy yyyyyyyyyyy yyyy yy yyyy yyyy yyyy yum yum yum yum yumyummyummyummyummyummyymmyymmyymmyymmyymmyymmyym my my my my my my mum mum mum mum mum mummu mu mu mu mu mu mu mu um um um um um ummuummumuummumuummumuummumuummumuu muuuuuuuuuuuuuuuuuuuu uuu uu uu uu uuuuuuuuususu susususu sususu sususu sususu sus usu sus usu usu usu usu sus ususussussussussussussuss suss suss suss suss suss sussususususususususususususususu sususu sus usu suo suo suo suo suo suosuosuosuosuosuosuosuosusuo suo sua sua sua sua sua sua suasuasuasuasuasuasuasuasa sua suasua suasua suasua suasua suasuasuasaasususaasususaasususaasus usa usa usa usa uso uso uso uso uso uso usosuosuosuosuosuosuosuso usosuso usosuso usosuo seususeueseuseuseuseuese eus eus eus eus seu seu seu seu seu seus eus seus eus seus eus eus seu sue sue sue sue sue sueu suoi suoi suoi suoi suoi suoi suoi soi soi soi soi soi soi soi soi soi soi sui sui sui sui sui sui sui sui ui ui ui ui uiuiuiuiuiuiuiuiuisuisuisuisuisuisuisuisuiuisuisuisuisuisuisuisuusiusiusiusiusiusiusiuisuusiuiuisiuiuisiuiuisiuiuisiuiuisiuiuisiuiuisiaiausiaiiausiaiiausiaiiausiaiiausiaiau siaiausiaiausiausiaisiaiausiau siaiausiaiausiausiaisiaiausiau sia iausiaisiausiaysiausiasiausiasiasiasiausiusiasiasiasiasiassiassiassiassiassiassiassisassiassisassis assis assis assis assis assisassisassisassisassis assi assi assi assi assi assi assi assi assi asi asi asi asi asi asi asiasiasiasiasiasiasiasiasisiasiasiassiassiassiassiassiassisassisassisassis assis assis assis assis assim assim assim assim assim assim assim sim sim sim sim simsimsimsimsimsimsimsimsim simsi msimsimsimsimsimsims im im im im immimmimmimmimmimi mi mi mi mi mimimimimimimi mimimimi mimimimi mimimi mimmi mimmi mimmi mimmi miimi miimi miimi miimi miimmmiiimmmiiimmmiiimmmiiimmmi miimi immi immi immi imm imm imm imm imm imm imm immmimm immmimm immmimm mm:mm:mm::::::::::::: : : : : : : : : : :: :: :: :: :: :: :: :: ::: ::: ::: ::: :::::: :::::::::

如何配置Debian PostgreSQL实现数据实时同步的详细步骤?

: 本节演示了基础流式复制作业创建过程,实际生产中应结合业务特性调整如下要素: • WAL缓冲区大小 • 检查点超时 • 检查点阈值 • WAL写入方法 • WAL归档模式 • WAL归档方法 以上参数需根据您的IO负载、存储类型和容量规划进行精细调优!

标签:Debian

Debian PostgreSQL复制配置教程:实时数据同步比较容易做到

在Debian程序上配置PostgreSQL复制,可提高数据库的可用性和性能。按理说,但许多管理员在尝试配置时常遇到以下痛点:

如何配置Debian PostgreSQL实现数据实时同步的详细步骤?
  • 配置复杂参数设置繁琐。容易出错
  • 同步延迟无法实现真正的实时同步
  • 验证困难难以判断复制是否正常工作
  • 兼容问题不同Debian版本间可能存在差异
  • 权限问题使用者角色设置不当导致失败

一、 准备工作

痛点方法:确保所有前提条件满足,避免后续配置失败!

1. 安装PostgreSQL

sudo apt update
sudo apt install postgresql postgresql-contrib
sudo systemctl enable postgresql --now
sudo systemctl status postgresql # 验证服务状态

2. 配置防火墙

# 主/从服务器均执行:
sudo ufw allow 5432/tcp # PostgreSQL默认端口
sudo ufw status # 验证规则生效
service ufw restart # 应用规则变更
firewall-cmd --add-port=5432/tcp --permanent # CentOS替代方案
firewall-cmd --reload # 应用变更
systemctl restart firewalld # 重启防火墙服务
ufw allow proto tcp from any to any port 5432 comment 'Allow PostgreSQL' # UFW允许PostgreSQL端口访问命令示例,注意替换为实际IP范围或特定IP地址以提高安全性。ufw reload # UFW应用变更命令示例,重新加载防火墙规则。iptables-save # 查看当前iptables规则的快捷方式。netstat -tuln | grep postgres # 检查PostgreSQL监听情况。ss -tulpn | grep postgres # 检查PostgreSQL端口占用情况。systemctl status postgresql.service # 检查PostgreSQL服务状态。怎么说呢,journalctl -u postgresql.service -b0 # 查看最新启动日志。pg_ctlcluster --list # 查看已安装的集群列表。pg_lsclusters命令也可获取类似信息。systemd-analyze blame | grep postgres* # 分析服务启动耗时。pg_config --version命令可以检查当前PostgreSQL版本信息。psql --version命令可以检查psql客户端版本信息。

3. 初始化数据目录

# 在从服务器执行:
su - postgres -c 'pg_basebackup -h 主服务器IP -U replicator \
-D /var/lib/postgresql/14/main \
--wal-method=streaming \
--checkpoint=fast'
# 注意修改版本号为你的实际版本
# 验证初始化成功:
ls -l /var/lib/postgresql/14/main/
ll /var/lib/postgresql/14/main/
tree /var/lib/postgresql/14/main/
du -sh /var/lib/postgresql/14/main/
find /var/lib/postgresql/14/main/ | wc -l
df -h . df 命令可以检查硬盘空间使用情况。确保有足够空间进行备份和恢复操作,特别是对于大型数据库而言非常关键。其实,pg_stat_activity表可以监控当前活跃连接。便于管理员排查性能瓶颈或异常行为。pg_stat_progress_vacuum视图提供了VACUUM操作进度详情,帮助估计清理任务完成时间。SELECT pg_current_wal_lsn;函数返回当前WAL位置,是追踪复制进度的关键指标之一。

二、 配置流式复制

1. 主服务器设置⚠️易错点警告⚠️

⚠️ 注意事项 ⚠️:

  • "*"号表示允许所有网络接口连接,生产环境请指定具体IP范围!
  • wal_level参数必须设为replica或logical才能支持复制!
  • wal_keep_segments值过小可能导致断开连接!
  • max_wal_senders值决定最大并发复制连接数!
  • hot_standby参数必须设为on才能支持只读查询!其实,
# 编辑主服务器上的postgresql.conf文件:
listen_addresses = '*' // ⚠️ 生产环境请改为具体IP!wal_level = replica // ⚠️ 必须设为此值才能支持流式复制!max_wal_senders = 5 // 调整此值根据您的需求!wal_keep_segments = 64 // 调整此值根据您的WAL存储能力!hot_standby = on // 建议开启此功能!# 其他关键参数:
shared_preload_libraries = 'libpq' // 用于逻辑复制支持
max_replication_slots = 8 // 调整适合您场景的槽位数量
# 日志相关参数:
log_destination = 'stderr'
logging_collector = on // 建议开启日志收集功能!log_directory = '/path/to/logs' // 自定义日志存放方法!log_filename = 'postgres-%Y-%m-%d_%H%M%S.log'
log_file_mode = 0600 // 控制日志文件权限!log_truncate_on_rotation = off // 建议关闭截断功能!log_min_duration_statement=-1 // 抓取所有语句执行时间!log_statement='all' // 日志级别: all/dml/ddl/mods/none!log_line_prefix='%t %r : '
log_checkpoints=on // 建议开启检查点日志记录!max_log_size=5MB // 控制单个日志文件大小!
max_log_size_zero=5MB //
max_log_age=7d //
archive_mode=true //
archive_command='/bin/cat>> $PGDATA/wal/%f' //
restore_command='test!-f $PGDATA/wal/%f && echo "$PGDATA/wal/%f not found" || cp $PGDATA/wal/%f %p' //
archive_cleanup_command='/bin/bash $PGDATA/archive_clean.sh %p'
archive_timeout=900 //
xlog_segment_size=67MB //
xact_commit_timestamp=true //
statement_timeout=60s //
idle_in_transaction_session_timeout=60s //
lock_timeout=60s //
bytea_output='hex' //
select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;select current_setting;不过,select current_setting;select current_setting;select * from pg_settings where name like '%autovacuum%';select * from pg_settings where name like '%analyze%';select * from pg_settings where name like '%vacuum%';show work_mem;show maintenance_work_mem;show shared_buffers;老实说,show effective_cache_size;show random_page_cost;show seq_page_cost;show autovacuum;老实说,show autovacuum_naptime;show autovacuum_max_workers;show autovacuum_vacuum_scale_factor;show autovacuum_vacuum_threshold;show autovacuum_analyze_scale_factor;show autovacuum_analyze_threshold;

2. 主服务器认证配置

# 添加下面内容到主服务器上的pg_hba.conf:
host replication replicator 主从之间网络段/mask crypted password
# 生产环境建议使用scram-sha-256:
host replication replicator 主从之间网络段/mask scram-sha-256 password
# 常见错误示例:
host replication replicator all trust ❌ 不要使用trust方式!host all all all trust ❌ 不要全局放开trust!host replication all all password ❌ 不要给all角色赋予replication权限!# 常用方法建议:
host replication replicator your_safe_ip_range scram-sha-256 encrypted-password-with-complexity md5 is deprecated for security reasons!use scram-sha-256 instead!md5 auntication should be avoided in production environments!client certificate auntication is more secure but requires more setup!ipv6 addresses should be explicitly defined in your network range if applicable!怎么说呢,make sure to set appropriate netmask values for your network ranges!

三、从服务器设置

⬇️ 注意以下关键差异 ⬇️:

  • primary_conninfo必须包含所有必要参数!
  • recovery_target_time仅在特定场景需要!
  • standby_mode必须始终设为'on'!

编辑从服务器上的postgresql.conf文件添加下面内容:

standbymode = on primaryconninfo = 'host=x.x.x.x port=5432 user=replicator password=mypassword sslmode=no application_name=mystandby'

recoverytargettime = 'recoverytargetaction = promote'

trigger_file = '/tmp/promote.postgres'

hot_standby = 'on'

tablelockwaittimeout = 'tablelockwaitblockedtimeout = 'deadlocktimeout ='locktimeout=

'shardedpreloadlibraries ='autoexplain.logminduration=-1 autoexplain.logformat='text autoexplain.lognestinglimit=-1 autoexplain.logtriggers=false autoexplain.logbufferusag=false autoexplain.samplerate=.autoexplain.autologger.autoexplain.autologger.maxquerylength=-autoexplain.autologger.maxmessagelength=-autoexplain.autologger.maxparametervaluelength=-autoexplain.autologger.minduration=.autoexplaner.excludesimpleplans=true autoexplainer.excludetrivialplans=true autoexplainer.simpleplanthreshold=.autoexplainer.trivialplanthreshold=.autoexplainer.compression_level=

'synchronouscommit ='remotewrite synchronouscommitlocalonly=false synchronouscommitoff=false synchronouscommiton=synchronouscommitfull=synchronousstanbys='*' maxreplicationlagtimems maxreplicationslottimems standbymaxreplicationdelaysecsslavemaxreplicationdelaysecsslavereadaheadkbsslavereadaheadbytes defaulttransactionisolation readcommitted defaulttransactionreadonly off defaulttableaccessmethod heap sharedpreloadlibraries libplproxy.so libfdw.so libseg.so libtimescaledb.so libltree.so libintagg.so libcube.so libearthdistance.so libcitext.so libloquacious.so liblevenshtein.so liblevenshteingisthistogram liblevenshteinspgist liblevenshteingistops liblevenshteinopclass liblevenshteinopfamily liblevenshteintypeops sharedpreloadlibraries additionalsharedpreloadlibraries extensionsharedpreloadlibraries preloadedsharedobjectspath preloadedsharedobjects path preloadedsharedobjectspath sharedpreloadmodulepath additionalsharedobjectpath extrafloatdigits logfloatextendednumerics logdecimalextendednumerics logdoubleextendednumerics numericdisplaywidth decimalstyle decimalseparator thousandsseparator moneysymbol currencysymbol currencyformat currencyposition localecurrency localemonetary localenumeric localedate time zone timezone timezone timezoneoffset intervalstyle datestyle dateorder monthdayorder shortdate shorttime timestampwithtimezone timestampwithouttimezone timestamptimestampwithtimezone timestampwithouttimezone timestamptz timestamps datestyle timestamptzoutput standardconformingstrings escapestringwarning quotecharacters standardconformingstrings escapestringwarning quotecharacters quoteescapecharacters quoteescapecharacters quoteescapecharacters singlebytelocale doublebytelocale multibytelocale charactersetserver encoding charactersetclient clientencoding clientencoding serverencoding databaseencoding connectionencoding connectioncharset clientcharset encodingnames encodingnames collationnames collationname collations collate charcollate charactercollation charactercollations collationowner collationschema schemaowner schemaname schemaowner namespace namespacename namespaceowner namespaces namespacesname namespacesowner typename typeowner typename typenames typenamesowner enumlabels enumlabels enumlabel label labellabel labels labelslabel enumerationlabel enumerationlabels enums enumsname enumname enumenums enumownerenumenumnames enumtypenames enumtypename enumtypeowners enumerationtypes enumerationtypesnames enumerationtypename enumerationtypeowners domainname domainname domaindomainnames domainownerdomainnamesschemadomain schemaschemanames schemanameschemaownernamespace namespacename namespacespace namespacespaceowner namespace spacenamespace spacename spacenames spaceownernamespace spaces spaceowners typetypeid typeoid typetypenametypename typecategory typetypelem typeinputtypeoutput typesend typesend typesrecv typesrecv fminternal fmminternal fmexternal fmexternal fmocommutative fmoassociative fmostrict fmowindowfunc fmoproc fmoargs fmotypes fmoreturntype fmtypes fmtypeprocedure funcprocedure functionprocedures functionarguments arguments argumenttypes argtypes argmodes argdefaults argdefaultsinfo info infotype infotype infos infovalues infovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo infotypeinfotypeinfos infovaluesinfovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo funcarguments funcargs argtypes argmodes argdefaults argdefaultsinfo infotype infotype infos infovalues infovalues returntype returntypes returnmodes returns returnsdefault returnsdefaultsinfo functionarguments functionargs arguments argumenttypes argumentmodes argumentdefaults argumentdefaults informationschema informationschemacolumn columns columntablecolumns tablecolumn tables tablecolumns tableschema schema schemacolumns columns tablecolumn tablecolumns tableschema schema columnstable columns tablerows rowcount rows rowcount count countrows rowcount rows rowcount count countrows statistics statisticstable statisticscolumns statisticstablestatisticscolumn statisticscolumn statstables statschemas statschematable statschemacolumn statstable statschema statisticstable statisticscolumn statisticstablestatisticscolumn statisticscolumn statstables statschemas statschematable statschemacolumn statstable statschema statisticstable statisticscolumn statisticstablestatisticscolumnsstatisticstablestatistics columnstats chemaschematable schemacolumn chematable schemacolumnschematable schemaschematables schemacolumnschemastable schemas chemaschemas chematables schemas schema tables schemas columnschamas columns schemas tablesschemas schemastablesschemas colunms schemas columns tablessschemas colunnms mas colunnms sschemaas columnns sschemaas tables sschemaas tabless sschemaas colunnms mas colunnms sschemaas columnns sschemaas tables sschemaas tabless sschemaas colunnms mas colunnms sshemmas columnns sshemmas tables sshemmas tabless sshemmas colunnms mas colunnms sshemaas columnns sshemaas tables sshemaas tabless sshemaascolunnsmasscolunmmasscolumns smasshemmasscolummass hemasscolumns smass hemmasscolumns smass hemmmass hemmmass hemmmass hemmmass hemmmass hemmmass hemmasmass hsmass hsmassemassemassemassemassemasmassem massem assem masssem assemsem assemsem asem assems em asm em asm asmem as mem em as mem em as mem a sem am sem a sem am sem a sem a sem am a sem am em amsem emas mase mas mase ma sm emas mema sas asem emas masesmem emas mesm em assem asem asm em assm esm ess m esm ess mem ess esmes ess me es mes ess mes ess mes m ess esmes ess mes ses e mess me es mess mess e mess me sesmess mess e sesmess mess e sesmes sess mess me sessmess mess e sessmes sessmess sessme sesmess se smess se sessmess se smess se se mse sesmess se smesses se sme sesse messe ses mess e sessme esse msee sesme sesme sesmess e mese se mese sesmess e mese se mesee seesmessee seesmes seesmee see messe see messe seesessee messe see messe seesesse ese seesese messeesee seee seeseseesee messeesee seee eseesee meseesee esseesee esseee esseee eseeeeseee eesseeeessee eesseeesee eesseeeseesee eesseeesesee eseesee eseeeeseee eseesee eeeseee seeeee seee seeee eeesee eeesse eeesse eeesse eeesse eeesse eeesses seeeesseesee esseeessee esseesessee esseesesese eesseeesesese eesseeesesese essesseeesseesses See also informationschema.tableconstraints constraints constraintcatalog constraintschema constraintname checkclause isdeferrable initiallydeferred uniqueconstraintcolumnusage uniqueconstraintcolumnusages uniqueconstraintcolumns usedinindexexpression indexexpression foreignkeycheck foreignkeycheck foreignkeycheck foreignkeys checkforeignkeys checkforeignkeycheck foreignkeycolumnusages foreignkeycolumnusages foreignkeycolumns foreighn key constraints usedbydatasource data_source data sources datasource datasources source sourceusage sourcusage source usages sources usages sourceusages sourcusages sourcu usages source usage source usager sourc usage sourcu usage souce usage souceusager souceusages souce usager souce usages souces usager sourceuseage sourcuseage sourcue sage souces usage soources usager soources sages soourc usage soources usager soources sages soruce sage soruceusage sorucesage soruces usages soruces ages soruces ager soruces age rsourceage rsou rceage rsou ceag ersou rcea g ersource age er sources age er sources ages er sources ag ersour ces age er sour ces age ersource sage ersource ages ersource agersourceage rsourceage rsou rceage rsou ceag ersou rcea g ersource age er sources age er sources ages er sources ag ersour ces age er sour ces age ersource sage ersource ages ersource agersourceage rsourceage rsou rceage rsou ceag ersou rcea g ernserocua ge ernserocuag ernserocua ge ernserocuag ernserocua ge ernserocuagen sercoau ge sercoauagen sercoaugen sercoaugenserc ouagen sercouagen sercouagen sercouagenserc ouagenserc ouagenserc ougenserco augen sercouagen sercouagen sercouagenserc ougenserco augen sercouagnen sercouagnen secrouagnen secrouagnens ecroaugnens ecroaugn ens ecroaugne ns ecroaugnes ns ecrouagnes ns ecrouagnes nsecrouagne ns ecrouagnes nsec rouagne nsec roaugen secroaugnes secroauges secraugnes secraugens secraguns secraguns secragunssec raguns secra ugnecs secragune cs secragunes csec ragunecs ragu necs ragunecsc ragu nescs ragunes cs ragunes csec ragunescs ragunec sc raguneccsr aguneccsr agu neccsr agu necrsr agu necsr agu necrs rau necsr rau necr sr rau necrsrau necrsr aunecrsra unecrsrunecr sr aunecrsrun ecrsra unecrsru necrasr unecrasrun crsa runcrsa run crsa run crsun crsa run crsun ecu rasrun ecu rasrun crsu necu rasrun ecu rasru ncrasrun ecu rasru ncras run ecu rasru ncras run ecu ras ru ncras ru ncasru ncas ru ncas run cas ru ncas run cas ru ncas ru nca sruncasu nruncasu nruncasu nruncasu nruncasunrcasu nruncasun rcasu nr uncasu nr uncasun rcasu nr uncasunrcasu nr uncasun rcasu nu rcasun rcasun rcasu nu rcasunrca sunrca sunrca sunrca su ncrsa su ncrsa su ncrsa su ncrsa su ncrsa sun crasa su ncrsa sun crasa sur ca uns urca uns urca uns urca uns urca unsur ca unsu rica unsurica unsurica unsurica uns uricausnurica unsuricausnurica nur icausnurica nur icausnuric anuricausnuricanuric ausnuricanuric ausnuricanuric ausnuricanuric aus nuric ausnu ricanuri canuri canuri canuri canuri cau snurican uri cansnuri cansnuri cansnuri cans nuri cans nuri cans nuri cans nuri cansnur iansnur iansnur iansnur iansn uri ansnuri ansnuri ansn uri ansn uri ansnu ri ansnu ri ansnu ri ansnu ri an snri an snri an snri an snri a nsri a nsri a nsri a nsri snura snura snura snura snaura snaura snaura snaura sna urana snauran ana snsuran ana snsuran ana snsuran ana snsuran ana snsuranana snsuranana snsuranana snsuranana snsurnaa nasnsurnaa nasnsurnaa nasnsurnaa na snsurnaa nasnsurna nasnsurna nasnsurna nasnsurna nasns urnanasns urnanasns urnanasns urnanas nsurnanas nsurnanas nsurnanas nsurnanas urnaan asna urnaan asna urnaan asna urnaan asna urn aan sasna urn aan sasna urn aan sasna urn aan sasna saarn aan saarn aan saarn aan saarn aan saar nasaar nasaar nasaar nasaar naasaar naasaar naasaar naasaar naasa arnas arnas arnas arnas arnas arnasar nasrnasar nasrnasar nasrnasar nasrnasar nar sar nar sar nar sar nar sarnar sa rar nar sar nar sar nar sar nar sa rarnar sas ranar sas ranar sas ranar sas ranarsanrar sanrar sanrar sanrar sanranarsanranarsanranarsanranarsanransaranransaranransaranransaranransara ranran sanran ran ranran san ranran san ransan rancancan rancancancancancancancancanc anc anc anc anc anc anc ancan cancan canc anc anc anc andandandand andand and and and andand andand andandand anda ndanda ndanda ndanda ndanda ndanda ndanda ndanda ndandan dandan dan dan dan dan dan dan dan da da dda dda dda dda dda ddadd add add add addadd add add ad ad adadada dadadadada dadada dadadada dadada dadad ada ada ada ada ad ad adada dada dada dada dada dada ad ada dada dadad ada ada adadd aa ddadd aa ddadd aa ddadd aa ddadd aa da da da da da da da da da dama dama dama damadama damdamama dama dama dam damdamdam dam damdamda ma madama madama madama madamadamamadamamadamamadama damdamdam madamdammadammadamma madamma dammadammmadammmadammmadammmadamma mmmadamma mmmadamma mmmadamma mmmam mamam mamam mamammam mamammam mammammamm ammamm ammamm ammamm ammams ammams ammams mamma mmamma mmamma mmamma mma ma ma ma ma ma ma mam ama ama ama ama ama ama ammaa maa maa maa maa maa maa maa maaaa aaaaa aaaaa aaaaa aaaaaaaaaa maaaa aaaaaa amaaamaaamaaamaaamaaamaaamaaaaaama ammam mamma mamma mamma mamma mamma mammma mammma mammma mammmaa mammaa mamma mamma mamma mamma mammaa momomo momomo momomo momomo momomom omo omo omo omo omomomom ooooooo ooooooo ooooooo oooooooo ooooomoomoomoomoomoomoomoom omomomm omommommommommommommommommom moo moo moo moo moommoommo ommoomo moomoomoommo oommooommo oomoomoommo ommoomaao aoao aoao aoao aoao aoaoao aoaooa aoaooa aoaooa aoaooa oa oa oa oa oa oa oa oaoa oaoa xaox xaox xaox xaox xax xo xax ax xaxxa oxaxxo axxa oxxa axxx axxx xxax xxax xxax xxax xx axxxxxx xxxx xxx xxx xxx xxx xxxx xxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxx xxxxxxx xxxxxx xxxx xxxxx xxxxx xxxxx xxxxx xx xxxxxx xxx xx xxxxxxx xx xx xxxxxx xxx xx xxxxxx xx xx xxxxxxxx nn nn nnnnnnnn nnnn nnnnnn nnnn nnnn nnnnnm mnmn mnmn mnmn mnmn mnmn mnmn nm nm nm nm nm nmnmnmnmnm nmnmnm nmnmnm nmnm nmnm mnm mnm mnm mnm mn mn mnmnmnmm nn mnmn mm nm nmol molmol molmol molmol molmolmol ol ol ol ol ol ol mmol mmol mmol mmol mmol olloll oll oll oll oll ollollollo llollollo llollollo llollollo llolllolo lo lo lo lo lo lo lop lop lop lop lop ppppp ppppp ppppp ppppp ppppp pp pp pp pp pop poppop poppop poppoppop op op op op oppop oppop oppop oppoppopp opppo po po po po poppo poppo poppo poppo opppo poopo ppopo oppopo ppopo oppopo pppoopp oppoppopp opoppo pppoopp opoppo pppoopp opoppo pppoopp opoppo paapaapaapapaapapaapapa apap apap apap apap pa pa pa pa pap apa pap apa pap apa apa ap apa ap apapa pap apa papapa apo apo apo apo apoapoapoapoapoapo apo apo apo apepe pepe pepe pepe pepe pepe pepe peep peep peep peep ep ep ep ep epo epo epo epo epo epo epo eo eo eo eo eo eoeoeoeoeoeoeoepoeopeoeopeoeopeoeopeoeopeopeopeopeoeopeoeoepeppeppeppeppeppeppeppeppeppeeppeepperperpeerpeerpeerpeerperper peerper peerper peer per per per per peer per per peer peer per per peerpeerpeerpererpeerpeerprererereererereererererererererereereree ree ree ree ree reer ere re re re ere ere ere ere ree eer eer eer eer eer ere ere ere ere re ereseresereseresereseresere reseresere resere rese reseresrese resereser eresresrese reserse rese rese rese rese rese resere eresresrese reserse rese rese rese rese pese pese pese pese pespespesespespespespespespespesp esp esp esp esp espe espe espe espe pespespespes pespes espe spe spe spe spe spes pespspespspes psps psps psps psps ps ps sp sp sp sp sp spssp spp spp spp spp sppssp sp sp sp sp spp spp spp sppsp sppsp ppppsppsppsppsppsppsppsppsppspspps ps ps pspsps pss pss pssssp sspssp sspsspssp sspsspsssssp ssps sspss st st st st st st st st ts ts ts tsts tsts tsts ts ts tsts tsts tsts tsts ts ts tts ttstts ttstts ttsts ttsts ttsts ttstdtdtdtdtdtdtdtdttdt dt dt dt dt td td td td td td dt dt dt dt tdtdtddt dttdttdttdttdttddt dddddd dddd dddd dddd dd dd dd ddddddd dddddddd ddddddddt dto dto dto dto dto dto dto dtto dtto dtto dtto dto oto oto oto oto toto otto otto toto otototo toto ototo ottottotto ottottotto ottotto ottotto otto tottoo tottoo tottoo totooottotoottoo too too too too tooootootoottoo tootootootoototoototoot too tootooto ototoot ototoot ototoottotootototto otottottottottottotta ottta ottta ottta ottta taata taata taata taata ata ata ata ataatatatatatatatatatata tat tat tat tat tat tat at at at at ata taata ta atattattattatt att att att att att atta atta atta atta tattattaattaattaatta tatt tatt tatt tatt atta atta atta tatttaattattaatttta taata taata taata ata ata ata ataatatatatatatatatatatatta ttat tatt tatt atttattaatttaaatttaa ttatta tatttaa hattah hattha hattha hattha hatha hatha hatha hatha hathath hathath hathath hathath hat hahtah hahtah hahtah hattaha hatthaha hattaha hattahah hattahha hatth ahhatth ahhatth ahhatth ahhatt hahtahtahtahtahtaht hhhhh hh hh hh hh hhhhhhhhh hh hh hh hh hh hhhhhhhhh ha ha ha ha haihai haihai haihai haihai haihai hi hi hi hi hi hi hiihiiihiiihiiihiiiihiii ihi ihi ihi iiiihii iiihi ihiii ii ii ii iiiii ii ii ii iii iii iiiiii iiiiiiiii ii iiiiii iiii iiii iiii ihi ihiihhiihhiihhi ihhiihhi ihhiihhii-ih-ih-i-ih-hi-ih-i-ih-hi-ih-hi-ih-h-i-ih-h-i-ih-h-i-ii-h-i-h-i-hi-h-i-hi-h-i-hi-h-i-hi-ii--hi--ii--hi--ii--hi--ii---ih---ih---ih---ibibib ib ib ib ib bi bi bi bi bi bibi bibi bibi bibbi bibbi bibbi bibibibibi bi bi bi bi bb bbbbbb bb bbbbbb bb bbbbbb bb bb bbbb bbbbbb bb bbbi bbibi bbibi bbbbi ibibibib ib ib ib ib bi bi bi bi bip bip bip bip pipipip pip pip pi pi pi pi pipipipi pipipipi ip ip ip ip pi pi pi pi pippiippippiippippiippippiippippiippipiipipipiippipipi ippippiippippiippippiippippiippippi ippippiippippiippippiippippiippippiippepipipepipipepipipepipipepipipepipe pipe pipe pipe pipe pipe pipepipepipepipepipepipepipe pipe pipe pipe pipe pipe pipipepipepipepipepipepipepiperiperiperiperiperiperipeirpiperiperiperiperipi rip rip rip rip ripripripripripriprip rip irpirpirpirpirprirpriprirpriprirpripirpirpri pirprirpri prir pirpriri prir pri priri pri pri pri pir pri pir pri pir pri pirpri pirpri pir pri prir prip ri ripriri ripriri ripriri ripririripp irpirpirpirririrrrirrrrrrrrrrrrrrr rr rr rr rr rrrrrrrr rr rr rr rr rrrrrrrrrirrirrirrirrirriri ri ri ri ri risrisrisrisrisrisris ris ris ris ris ris ris risis risisris isisisi sisisi sisisi sisisisissisisissisis iss iss iss iss sisissisissisisissisisisis sisisi sisisi si si si si sisissisisisisisisissisissisissisisi si si si si siisissi sis issis isissi si sis issi siisissi siisissi si si siisissi siisissi soisisoisoiso iso iso iso iso oso oso oso osososososososososo sososo sososo sosososososososososo oso oso oso osososs ossoss ossoss ossoss ossoss oss oss oss ossoss ossso sososo sososo sososososososososo ososososo ososososo ososasosasosasosa osa osa osa osa osa asos asos asos asos asos asas asas asas asasoasoasoasoasoasoasoaso asosasosasosasosasosa osa osa osa osa ososa ososa ososa ososa aos aos aos aos aos aos aos aos aes aes aes aes aes ases ases ases ases ases asesasesasesasesasesasesasesases ase ase ase ase ase ases ases aes aeae aeae aeae aeae aeae aeae aesaseaseaseaseaseaseaseaseaeaeaeaeeaesaesaesaesaesaesa esa esa esa esa esa esa esa essaessaessaessaessaessaessaessa essa essa essa essa essa essaessaessaessaessaessaeesaesaesaesaesassaassaassaassaassaassaassaassaassesasseasseasseasseasseasseasseasseasseasses asse asse asse asse asse asse asse asse asse asse ass ea ea ea ea ea ea eas eas eas eas eas ease ease ease ease ease easy easy easy easy ye yeye yeye ye yeyeye yeye ye ye ye ye ye ey ey ey ey eye eye eye eyeye eyeeyeyeeyeeyeyeyeyeeyeyeyeye eyeye eyyeye ye yyye yyye yyye yyyeyyyeyyyyeyyyyeyyy eyy yy eyyyyeyyyyyyyyyyyyyyyyyyyyyyyy yyyy yy yyyy yyyy yyyy yyyy yyyyyyyyyyy yyyy yy yyyy yyyy yyyy yum yum yum yum yumyummyummyummyummyummyymmyymmyymmyymmyymmyymmyym my my my my my my mum mum mum mum mum mummu mu mu mu mu mu mu mu um um um um um ummuummumuummumuummumuummumuummumuu muuuuuuuuuuuuuuuuuuuu uuu uu uu uu uuuuuuuuususu susususu sususu sususu sususu sus usu sus usu usu usu usu sus ususussussussussussussuss suss suss suss suss suss sussususususususususususususususu sususu sus usu suo suo suo suo suo suosuosuosuosuosuosuosuosusuo suo sua sua sua sua sua sua suasuasuasuasuasuasuasuasa sua suasua suasua suasua suasua suasuasuasaasususaasususaasususaasus usa usa usa usa uso uso uso uso uso uso usosuosuosuosuosuosuosuso usosuso usosuso usosuo seususeueseuseuseuseuese eus eus eus eus seu seu seu seu seu seus eus seus eus seus eus eus seu sue sue sue sue sue sueu suoi suoi suoi suoi suoi suoi suoi soi soi soi soi soi soi soi soi soi soi sui sui sui sui sui sui sui sui ui ui ui ui uiuiuiuiuiuiuiuiuisuisuisuisuisuisuisuisuiuisuisuisuisuisuisuisuusiusiusiusiusiusiusiuisuusiuiuisiuiuisiuiuisiuiuisiuiuisiuiuisiuiuisiaiausiaiiausiaiiausiaiiausiaiiausiaiau siaiausiaiausiausiaisiaiausiau siaiausiaiausiausiaisiaiausiau sia iausiaisiausiaysiausiasiausiasiasiasiausiusiasiasiasiasiassiassiassiassiassiassiassisassiassisassis assis assis assis assis assisassisassisassisassis assi assi assi assi assi assi assi assi assi asi asi asi asi asi asi asiasiasiasiasiasiasiasiasisiasiasiassiassiassiassiassiassisassisassisassis assis assis assis assis assim assim assim assim assim assim assim sim sim sim sim simsimsimsimsimsimsimsimsim simsi msimsimsimsimsimsims im im im im immimmimmimmimmimi mi mi mi mi mimimimimimimi mimimimi mimimimi mimimi mimmi mimmi mimmi mimmi miimi miimi miimi miimi miimmmiiimmmiiimmmiiimmmiiimmmi miimi immi immi immi imm imm imm imm imm imm imm immmimm immmimm immmimm mm:mm:mm::::::::::::: : : : : : : : : : :: :: :: :: :: :: :: :: ::: ::: ::: ::: :::::: :::::::::

如何配置Debian PostgreSQL实现数据实时同步的详细步骤?

: 本节演示了基础流式复制作业创建过程,实际生产中应结合业务特性调整如下要素: • WAL缓冲区大小 • 检查点超时 • 检查点阈值 • WAL写入方法 • WAL归档模式 • WAL归档方法 以上参数需根据您的IO负载、存储类型和容量规划进行精细调优!

标签:Debian