from Hacker News

The 333 PostgreSQL Extensions available as out-of-box RPM/DEB packages

by Vonng on 8/14/24, 12:39 AM with 2 comments

  • by Vonng on 8/14/24, 12:39 AM

    I've set up a supplementary APT/YUM repository, which builds on the official PGDG offerings. This includes 326 extensions for EL distros and 312 for Deb distros, encompassing 121 RPM packages and 133 DEB packages.

    These packages support PG16 extensions across Ubuntu 22.04, Debian 12, EL8, and EL9. My efforts have been particularly focused on align OS-specific extensions across the major Linux distributions to ensure a consistent feature set.

    For those who are interested, you can browse the PostgreSQL extension catalog here: (https://pigsty.io/docs/pgext/list/). Additionally, I've maintained a public Yum/Apt repository hosted on Cloudflare: https://pigsty.io/docs/pgext/usage/repo/

    I'm keen to hear your thoughts and would greatly appreciate any feedback from those who have utilized these extensions.

  • by luelue_ly on 8/14/24, 4:01 AM

    I am using Pigsty to manage a database of over 5TB, which is very convenient in terms of performance and scalability. They have provided us with a lot of support beyond the official charges! In comparison, we are also using Alibaba Cloud's RDS, but the various unbearable bugs on Alibaba Cloud have led me to decide to move everything off the cloud and migrate everything to Pigsty.