AI Architecture Analysis
This repository is indexed by RepoMind. By analyzing pgsty/pig in our AI interface, you can instantly generate complete architecture diagrams, visualize control flows, and perform automated security audits across the entire codebase.
Our Agentic Context Augmented Generation (Agentic CAG) engine loads full source files into context on-demand, avoiding the fragmentation of traditional RAG systems. Ask questions about the architecture, dependencies, or specific features to see it in action.
Embed this Badge
Showcase RepoMind's analysis directly in your repository's README.
Repository Overview (README excerpt)
Crawler viewPIG - Postgres Install Genius **pig** is an open-source PostgreSQL (& Extension) Package Manager for mainstream (EL/Debian/Ubuntu) Linux. Install PostgreSQL 14 ~ 18 along with 461 extensions on ( / ) with native OS package manager All commands support structured output ( ) with self-describing schema, making it an **Agent-Friendly** PostgreSQL CLI tool. Also check the **Pigsty Extension Catalog** to get details about the available extensions. -------- Get Started **Install** the package first, (you can also use the / or just copy the binary) Then you're ready to go. For example, install the extension: That's it. All set! Check the advanced usage for details and the full list of 461 available extensions. -------- Installation The util is a standalone Go binary with no dependencies. You can install it with: Or just download and extract the binary, or use the package manager: For Ubuntu 22.04 / 24.04 & Debian 12 / 13 or any compatible platforms: For EL 8 / 9 / 10 and compatible platforms: > For mainland China users: consider replacing with . has self-update feature, you can update pig itself to the latest version with: -------- Advanced Usage > [!NOTE] > command outputs below are examples captured on a specific environment; exact package/version lists can vary by OS, arch, and repo snapshot. **Environment Status** **Extension Management** **Repo Management** **Build Management** **Radical Repo Admin** The default will add the repo and repo to your system. The following command backup and overwrites your existing repo configuration, then adds all required repos. is the stronger form of repo add: it overwrites your existing repos ( ) by default. You can recover your old repos from or . **Install PostgreSQL** You can also install PostgreSQL kernel packages with You can link the installed PostgreSQL to the system path with: **Using Alias** and support alias translation. Alias resolution has two parts: • Static aliases from ( , with OS/arch overrides). • Dynamic category aliases from . Common PostgreSQL kernel aliases: Dynamic category aliases ( , , , ...): Current static alias keys (shared by EL/Debian families): Check the actual installed package with : More Alias Take el for examples: **Install for another PG** will use the default postgres installation in your active , but you can install extensions for a specific installation with (when using the PGDG convention), or passing any path for custom installation. **Install a Specific Version** You can also install PostgreSQL kernel packages with: > Beware the **APT** repo may only have the latest minor version for its software (and require the full version string) **Search Extension** You can perform fuzzy search on extension name, description, and category. You can use the or to find extension availability for other PostgreSQL installation. **Extension Availability Matrix** You can check the availability matrix for extensions across different OS/Arch/PG combinations: **Print Extension Summary** You can get extension metadata with subcommand: `bash $ pig ext info pg_duckdb ╭──────────────────────────────────────────────────────────────────────────────────────────────╮ │ pg_duckdb │ ├──────────────────────────────────────────────────────────────────────────────────────────────┤ │ DuckDB Embedded in Postgres │ ├──────────────┬─────────────────────────────────────────────────────── _...truncated for preview_