public inbox for [email protected]
help / color / mirror / Atom feedFrom: Pigsty via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: ANNOUNCE pig: The Postgres Extension Wizard
Date: Thu, 02 Jan 2025 15:32:59 +0000
Message-ID: <[email protected]> (raw)
Ever wished installing or upgrading PostgreSQL extensions didn’t feel like digging through outdated readmes, cryptic
configure scripts, or random GitHub forks & patches? The painful truth is that Postgres’s richness of extension often
comes at the cost of complicated setups—especially if you’re juggling multiple distros or CPU architectures.
Enter **Pig**, a Go-based package manager built to tame Postgres and its ecosystem
of [340+](https://ext.pigsty.io/#/list) extensions in one fell swoop. TimescaleDB, Citus, PGVector, 20+ Rust extensions,
plus every must-have piece to [self-host](https://pigsty.io/blog/db/supabase) Supabase — Pig’s unified CLI makes them
all effortlessly accessible. It cuts out messy source builds and half-baked repos, offering version-aligned RPM/DEB
packages that work seamlessly across Debian, Ubuntu, and RedHat flavors, as well as x86 & ARM arch. No guesswork, no drama.
Instead of reinventing the wheel, Pig piggyback your system’s native package manager (APT, YUM, DNF) and follow official
PGDG packaging conventions to ensure a glitch-free fit. That means you don’t have to choose between “the right way” and
“the quick way”; Pig respects your existing repos, aligns with standard OS best practices, and fits neatly alongside
other packages you already use.
Ready to give your Postgres superpowers without the usual hassle? Check out [GitHub](https://github.com/pgsty/pig)
for documentation, installation steps, and a peek at its massive [extension list](https://ext.pigsty.io/#/list). Then,
watch your local Postgres instance transform into a powerhouse of specialized modules—no black magic is required.
If [the future of Postgres is unstoppable extensibility](https://medium.com/@fengruohang/postgres-is-eating-the-database-world-157c204dcfc4),
Pig is the genie that helps you unlock it. Honestly, nobody ever complained that they had *too many* extensions.
## Resource
- [GitHub Repo](https://github.com/pgsty/pig)
- [PIG v0.1 Release](https://github.com/pgsty/pig)
- [Extension Repo](https://ext.pigsty.io)
- [Blog: The Idea Way to deliver PG Extensions](https://medium.com/@fengruohang/the-idea-way-to-deliver-postgresql-extensions-35646464bb71)
## Get Started
Install the `pig` cli first:
```bash
curl -fsSL https://repo.pigsty.io/pig | bash
```
Add necessary repos to your OS:
```bash
pig repo add all -u # add all repos and update cache
```
You can install pgdg kernel packages just like:
```bash
pig ext install pg17 # install native PGDG PostgreSQL 17 kernels packages
```
And any extension in the [catalog](https://ext.pigsty.io) with:
```bash
pig ext install pg_duckdb # install the pg_duckdb extension (for current pg17)
```
That's it! Check out the [full documentation](https://ext.pigsty.io/#/pig) for advanced usage.
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: ANNOUNCE pig: The Postgres Extension Wizard
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox