search

Vonng / pigsty

Battery-Included PostgreSQL Distro as a Free RDS Alternative
https://pigsty.io
GNU Affero General Public License v3.0
3.01k stars 242 forks source link

OS & PG Compatibility Matrix #331

Closed Vonng closed 5 months ago

Vonng commented 9 months ago

Pigsty is compatible with EL 7,8,9 and ubuntu 22 now.

Currenty we treate the RockyLinux 8.7 / 8.8 as the best OS candidate.

Vendor：RHEL = Rocky ≈ Anolis > Alma > Oracle >> E◾️ler 。

Version: RockyLinux 8.8 (Green Obsidian), 9.1/9.2 , 7.9

Code OS Distro / PG Ver PG16 PG15 PG14 PG13 PG12
EL7 RHEL7 / CentOS7 ⚠️ ⭐️ ✅ ✅ ✅
EL8 RHEL 8 / Rocky8 / Alma8 / Anolis8 ✅ ⭐️ ✅ ✅ ✅
EL9 RHEL 9 / Rocky9 / Alma9 ✅ ⭐️ ✅ ✅ ✅
U22 Ubuntu 22.04 (BETA) ✅ ⭐️ ✅ ✅ ✅
U20 Ubuntu 20.04 (TBD)
D12 Debian 12 (TBD)
D11 Debian 11 (TBD)

If you have any OS want to support and not in the list, make a comment here.

Some Differences

EL7

EL7 Package List ```yaml - ansible python3 python3-pip python36-requests python36-idna yum-utils - grafana loki logcli promtail prometheus2 alertmanager pushgateway - node_exporter blackbox_exporter nginx_exporter redis_exporter mysqld_exporter mongodb_exporter kafka_exporter keepalived_exporter - redis etcd minio mcli haproxy vip-manager pg_exporter ferretdb sealos nginx createrepo_c sshpass chrony dnsmasq docker-ce docker-compose-plugin - lz4 unzip bzip2 zlib yum pv jq git ncdu make patch bash lsof wget uuid tuned nvme-cli numactl grubby sysstat iotop htop rsync tcpdump perf flamegraph - netcat socat ftp lrzsz net-tools ipvsadm bind-utils telnet audit ca-certificates openssl openssh-clients readline vim-minimal keepalived - patroni patroni-etcd pgbouncer pgbadger pgbackrest pgloader pg_activity pg_filedump timescaledb-tools scws - postgresql14* wal2json_14* pg_repack_14* passwordcheck_cracklib_14* postgresql13* wal2json_13* pg_repack_13* passwordcheck_cracklib_13* postgresql12* wal2json_12* pg_repack_12* passwordcheck_cracklib_12* - postgresql15* citus_15* pglogical_15* wal2json_15* pgvector_15* postgis33_15* passwordcheck_cracklib_15* pg_cron_15* pg_repack_15* timescaledb-2-postgresql-15* - pg_tle_15* pgsql-http_15* zhparser_15* pg_roaringbitmap_15* pg_net_15* vault_15 timescaledb-2-postgresql-15* pg_repack_15* hydra_15* apache-age_15 pointcloud_15* - orafce_15* mysqlcompat_15 mongo_fdw_15* tds_fdw_15* mysql_fdw_15 hdfs_fdw_15 sqlite_fdw_15 pgbouncer_fdw_15 multicorn2_15* powa_15* pg_stat_kcache_15* pg_stat_monitor_15* pg_qualstats_15 pg_track_settings_15 pg_wait_sampling_15 system_stats_15 - plprofiler_15* plproxy_15 plsh_15* pldebugger_15 plpgsql_check_15* pgtt_15 pgq_15* pgsql_tweaks_15 count_distinct_15 hypopg_15 timestamp9_15* semver_15* prefix_15* geoip_15 periods_15 ip4r_15 tdigest_15 hll_15 pgmp_15 extra_window_functions_15 topn_15 - pg_background_15 e-maj_15 pg_catcheck_15 pg_prioritize_15 pgcopydb_15 pgcryptokey_15 logerrors_15 pg_top_15 pg_comparator_15 pg_ivm_15* pgsodium_15* pgfincore_15* ddlx_15 credcheck_15 safeupdate_15 pg_squeeze_15* pg_fkpart_15 pg_jobmon_15 rum_15 - pg_partman_15 pg_permissions_15 pgexportdoc_15 pgimportdoc_15 pg_statement_rollback_15* pg_hint_plan_15* pg_auth_mon_15 pg_checksums_15 pg_failover_slots_15 pg_readonly_15* postgresql-unit_15* pg_store_plans_15* pg_uuidv7_15* set_user_15* pgaudit17_15 ```

Ubuntu

Ubuntu Package List ```yaml - ansible python3 python3-pip python3-jmespath dpkg-dev - grafana loki logcli promtail prometheus2 alertmanager pushgateway blackbox-exporter - node-exporter pg-exporter nginx-exporter redis-exporter mysqld-exporter mongodb-exporter kafka-exporter keepalived-exporter - lz4 unzip bzip2 zlib1g pv jq git ncdu make patch bash lsof wget uuid tuned nvme-cli numactl sysstat iotop htop rsync tcpdump linux-tools-generic # linux-perf - netcat socat ftp lrzsz net-tools ipvsadm dnsutils telnet ca-certificates openssl openssh-client libreadline-dev vim-tiny keepalived acl - redis minio mcli etcd haproxy vip-manager2 nginx sshpass chrony dnsmasq docker-ce docker-compose-plugin ferretdb sealos - patroni pgbouncer pgbackrest pgbadger pgloader pg-activity pgloader pg-activity postgresql-filedump - postgresql-client-16 postgresql-16 postgresql-server-dev-16 postgresql-plpython3-16 postgresql-plperl-16 postgresql-pltcl-16 # postgresql-doc-16 - postgresql-client-15 postgresql-15 postgresql-server-dev-15 postgresql-plpython3-15 postgresql-plperl-15 postgresql-pltcl-15 # postgresql-doc-15 - postgresql-client-14 postgresql-14 postgresql-server-dev-14 postgresql-plpython3-14 postgresql-plperl-14 postgresql-pltcl-14 # postgresql-doc-14 - postgresql-client-13 postgresql-13 postgresql-server-dev-13 postgresql-plpython3-13 postgresql-plperl-13 postgresql-pltcl-13 # postgresql-doc-13 - postgresql-client-12 postgresql-12 postgresql-server-dev-12 postgresql-plpython3-12 postgresql-plperl-12 postgresql-pltcl-12 # postgresql-doc-12 - postgresql-15-postgis-3 postgresql-15-postgis-3-scripts postgresql-15-citus-12.1 postgresql-15-pgvector postgresql-15-wal2json postgresql-15-repack timescaledb-2-postgresql-15 postgresql-pgml-15 - postgresql-16-postgis-3 postgresql-16-postgis-3-scripts postgresql-16-citus-12.1 postgresql-16-pgvector postgresql-16-wal2json postgresql-16-repack postgresql-pgml-15 pg-graphql pg-net - postgresql-15-credcheck postgresql-15-cron postgresql-15-debversion postgresql-15-decoderbufs postgresql-15-dirtyread postgresql-15-extra-window-functions postgresql-15-first-last-agg - postgresql-15-hll postgresql-15-hypopg postgresql-15-icu-ext postgresql-15-ip4r postgresql-15-jsquery postgresql-15-londiste-sql postgresql-15-mimeo postgresql-15-mysql-fdw postgresql-15-numeral - postgresql-15-ogr-fdw postgresql-15-omnidb postgresql-15-oracle-fdw postgresql-15-orafce postgresql-15-partman postgresql-15-periods postgresql-15-pg-catcheck postgresql-15-pg-checksums - postgresql-15-pg-fact-loader postgresql-15-pg-qualstats postgresql-15-pg-stat-kcache postgresql-15-pg-track-settings postgresql-15-pg-wait-sampling postgresql-15-pgaudit postgresql-15-pgauditlogtofile - postgresql-15-pgcron postgresql-15-pgextwlist postgresql-15-pgfincore postgresql-15-pgl-ddl-deploy postgresql-15-pglogical postgresql-15-pglogical-ticker postgresql-15-pgmemcache postgresql-15-pgmp - postgresql-15-pgpcre postgresql-15-pgq-node postgresql-15-pgq3 postgresql-15-pgsphere postgresql-15-pgtap postgresql-15-pldebugger postgresql-15-pllua postgresql-15-plpgsql-check - postgresql-15-plprofiler postgresql-15-plproxy postgresql-15-plsh postgresql-15-pointcloud postgresql-15-powa postgresql-15-prefix postgresql-15-preprepare postgresql-15-prioritize - postgresql-15-q3c postgresql-15-rational postgresql-15-rdkit postgresql-15-rum postgresql-15-semver postgresql-15-set-user postgresql-15-show-plans postgresql-15-similarity postgresql-15-squeeze postgresql-15-tablelog postgresql-15-tdigest postgresql-15-tds-fdw postgresql-15-toastinfo postgresql-15-topn postgresql-15-unit - postgresql-16-asn1oid postgresql-16-credcheck postgresql-16-cron postgresql-16-debversion postgresql-16-decoderbufs postgresql-16-dirtyread postgresql-16-extra-window-functions postgresql-16-first-last-agg postgresql-16-hll postgresql-16-hypopg postgresql-16-icu-ext postgresql-16-ip4r postgresql-16-jsquery postgresql-16-londiste-sql - postgresql-16-mimeo postgresql-16-mysql-fdw postgresql-16-numeral postgresql-16-ogr-fdw postgresql-16-oracle-fdw postgresql-16-orafce postgresql-16-partman postgresql-16-periods postgresql-16-pg-catcheck postgresql-16-pg-checksums postgresql-16-pg-qualstats postgresql-16-pg-stat-kcache postgresql-16-pg-track-settings postgresql-16-pg-wait-sampling - postgresql-16-pgcron postgresql-16-pgextwlist postgresql-16-pgfincore postgresql-16-pglogical postgresql-16-pglogical-ticker postgresql-16-pgmp postgresql-16-pgpcre postgresql-16-pgpool2 postgresql-16-pgq-node postgresql-16-pgq3 postgresql-16-pgsphere postgresql-16-pgtap postgresql-16-pldebugger postgresql-16-pgaudit postgresql-16-pgauditlogtofile - postgresql-16-plpgsql-check postgresql-16-plprofiler postgresql-16-plproxy postgresql-16-plsh postgresql-16-pointcloud postgresql-16-powa postgresql-16-prefix postgresql-16-preprepare postgresql-16-prioritize postgresql-16-q3c postgresql-16-rational postgresql-16-rdkit postgresql-16-rum postgresql-16-semver postgresql-16-set-user postgresql-16-show-plans - postgresql-16-similarity postgresql-16-squeeze postgresql-16-tablelog postgresql-16-tdigest postgresql-16-tds-fdw postgresql-16-toastinfo postgresql-16-topn postgresql-16-unit ```