Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTNC9-0057Zw-V3 for pgsql-announce@arkaria.postgresql.org; Thu, 02 Jan 2025 15:33:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tTNC9-00GH8x-9j for pgsql-announce@arkaria.postgresql.org; Thu, 02 Jan 2025 15:33:09 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTNC8-00GH8f-6L for pgsql-announce@lists.postgresql.org; Thu, 02 Jan 2025 15:33:08 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1tTNC5-001jrQ-2S for pgsql-announce@lists.postgresql.org; Thu, 02 Jan 2025 15:33:07 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Message-ID:Date:Reply-To:From:To:Subject: MIME-Version:Content-Type:Sender:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=1/oBFx0oW5TznJ7E/jguh/tllrwYN+iWpvrjDN9SaFs=; b=gyKMVhvZdrCg4NEhfeGoKu8fm3 UmuYjfCq772DLbnrI1zgfJUZ4Qu2BNU0NVxr7bysFwNZLWcA0Px88H1al4U/I0tSSx2DjjOidRXiW KGh8jZ/XBBfPHKLodnqATBmGqfNXneF0sQ/rWk/ZHjk0rDWpnGzWxrgaejr9KqBUoJ3NlIeTpD148 pbNMrs57M+4QV0aa+MgJKKVk6I1Zfavosp0WoEJN+x0Efwb+8dhJwMMcSujFHW9uwnySuiK1Vu1nf Hd2GWsyCjmPnWncnKLK8ZroUv79SwNZHQM4vnbzMV1ry4K2wYHcGm4SE5liwEgbgZrRvzbNGGMh0X M1BQjahA==; Received: from wrigleys.postgresql.org ([2a02:16a8:dc51::60]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tTNC4-008VDk-7p for pgsql-announce@lists.postgresql.org; Thu, 02 Jan 2025 15:33:05 +0000 Received: from localhost ([127.0.0.1] helo=wrigleys.postgresql.org) by wrigleys.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tTNC2-00BteL-5T for pgsql-announce@lists.postgresql.org; Thu, 02 Jan 2025 15:33:02 +0000 Content-Type: multipart/mixed; boundary="===============4302582062223323169==" MIME-Version: 1.0 Subject: ANNOUNCE pig: The Postgres Extension Wizard To: PostgreSQL Announce From: Pigsty via PostgreSQL Announce Reply-To: rh@vonng.com Date: Thu, 02 Jan 2025 15:32:59 +0000 Message-ID: <173583197994.681.15130666180188803601@wrigleys.postgresql.org> X-Auto-Response-Suppress: All Auto-Submitted: auto-generated X-pglister-tags: related X-pglister-tagsig: a6a1e476b71c33692be047277273ef403282a84a4a2b1c5b8e8c372ebc237413 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============4302582062223323169== Content-Type: multipart/alternative; boundary="===============7387272781212824216==" MIME-Version: 1.0 --===============7387272781212824216== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Ever wished installing or upgrading PostgreSQL extensions didn=E2=80=99t fe= el like digging through outdated readmes, cryptic configure scripts, or random GitHub forks & patches? The painful truth is t= hat Postgres=E2=80=99s richness of extension often comes at the cost of complicated setups=E2=80=94especially if you=E2=80=99r= e juggling multiple distros or CPU architectures. Enter **Pig**, a Go-based package manager built to tame Postgres and its ec= osystem of [340+](https://ext.pigsty.io/#/list) extensions in one fell swoop. Times= caleDB, Citus, PGVector, 20+ Rust extensions, plus every must-have piece to [self-host](https://pigsty.io/blog/db/supabas= e) Supabase =E2=80=94 Pig=E2=80=99s 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=E2=80=99s nativ= e package manager (APT, YUM, DNF) and follow official PGDG packaging conventions to ensure a glitch-free fit. That means you don= =E2=80=99t have to choose between =E2=80=9Cthe right way=E2=80=9D and =E2=80=9Cthe quick way=E2=80=9D; Pig respects your existing repos, aligns w= ith 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 specializ= ed modules=E2=80=94no 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/@fengruo= hang/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 pa= ckages ``` 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. --===============7387272781212824216== Content-Type: text/html; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable ANNOUNCE pig: The Postgres Extension Wizard
 

ANNOUNCE pig: The Postgres Extension Wizard

Ever wished installing or upgrading Postgre= SQL extensions didn=E2=80=99t feel like digging through outdated readmes, c= ryptic configure scripts, or random GitHub forks & patches? The painful truth = is that Postgres=E2=80=99s richness of extension often comes at the cost of complicated setups=E2=80=94especially if you=E2=80=99r= e juggling multiple distros or CPU architectures.

Enter Pig, a Go-based pack= age manager built to tame Postgres and its ecosystem of 340+ extensions in one fell swoop. TimescaleDB, C= itus, PGVector, 20+ Rust extensions, plus every must-have piece to self-host Supaba= se =E2=80=94 Pig=E2=80=99s 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 piggy= back your system=E2=80=99s native package manager (APT, YUM, DNF) and follo= w official PGDG packaging conventions to ensure a glitch-free fit. That means you don= =E2=80=99t have to choose between =E2=80=9Cthe right way=E2=80=9D and =E2=80=9Cthe quick way=E2=80=9D; Pig respects your existing repos, aligns w= ith standard OS best practices, and fits neatly alongside other packages you already use.

Ready to give your Postgres superpowers wit= hout the usual hassle? Check out GitHub for documentation, installation steps, and a peek at its massive extension list. Then, watch your local Postgres instance transform into a powerhouse of specializ= ed modules=E2=80=94no black magic is required. If the future of Postgres is unstoppable extensibility, Pig is the genie that helps you unlock it. Honestly, nobody ever complained= that they had too many extensions.

Resource

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 l= ike:

bash pig ext install pg17 # install native PGDG PostgreSQL 17 kernels pa= ckages

And any extension in the catalo= g with:

bash pig ext install pg_duckdb # install the pg_duckdb extension (for current= pg17)

That's it! Check out the = full documentation for advanced usage.
This email was sent to you from Pigsty. It was delivered on their behalf by the PostgreSQL project. Any questions about the content of the message shou= ld be sent to Pigsty.

You were sent this email as a subscriber of the pgsql-announce mai= linglist, for the content tag Related Open Source. To unsubscribe from further emails, or change which emails you want to receive, please click th= e personal unsubscribe link that you can find in the headers of this email, or visit https://lists.postgresql.org/unsubscribe/.
 
--===============7387272781212824216==-- --===============4302582062223323169==--