PG_AUTOCTL_ENABLE_SECONDARY(1)

💖 PG_AUTOCTL ENABLE SECONDARY(1) 💖

okay bestie, this one lives in the pg_auto_failover manual, and it's literally the page for pg_autoctl enable secondary. yes it says the same thing twice up top, that's just how these pages do. periodt.

---

✨ NAME ✨

pg_autoctl enable secondary — pg_autoctl enable secondary

pg_autoctl enable secondary — Enable secondary nodes on a formation

---

🌸 SYNOPSIS 🌸

so the vibe here is: this feature makes the most sense when you're using the Enterprise Edition of pg_auto_failover, which is fully compatible with Citus formations. no cap.

When secondary are enabled, then Citus workers creation policy is to assign a primary node then a standby node for each group. 🫶

When secondary is disabled the Citus workers creation policy is to assign only the primary nodes.

and here's the literal usage line, verbatim, don't @ me:

usage: pg_autoctl enable secondary  [ --pgdata --formation ]

--pgdata      path to data directory
--formation   Formation to enable secondary on

---

🎀 OPTIONS 🎀

• --pgdata — Location of the Postgres node being managed locally. Defaults to the environment variable PGDATA. Use --monitor to connect to a monitor from anywhere, rather than the monitor URI used by a local Postgres node managed with pg_autoctl. ✨
• --formation — Target formation where to enable secondary feature. 💅

---

🦋 ENVIRONMENT 🦋

• PGDATA — Postgres directory location. Can be used instead of the --pgdata option. 🌸
• PG_AUTOCTL_MONITOR — Postgres URI to connect to the monitor node, can be used instead of the --monitor option. 🔥
• XDG_CONFIG_HOME — The pg_autoctl command stores its configuration files in the standard place XDG_CONFIG_HOME. See the XDG Base Directory Specification. 🧚
• XDG_DATA_HOME — The pg_autoctl command stores its internal states files in the standard place XDG_DATA_HOME, which defaults to ~/.local/share. See the XDG Base Directory Specification. 💜

---

👑 AUTHOR 👑

Microsoft

---

🌈 COPYRIGHT 🌈

Copyright (c) Microsoft Corporation. All rights reserved.

---

lowkey iconic of you to read all the way down here. slay. 💖

version 2.1 · dated Jan 18, 2025 · PG_AUTOCTL ENABLE SECONDARY(1) — mwah, bye bestie 🎀✨🦋