Ch-msm / doc-note

文档和笔记
0 stars 0 forks source link

解决一次pg_wal过大的问题 #33

Open Ch-msm opened 2 years ago

Ch-msm commented 2 years ago
  1. 查询物理复制槽
    select * from pg_replication_slots;
  2. 查看文件大小
    select pg_size_pretty(pg_wal_lsn_diff(pg_current_wal_lsn(),'71/8D1AB0F8'));
  3. 移除节点
    select pg_drop_replication_slot('slot2');
  4. 检查节点
    checkpoint