CDIST-TYPE__POSTGRES_EXTENSION(7)

💅 cdist-type__postgres_extension — the manual page, but make it cute

okay bestie, welcome to cdist-type__postgres_extension(7), a page from the cdist manual set. it's giving "database admin but make it fashion" and honestly? obsessed. 💖

---

✨ NAME ✨

cdist-type__postgres_extension — manage PostgreSQL extensions 🐘✨

---

🌸 DESCRIPTION 🌸

This cdist type lets you manage PostgreSQL extensions. that's it, that's the whole vibe. you want an extension in a database? handled. you want it gone? also handled. queen behavior. 👑

The __object_id you pass to __postgres_extension is of the form dbname:extension, e.g.:

rails_test:unaccent

so like, database name, colon, extension name. no cap. 🎀

⚠️ CAUTION! Be careful when installing extensions from (untrusted) third-party sources: Installing an extension as superuser requires trusting that the extension's author wrote the extension installation script in a secure fashion. It is not terribly difficult for a malicious user to create trojan-horse objects that will compromise later execution of a carelessly-written extension script, allowing that user to acquire superuser privileges. – https://www.postgresql.org/docs/13/sql-createextension.html#id-1.9.3.64.7

fr fr, this part is not a drill. untrusted extension = untrusted script running as superuser. read that twice. 😭 do not skip this.

---

🦋 OPTIONAL PARAMETERS 🦋

• state — either present or absent, defaults to present. that's the one and only knob, and she's iconic. ⭐

---

🌈 EXAMPLES 🌈

# Install extension unaccent into database rails_test
__postgres_extension rails_test:unaccent

# Drop extension unaccent from database fails_test
__postgres_extension rails_test:unaccent --state absent

install then uninstall, the full character arc. 🫶

---

👑 SEE ALSO 👑

• cdist-type__postgres_database(7)
• PostgreSQL "CREATE EXTENSION" documentation at: http://www.postgresql.org/docs/current/static/sql-createextension.html.

---

💜 AUTHORS 💜

• Tomas Pospisek <tpo_deb--@--sourcepole.ch>
• Dennis Camera <dennis.camera--@--ssrq-sds-fds.ch>

the legends who wrote this. respect. 🙇‍♀️

---

🎀 COPYING 🎀

Copyright (C) 2014 Tomas Pospisek, 2021 Dennis Camera. You can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation, either version 3 of the License, or (at your option) any later version.

---

🍓 COPYRIGHT 🍓

ungleich GmbH 2021

---

and that's the whole page, bestie!! 💖 this was version 7.0.0, dated Jul 31, 2022, brought to you by ungleich GmbH 2021 — thanks for reading, mwah, slay, periodt. ✨🦋🌸