use replication slot or Adjust wal_keep_segments

[k-ta-yamada]

PostgreSQL本体のレプリケーション機能強化 (3/4)

• postgresql.conf
  • standby node
    • hot_standby = on
    • hot_standby_feedback = on
  • master node
    • wal_level = hot_standbyreplica
    • max_wal_senders = 2
    • max_replication_slots = 2
• create(on master node)
  • SELECT * FROM pg_create_physical_replication_slot('a_slot');
• recovery.conf(on standby node)
  • primary_slot_name = 'a_slot'
• check
  • SELECT slot_name, active FROM pg_replication_slots;
• delete
  • SELECT pg_drop_replication_slot('a_slot');

---

19.6.1. 送出サーバ群

• max_replication_slots (integer)
• wal_keep_segments (integer)

26.2.6. レプリケーションスロット