PostgreSQL Extensions that NOT included in the official PGDG repo used by Pigsty.
Related Projects:
pgsql/pkg: Infra Packages, PostgreSQL Deps, ParadeDB, DuckDB, etc.infra_pkg: Building observability stack & modules from tarballpgsql-rpm: Building PostgreSQL RPM packages from source codepgsql-deb: Building PostgreSQL DEB packages from source code
41 Extensions build with c/c++:
12 Rust Extension build with pgrx:
| Vendor | Name | Version | PGRX | License | PG Ver | Deps |
|---|---|---|---|---|---|---|
| Supabase | pg_graphql | v1.5.9 | v0.12.5 | Apache-2.0 | 17,16,15 | |
| Supabase | pg_jsonschema | v0.3.2 | v0.12.5 | Apache-2.0 | 17,16,15,14,13,12 | |
| Supabase | wrappers | v0.4.3 | v0.12.6 | Apache-2.0 | 17,16,15,14 | |
| TimescaleDB | vectorscale | v0.3.0 | v0.12.5 | PostgreSQL | 17,16,15,14,13,12 | |
| kelvich | pg_tiktoken | v0.0.1 | v0.12.6 | Apache-2.0 | 16,15,14,13,12 | |
| PostgresML | pgml | v2.9.3 | v0.11.3 | MIT | 16,15,14 | |
| Tembo | pg_vectorize | v0.17.0 | v0.11.3 | PostgreSQL | 16,15,14 | pgmq, pg_cron |
| Tembo | pg_later | v0.1.1 | v0.11.3 | PostgreSQL | 16,15,14,13 | pgmq |
| kaspermarstal | plprql | v0.1.0 | v0.11.3 | Apache-2.0 | 16,15,14,13,12 | |
| VADOSWARE | pg_idkit | v0.2.3 | v0.12.5 | Apache-2.0 | 17,16,15,14,13,12 | |
| pgsmcrypto | pgsmcrypto | v0.1.0 | v0.12.6 | MIT | 17,16,15,14,13,12 | |
| rustprooflabs | pgdd | v0.5.2 | v0.10.2 | MIT | 16,15,14,13,12 |
13 Extensions that is obsolete due to included in PGDG or no longer maintained:
| Extension | SPEC | Comment |
|---|---|---|
| pg_net | v0.9.2 | PGDG included, N/A in el7 |
| pg_tle | v1.3.4 | PGDG included, for el7 only |
| pg_bigm | v1.2 | PGDG included, for el7 only |
| pgsql-http | v1.6.0 | PGDG included, for el7 only |
| pgsql-gzip | v1.0.0 | PGDG included, for el7 only |
| pg_dirtyread | v2.7 | PGDG included, for el7 only |
| pointcloud | v1.2.5 | PGDG included, for el7 only |
| pg_analytics | v0.6.1 | No longer maintained |
| pg_sparse | v0.6.1 | No longer maintained |
| pg_rrule | v0.2.0 | broken |
| pg_proctab | v0.0.10 | broken |
| pg_search | v0.8.6 | take over by paradedb |
| pg_lakehouse | v0.8.6 | take over by paradedb |
| unit | v7.7 | PGDG included |
| mysqlcompat | v0.0.7 | Obsolete |
# launch pigsty 3-node el build envgst
cd ~/pigsty; make clean; make rpm
./node.yml -i files/pigsty/rpmbuild.yml -t node_repo,node_pkg
# create rpmbuild fhs
rpmdev-setuptree
# install ad hoc packages
sudo yum groupinstall --nobest -y 'Development Tools'; # el8 only logic
sudo cpanm FindBin; perl -MFindBin -e 1 # el9 only logic
# push source to el building VM
make ps # make push-ss (specs & sources)EL 8/9 Building Recipe:
make rust deps plv8 batch1 batch2 batch3 batch4 batch5
batch1: zhparser duckdb_fdw hunspell pg_roaringbitmap pgjwt pg_sqlog pg_hashids postgres_shacrypt permuteseq vault supautils imgsmlr pg_similarity hydra age age15 pg_tde md5hash #pg_proctab
batch2: preprepare first_last_agg pgpcre icu_ext asn1oid numeral pg_rational q3c pgsphere pg_rrule pgfaceting mimeo tablelog pg_snakeoil pgextwlist toastinfo
batch3: geoip table_version plproxy unit
batch4: pg_orphaned pgcozy decoder_raw pg_failover_slots log_fdw index_advisor pg_financial pg_savior aggs_for_vecs pg_base36 pg_base62 pg_envvar pg_html5_email_address lower_quantile pg_timeit quantile pg_random session_variable smlar sslutils pg_mon chkpass pg_currency pg_emailaddr pg_uri cryptint floatvec pg_auditor noset redis_fdw
batch5: aggs_for_arrays pgqr pg_zstd url_encode pg_geohash pg_meta pg_redis_pubsub pg_arraymath pagevis pg_ecdsa pg_cheat_funcs acl pg_crash pg_mathEL7 Building Recipe:
make deps common debian legacy
deps: scws scws-install pg_filedump
batch1: zhparser hunspell pg_roaringbitmap pgjwt pg_sqlog pg_hashids postgres_shacrypt permuteseq vault pointcloud imgsmlr pg_similarity hydra age15 md5hash
batch2: preprepare first_last_agg pgpcre icu_ext asn1oid numeral pg_rational q3c pgsphere pgfaceting mimeo table_log pg_snakeoil pgextwlist toastinfo
batch4: pg_orphaned pgcozy decoder_raw pg_failover_slots log_fdw index_advisor pg_financial pg_savior aggs_for_vecs pg_base36 pg_base62 pg_envvar pg_html5_email_address lower_quantile pg_timeit quantile pg_random session_variable smlar sslutils pg_mon chkpass pg_currency pg_emailaddr pg_uri cryptint floatvec pg_auditor noset redis_fdw
batch5: aggs_for_arrays pgqr pg_zstd url_encode pg_geohash pg_meta pg_arraymath pagevis pg_ecdsa pg_cheat_funcs acl pg_crash pg_math sequential_uuids pgnodemx pg_protobuf pg_country pg_fio aws_s3 firebird_fdw # pg_redis_pubsub kafka_fdw pg_hashlibMaintainer: Ruohang Feng / @Vonng ([email protected])
License: Apache 2.0