SLONIK_REPAIR_CONFIG(7)

💖 SLONIK REPAIR CONFIG 💖

okay bestie, welcome to the SLONIK_REPAIR_CONFIG(7) page from the Slony-I 2.2.11 docs — this one's a lil niche but honestly kinda iconic once you get it. sit down, grab a strawberry 🍓, let's go.

---

✨ NAME ✨

REPAIR CONFIG — resets the name-to-oid mapping of tables in a replication set. it's giving rescue mission, because it's useful for restoring a node after a pg_dump. 🫶

---

🌸 SYNOPSIS 🌸

REPAIR CONFIG (options);

that's it. that's the whole vibe. one command, some options, slay. 💅

---

🦋 DESCRIPTION 🦋

okay so what this actually does: it resets name-to-oid mapping. that's the whole thing. the name→oid mapping gets reset. periodt. 💜

and then it takes these options:

• SET ID = ival — which set you're cleaning up after. like, which one are we doing the lil reset for? that one. 🎀
• EVENT NODE = ival — the node ID where this should be submitted. that's where the event gets handed off.
• EXECUTE ONLY ON = ival — the ID of the only node where the mappings are to be updated. and here's the important bit, no cap: if you don't specify it, the default is to execute this on all nodes subscribed to the set. so if you're like "hmm I only want one node to do this", you gotta say so. otherwise everybody's doing it. 🌈

---

🔥 EXAMPLE 🔥

here's the whole thing in action, look at her go:

REPAIR CONFIG (
  SET ID = 1,
  EVENT NODE = 2
);

clean. simple. ate. ✨

---

🔒 LOCKING BEHAVIOUR 🔒

no application-visible locking should take place. that's it, that's the whole section. she does NOT lock, she does NOT block your apps, she's a polite queen. 👑

---

📬 SLONIK EVENT CONFIRMATION BEHAVIOUR 📬

Slonik does not wait for event confirmations before performing this command. so she's not sitting there like "did u get my text 👀" — she just goes. 💀

---

⭐ VERSION INFORMATION ⭐

this command was introduced in Slony-I 1.1. so she's been around, she's a legacy icon, lowkey a veteran of the replication game. 🧚

---

ngl bestie, if you're here it's probably because a pg_dump situation happened and something's mapping got confused. REPAIR CONFIG is your girl. fix the names, fix the oids, move on with your life. 💅

---

okay that's the page!! this was SLONIK REPAIR CONFIG(7) from the Slony-I 2.2.11 Documentation, dated 19 September 2024. go forth and repair that config, bestie — you got this 💖✨🦋🎀