postgresql-cli

PostgreSQL CLI

Overview

Deploys the PostgreSQL Command Line Client (libpq) via Homebrew. This provides the psql binary needed by developers and scripts to interface with PostgreSQL databases without running a local Postgres server.

What it does

• Detection: Checks if libpq is present in the local Homebrew cellar.
• Privilege Dropping: Bypasses the Intune root execution by switching to the local console user via sudo -u.
• Remediation: Silently installs the libpq formula and creates the required symlinks so psql is accessible in the user's $PATH.

Intune Deployment Configuration

• Upload script: install-postgresql-cli.sh
• Run script as signed-in user: No (Requires root execution initially)