Show HN: Pigsty – Free RDS Alternative
github.com
Show HN: Pigsty – Free RDS Alternative
1–10 of 53 posts
Re: Show HN: Pigsty – Free RDS Alternative
#2AGPL3, no thanks.
Curious if there are runtime downsides to having so many extensions installed
Re: Show HN: Pigsty – Free RDS Alternative
#3Sounds like a security nightmare.
Re: Show HN: Pigsty – Free RDS Alternative
#4This looks very very fragile. If all of this works, great job though.
Re: Show HN: Pigsty – Free RDS Alternative
#5AGPL3, no thanks. Curious if there are runtime downsides to having so many extensions installed
These extensions are pre-packed and included in the local yum repo, which can be enabled by configuration.
Only core extentensions are installed by default, which are: pg_repack, wal2json, postgis33, timescaledb, citus, pgvector.
And the only extension activated (`CREATE EXTENSION`) by default is pg_repack.
The AGPLv3 is infected by the Grafana, MinIO and citus.
https://github.com/Vonng/pigsty/blob/master/docs/PGSQL-EXTEN...
Re: Show HN: Pigsty – Free RDS Alternative
#6Why would you ever want that many extensions?
Re: Show HN: Pigsty – Free RDS Alternative
#7Why would you ever want that many extensions?
to increase attack surface
Re: Show HN: Pigsty – Free RDS Alternative
#8Sounds like a security nightmare.
If all 150 extensions are installed simultaneously, It's definitely a nightmare. Luckily they are all optional components.
Re: Show HN: Pigsty – Free RDS Alternative
#9[deleted]
Re: Show HN: Pigsty – Free RDS Alternative
#10This looks very very fragile. If all of this works, great job though.
For the extension part, maybe. we only use very limited extensions in production: PostGIS, TimescaleDB, and PGVector will suffice for most cases, plus pg_repack, pg_cron, and wal2json for maintenance.
The core/RDS part (HA/PTIR/IaC/Monitor) is quite robust, which has served our 25000 core deployment for 3 years+ and survived dozens of hardware failures.