digoal / blog

Opensource,Database,AI,Business,Minds. git clone --depth 1 https://github.com/digoal/blog

https://github.com/digoal/blog/blob/master/README.md

GNU General Public License v2.0

8.01k stars 1.89k forks source link

postgresql-12.3 slot控制wal爆仓的参数 #75

Closed mawenbin666 closed 4 years ago

mawenbin666 commented 4 years ago

1、PG-12.3的版本slot 有没有控制 wal爆仓的参数呢

看了下德哥的blog，https://github.com/digoal/blog/blob/master/202007/20200720_03.md
PG-13的版本是有介绍 增加流复制slot保留wal上限参数 - max_slot_wal_keep_size，
那PG-12.3的版本怎么去控制wal日志爆仓呢？

digoal commented 4 years ago

PG 12没有这个参数, 只能人为控制, 例可以配置在archive_command归档命令中自动清理. 逻辑自己在command中定义