The PostgreSQL Extension Repo By Pigsty |
Written by Nikos Vaggalis | |||
Monday, 09 December 2024 | |||
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. 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
Under GIS :
while under RAG :
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 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 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 :
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.
|
Rust Celebrates 10 Years Since Version 1.0 17/05/2025 Rust reached the milestone of Version 1.0 becoming generally available on May 15, 2015. Version 1.87 has just been released on the 10th anniversary with a celebratory event in Utrecht during Rust week [ ... ] |
Apache Syncope 4 Adds Live Sync 12/06/2025 Apache Syncope 4.0 Notturno has been released, with improvements including live sync, OpenFGA integration, and a reworked persistence layer. Apache Syncope is an Open Source IAM (Identity A [ ... ] |
More News
|
Comments
or email your comment to: comments@i-programmer.info