Battery-Included PostgreSQL Distro as a Free RDS Alternative
Highlight
pg_analytics
, pg_bm25
, and pg_sparse
duckdb_fdw
Configuration
node_repo_modules
to add upstream repos (including local one) to nodenode_local_repo_urls
, replaced by node_repo_modules
& repo_upstream
.node_repo_method
, replaced by node_repo_modules
.local
repo into repo_upstream
instead of node_local_repo_urls
chrony
into node_default_packages
repo_upstream.baseurl
$releasever on el8/el9 with major.minor version if applicableSoftware Upgrade
PostgreSQL x Pigsty Extensions
Checksums
6629431c07fd5df993ed8c68d7086b05 pigsty-v2.6.0.tgz
81abcd0ced798e1198740ab13317c29a pigsty-pkg-v2.6.0.debian11.x86_64.tgz
7304f4458c9abd3a14245eaf72f4eeb4 pigsty-pkg-v2.6.0.debian12.x86_64.tgz
f914fbb12f90dffc4e29f183753736bb pigsty-pkg-v2.6.0.el7.x86_64.tgz
fc23d122d0743d1c1cb871ca686449c0 pigsty-pkg-v2.6.0.el8.x86_64.tgz
9d258dbcecefd232f3a18bcce512b75e pigsty-pkg-v2.6.0.el9.x86_64.tgz
901ee668621682f99799de8932fb716c pigsty-pkg-v2.6.0.ubuntu20.x86_64.tgz
39872cf774c1fe22697c428be2fc2c22 pigsty-pkg-v2.6.0.ubuntu22.x86_64.tgz
Full Changelog: https://github.com/Vonng/pigsty/compare/v2.5.1...v2.6.0
Routine update with v16.1, v15.5, 14.10, 13.13, 12.17, 11.22
Now PostgreSQL 16 has all the core extensions available (pg_repack
& timescaledb
added)
monitor
schema prefix from PGCAT dashboard querieswool.yml
for Aliyun free ECS singletonpython3-jmespath
in addition to python3.11-jmespath
for el974688c0b0515172ba23d897e17fc8e91 pigsty-v2.5.1.tgz
31ee48df1007151009c060e0edbd74de pigsty-pkg-v2.5.1.el7.x86_64.tgz
a40f1b864ae8a19d9431bcd8e74fa116 pigsty-pkg-v2.5.1.el8.x86_64.tgz
c976cd4431fc70367124fda4e2eac0a7 pigsty-pkg-v2.5.1.el9.x86_64.tgz
7fc1b5bdd3afa267a5fc1d7cb1f3c9a7 pigsty-pkg-v2.5.1.debian11.x86_64.tgz
add0731dc7ed37f134d3cb5b6646624e pigsty-pkg-v2.5.1.debian12.x86_64.tgz
99048d09fa75ccb8db8e22e2a3b41f28 pigsty-pkg-v2.5.1.ubuntu20.x86_64.tgz
431668425f8ce19388d38e5bfa3a948c pigsty-pkg-v2.5.1.ubuntu22.x86_64.tgz
Get Started with the latest Pigsty v2.5.0:
curl https://get.pigsty.cc/latest | bash
Ubuntu / Debian Support: bullseye
, bookworm
, jammy
, focal
, in addition to existing EL 7
/8
/9
support.
Dedicate yum/apt repo on https://repo.pigsty.cc
and mirror on packagecloud.io/pigsty
Use PostgreSQL 16 instead of PostgreSQL 14 as the major candidate version.
New Dashboard: PGSQL Exporter, PGSQL Patroni, Reworked PGSQL Query with new panels & metrics.
Support for self-hosting Supabase with Pigsty managed PostgreSQL cluster on EL 8/9
Support for running PostgresML on Ubuntu 22.04 with CUDA support.
PostgreSQL Extensions Update:
pointcloud
with LIDAR data type support.imgsmlr
, pg_similarity
, and pg_bigm
.hydra
and do not install citus
by default to avoid conflict.pg_filedump
as PG major version independent package.postgis
version to v3.4 on el8, el9, ubuntu22, keep existing 3.3
on EL7pg_embedding
because it is no longer maintained, use pgvector
instead.Software Version Upgrade:
20231013070755
Pigsty has official support for two Ubuntu LTS version: 22.04 (jammy) and 20.04 (focal). Debian 12 (bookworm
) and 11 (bullseye
) is also supported. Pigsty will ship offline pacakges for these four version since v2.5.0.
There are 8 parameters need to be specified explicitly when deploying on Debian/Ubuntu, please refer to ubuntu.yml
& debian.yml
repo_upstream
: Adjust according to ubuntu / debian repo.repo_packages
: Adjust according to ubuntu / debian naming conventionnode_repo_local_urls
: use the default value: ['deb [trusted=yes] http://${admin_ip}/pigsty ./']
node_default_packages
:
zlib
-> zlib1g
, readline
-> libreadline-dev
vim-minimal
-> vim-tiny
, bind-utils
-> dnsutils
, perf
-> linux-tools-generic
,acl
to ensure ansible tmp file privileges are set correctlyinfra_packages
: replace all _
with -
in names, and replace postgresql16
with postgresql-client-16
pg_packages
: replace all _
with -
in names, patroni-etcd
not needed on ubuntupg_extensions
: different naming convention, no passwordcheck_cracklib
on ubuntu.pg_dbsu_uid
: You have to manually specify pg_dbsu_uid
on ubuntu, because PGDG deb package does not specify pg dbsu uid.default values of following parameters have changed:
repo_modules
: infra,node,pgsql,redis,minio
repo_upstream
: Now add Pigsty Infra/MinIO/Redis/PGSQL modular upstream repo.
repo_packages
: remove unused karma,mtail,dellhw_exporter
and pg 14 extra extensions, adding pg 16 extra extensions.
pg_extensions
: citus is nolonger installed by default, and passwordcheck_cracklib
is installed by default
- pg_repack_${pg_version}* wal2json_${pg_version}* passwordcheck_cracklib_${pg_version}*
- postgis34_${pg_version}* timescaledb-2-postgresql-${pg_version}* pgvector_${pg_version}*
29ecffc798b7e1c5180ad42493c4774c pigsty-v2.5.0.tgz
87e0be2edc35b18709d7722976e305b0 pigsty-pkg-v2.5.0.el7.x86_64.tgz
e71304d6f53ea6c0f8e2231f238e8204 pigsty-pkg-v2.5.0.el8.x86_64.tgz
39728496c134e4352436d69b02226ee8 pigsty-pkg-v2.5.0.el9.x86_64.tgz
e3f548a6c7961af6107ffeee3eabc9a7 pigsty-pkg-v2.5.0.debian11.x86_64.tgz
1e469cc86a19702e48d7c1a37e2f14f9 pigsty-pkg-v2.5.0.debian12.x86_64.tgz
cc3af3b7c12f98969d3c6962f7c4bd8f pigsty-pkg-v2.5.0.ubuntu20.x86_64.tgz
c5b2b1a4867eee624e57aed58ac65a80 pigsty-pkg-v2.5.0.ubuntu22.x86_64.tgz
Supabase & PostgresML support, and other new extensions!
Highlights
pg_graphql
reflects a GraphQL schema from the existing SQL schema.pg_net
enables asynchronous (non-blocking) HTTP/HTTPS requests with SQLpgjwt
is the PostgreSQL implementation of JWT (JSON Web Tokens)vault
can store encrypted secrets in the Vaultpg_filedump
for pg 14 & 15, low-level data recovery tool for PostgreSQLhydra
the columnar available for PG 13 - 15. (not packaged due to conflict with citus columnar)proj-data*
7e3989a98b7b0cd213e7efa09a8e8ebc pigsty-v2.4.1.tgz
efabe7632d8994f3fb58f9838b8f9d7d pigsty-pkg-v2.4.1.el7.x86_64.tgz
ea78957e8c8434b120d1c8c43d769b56 pigsty-pkg-v2.4.1.el8.x86_64.tgz
4ef280a7d28872814e34521978b851bb pigsty-pkg-v2.4.1.el9.x86_64.tgz
Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)"
.
Highlights
API Change
REDIS
.redis_sentinel_monitor
: specify masters monitor by redis sentinel clusterMD5 (pigsty-v2.4.0.tgz) = d6d9e6cc3e79f208098f1c7be503d131
MD5 (pigsty-pkg-v2.4.0.el7.x86_64.tgz) = 257443e3c171439914cbfad8e9f72b17
MD5 (pigsty-pkg-v2.4.0.el8.x86_64.tgz) = 41ad8007ffbfe7d5e8ba5c4b51ff2adc
MD5 (pigsty-pkg-v2.4.0.el9.x86_64.tgz) = 9a950aed77a6df90b0265a6fa6029250
Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)"
.
Highlights
Bug Fix
infra
.repo
.repo_pkg
task when downloading rpm with *
in their names in repo_packages
.
/www/pigsty
already have package name match that pattern, some rpm will be skipped.vip_dns_suffix
to ''
empty string rather than .vip
pg_dbsu_sudo
= limit
and patroni_watchdog_mode
= required
/usr/bin/sudo /sbin/modprobe softdog
: enable watchdog module before launching patroni/usr/bin/sudo /bin/chown {{ pg_dbsu }} /dev/watchdog
: chown watchdog before launching patroniDocumentation Update
Software Upgrade
MD5 (pigsty-v2.3.1.tgz) = 024f006ba0df0d2dae047cb2c6aec0fe
MD5 (pigsty-pkg-v2.3.1.el7.x86_64.tgz) = ce69791eb622fa87c543096cdf11f970
MD5 (pigsty-pkg-v2.3.1.el8.x86_64.tgz) = 495aba9d6d18ce1ebed6271e6c96b63a
MD5 (pigsty-pkg-v2.3.1.el9.x86_64.tgz) = 38b45582cbc337ff363144980d0d7b64
Node VIP, Mongo/ferretdb, nocodb, MySQL Stub, and CVE Fix
Get started with bash -c "$(curl -fsSL https://get.pigsty.cc/latest)"
Highlight
node_vip
to node cluster with keepalived
get.pigsty.cc
and demo.pigsty.cc
app/bytebase
to v2.6.0, app/ferretdb
version to v1.8, new application nocodb
API Change
Add 1 new section NODE
.NODE_VIP
with 8 new parameter
NODE
.VIP
.vip_enabled
: enable vip on this node cluster?NODE
.VIP
.vip_address
: node vip address in ipv4 format, required if vip is enabledNODE
.VIP
.vip_vrid
: required, integer, 1-255 should be unique among same VLANNODE
.VIP
.vip_role
: master/backup
, backup by default, use as init roleNODE
.VIP
.vip_preempt
: optional, true/false
, false by default, enable vip preemptionNODE
.VIP
.vip_interface
: node vip network interface to listen, eth0
by defaultNODE
.VIP
.vip_dns_suffix
: node vip dns name suffix, .vip
by defaultNODE
.VIP
.vip_exporter_port
: keepalived exporter listen port, 9650 by defaultMD5 (pigsty-v2.3.0.tgz) = 6b42f339ceeb686c4c4119cc5680fc25
MD5 (pigsty-pkg-v2.3.0.el7.x86_64.tgz) = 81db95f1c591008725175d280ad23615
MD5 (pigsty-pkg-v2.3.0.el8.x86_64.tgz) = 6f4d169b36f6ec4aa33bfd5901c9abbe
MD5 (pigsty-pkg-v2.3.0.el9.x86_64.tgz) = 4bc9ae920e7de6dd8988ca7ee681459d
Get started with bash -c "$(curl -fsSL http://get.pigsty.cc/latest)"
Release Note: https://vonng.github.io/pigsty/#/RELEASENOTE?id=v220
Highlight
Software Upgrade
Bug Fix
bootstrap
& configure
if /etc/redhat-release
not existspglog
schemaAPI Change
Add 1 new parameter
INFRA
.NGINX
.nginx_exporter_enabled
: now you can disable nginx_exporter with this parameterDefault value changes:
repo_modules
: node,pgsql,infra
: redis is removed from itrepo_upstream
:
pigsty-el
: distribution independent rpms: such as grafana, minio, pg_exporter, etc...pigsty-misc
: distribution aware rpms: such as redis, prometheus stack binaries, etc...citus
repo since pgdg now have full official citus support (on el7)remi
, since redis is now included in pigsty-misc
grafana
in build config for accelerationrepo_packages
:
repo_url_packages
:
node_default_packages
:
infra_packages
PGSERVICE
in .pigsty
is removed, replaced with PGDATABASE=postgres
.FHS Changes:
bin/dns
and bin/ssh
now moved to vagrant/
MD5 (pigsty-v2.2.0.tgz) = ecec41c937ef7e9fa6e0bec364d668dd
MD5 (pigsty-pkg-v2.2.0.el7.x86_64.tgz) = 5fb6a449a234e36c0d895a35c76add3c
MD5 (pigsty-pkg-v2.2.0.el8.x86_64.tgz) = c7211730998d3b32671234e91f529fd0
MD5 (pigsty-pkg-v2.2.0.el9.x86_64.tgz) = 385432fe86ee0f8cbccbbc9454472fdd
Install
bash -c "$(curl -fsSL http://download.pigsty.cc/get)"
Highlight
bin/profile
to profile remote process and generate flamegraphbin/validate
to validate pigsty.yml configuration filebin/repo-add
to add upstream repo files to /etc/yum.repos.dpg_stat_io
and corresponding dashboardsSoftware Upgrade
Enhancement
id*.pub
when installing local user's public keyChecksums
MD5 (pigsty-v2.1.0.tgz) = f77d49026c4a4bb4f292a47378ba2fe5
MD5 (pigsty-pkg-v2.1.0.el7.x86_64.tgz) = be8fbb255c2d09a1d02d46824121b304
MD5 (pigsty-pkg-v2.1.0.el8.x86_64.tgz) = 6c2e22c79159d47148423215f12c6bf9
MD5 (pigsty-pkg-v2.1.0.el9.x86_64.tgz) = 687933aa60819bdd7c3b22d102dce371
Highlight
Store OpenAI embedding and search similar vectors with pgvector
pgvector
Changes
pgvector
for storing OpenAI embedding and searching similar vectors.MD5 (pigsty-pkg-v2.0.2.el7.x86_64.tgz) = d46440a115d741386d29d6de646acfe2
MD5 (pigsty-pkg-v2.0.2.el8.x86_64.tgz) = 5fa268b5545ac96b40c444210157e1e1
MD5 (pigsty-pkg-v2.0.2.el9.x86_64.tgz) = c8b113d57c769ee86a22579fc98e8345