A repository containing any PostgreSQL extension you can imagine for Linux distributions is something that might be valuable if you are trying to save some time.

Extensions, extensions, extensions... They're one of the features that make PostgreSQL great, therefore the existence of an evolving ecosystem encompassing them to make it easy to consume by applications.

For instance we've recently looked at pgextensions.org by DataCloudGaze, an online index of all PostgreSQL extensions available on all Cloud providers' managed instances.
Its primary purpose was to provide comprehensive and comparative information across major cloud providers.
In other words it shows who supports what extension out of the box.

However in the other case you want to install an extension locally, there's yet another option, that of pxman. We've looked at in "pgxman-the PostgreSQL Extension Manager", a manager that acts as npm but instead of Javascript packages it installs PostgreSQL extensions.

The new proposition of Pigsty acts as supplementary APT and YUM repository for PostgreSQL extensions, offering
them in RPM and DEB formats. The key functionality is to provide 334 RPM extensions available for EL,
and 326 DEB available for Debian/Ubuntu. The list of availability contains all the popular extensions as well as many niche ones,
split into categories. For instance under the Time category you'll find :

• timescaledb
• timeseries
• temporal_tables
• pg_cron

Under GIS :

• postgis
• h3
• q3c
• geoip

while under RAG :

• vector
• vectorscale
• vectorize
• pg_similarity
• pg_summarize

and so on. Check the full list on the Github repo.

It's installation time. To add the repo to Ubuntu 22 & Debian 12 or any compatible platforms, do :

curl -fsSL https://repo.pigsty.io/key | sudo gpg --dearmor -o /etc/apt/keyrings/pigsty.gpg

sudo tee /etc/apt/sources.list.d/pigsty-io.list > /dev/null <<EOF
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/infra generic main
deb [signed-by=/etc/apt/keyrings/pigsty.gpg] https://repo.pigsty.io/apt/pgsql/$(lsb_release -cs) $(lsb_release -cs) main
EOF

sudo apt update

while for EL 8/9 YUM systems do :

curl -fsSL https://repo.pigsty.io/key | sudo tee /etc/pki/rpm-gpg/RPM-GPG-KEY-pigsty >/dev/null # add gpg key

curl -fsSL https://repo.pigsty.io/yum/repo | sudo tee /etc/yum.repos.d/pigsty.repo >/dev/null # add repo file

sudo yum makecache

In case you want ALL the extensions pre-installed then get Pigsty itself which is a "Battery-Included, Local-First PostgreSQL Distribution as a Free & Better RDS Alternative".Together with the extensions you'll also get :

• Self-healing HA from hardware failures and Point-In-Time-Recovery from human error & bugs!
• Penetrating insight through all-seeing panels
• Self-serving enterprise RDS service with all its dependencies in the absence of a dedicated DBA
• Anti-Entropy: Describe everything in code, minimize complexity with IaC & SOP, Administration with GitOps
• No vendor lock-in, Run your own RDS to reclaim 90%+ hardware bonus from the Cloud

There's also a Playground of the available dashboards to check them out quickly.

Ultimately, the deal isn't just to foster extensions but also make them easy to discover and install. And Pigsty fulfills that promise.

 More Information

Pigsty

Related Articles

Pgextensions Index For PostgreSQL

pgxman - PostgreSQL Extension Manager

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Comments

Make a Comment or View Existing Comments Using Disqus

or email your comment to: comments@i-programmer.info