-
Notifications
You must be signed in to change notification settings - Fork 257
/
deb.yml
453 lines (425 loc) · 34.7 KB
/
deb.yml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
---
repo_upstream_default: # used according to `os_package`, if `repo_upstream` not set
- { name: pigsty-local ,description: 'Pigsty Local' ,module: local ,releases: [11,12,20,22] ,baseurl: { default: 'http://${admin_ip}/pigsty ./' }}
- { name: pigsty-pgsql ,description: 'Pigsty PgSQL' ,module: pgsql ,releases: [11,12,20,22] ,baseurl: { default: 'https://repo.pigsty.io/apt/pgsql/${distro_codename} ${distro_codename} main', china: 'https://repo.pigsty.cc/apt/pgsql/${distro_codename} ${distro_codename} main' }}
- { name: pigsty-infra ,description: 'Pigsty Infra' ,module: infra ,releases: [11,12,20,22] ,baseurl: { default: 'https://repo.pigsty.io/apt/infra/ generic main' ,china: 'https://repo.pigsty.cc/apt/infra/ generic main' }}
- { name: nginx ,description: 'Nginx' ,module: infra ,releases: [11,12,20,22] ,baseurl: { default: 'http://nginx.org/packages/mainline/${distro_name} ${distro_codename} nginx' }}
- { name: base ,description: 'Debian Basic' ,module: node ,releases: [11,12 ] ,baseurl: { default: 'http://deb.debian.org/debian/ ${distro_codename} main non-free-firmware' ,china: 'https://mirrors.aliyun.com/debian/ ${distro_codename} main restricted universe multiverse' }}
- { name: updates ,description: 'Debian Updates' ,module: node ,releases: [11,12 ] ,baseurl: { default: 'http://deb.debian.org/debian/ ${distro_codename}-updates main non-free-firmware' ,china: 'https://mirrors.aliyun.com/debian/ ${distro_codename}-updates main restricted universe multiverse' }}
- { name: security ,description: 'Debian Security' ,module: node ,releases: [11,12 ] ,baseurl: { default: 'http://security.debian.org/debian-security ${distro_codename}-security main non-free-firmware' }}
- { name: base ,description: 'Ubuntu Basic' ,module: node ,releases: [ 20,22] ,baseurl: { default: 'https://mirrors.edge.kernel.org/${distro_name}/ ${distro_codename} main universe multiverse restricted' ,china: 'https://mirrors.aliyun.com/${distro_name}/ ${distro_codename} main restricted universe multiverse' }}
- { name: updates ,description: 'Ubuntu Updates' ,module: node ,releases: [ 20,22] ,baseurl: { default: 'https://mirrors.edge.kernel.org/ubuntu/ ${distro_codename}-backports main restricted universe multiverse' ,china: 'https://mirrors.aliyun.com/ubuntu/ ${distro_codename}-updates main restricted universe multiverse' }}
- { name: backports ,description: 'Ubuntu Backports' ,module: node ,releases: [ 20,22] ,baseurl: { default: 'https://mirrors.edge.kernel.org/ubuntu/ ${distro_codename}-security main restricted universe multiverse' ,china: 'https://mirrors.aliyun.com/ubuntu/ ${distro_codename}-backports main restricted universe multiverse' }}
- { name: security ,description: 'Ubuntu Security' ,module: node ,releases: [ 20,22] ,baseurl: { default: 'https://mirrors.edge.kernel.org/ubuntu/ ${distro_codename}-updates main restricted universe multiverse' ,china: 'https://mirrors.aliyun.com/ubuntu/ ${distro_codename}-security main restricted universe multiverse' }}
- { name: pgdg ,description: 'PGDG' ,module: pgsql ,releases: [11,12,20,22] ,baseurl: { default: 'http://apt.postgresql.org/pub/repos/apt/ ${distro_codename}-pgdg main' ,china: 'https://mirrors.tuna.tsinghua.edu.cn/postgresql/repos/apt/ ${distro_codename}-pgdg main' }}
- { name: citus ,description: 'Citus' ,module: pgsql ,releases: [11,12,20,22] ,baseurl: { default: 'https://packagecloud.io/citusdata/community/${distro_name}/ ${distro_codename} main' }}
- { name: timescaledb ,description: 'Timescaledb' ,module: pgsql ,releases: [11,12,20,22] ,baseurl: { default: 'https://packagecloud.io/timescale/timescaledb/${distro_name}/ ${distro_codename} main' }}
# these repos are not used by default, but can be enabled by setting repo_modules
- { name: grafana ,description: 'Grafana' ,module: grafana ,releases: [11,12,20,22] ,baseurl: { default: 'https://apt.grafana.com stable main' ,china: 'https://mirrors.tuna.tsinghua.edu.cn/grafana/apt/ stable main' }}
- { name: haproxy ,description: 'HAProxy Debian' ,module: haproxy ,releases: [11,12 ] ,baseurl: { default: 'http://haproxy.debian.net ${distro_codename}-backports-2.9 main' }}
- { name: haproxy ,description: 'HAProxy Ubuntu' ,module: haproxy ,releases: [ 20,22] ,baseurl: { default: 'https://ppa.launchpadcontent.net/vbernat/haproxy-2.9/ubuntu/ ${distro_codename} main' }}
- { name: redis ,description: 'Redis' ,module: redis ,releases: [11,12,20,22] ,baseurl: { default: 'https://packages.redis.io/deb ${distro_codename} main' }}
- { name: pgml ,description: 'PostgresML' ,module: pgml ,releases: [ 22] ,baseurl: { default: 'https://apt.postgresml.org ${distro_codename} main' }}
- { name: wiltondb ,description: 'WiltonDB' ,module: mssql ,releases: [ 20,22] ,baseurl: { default: 'https://ppa.launchpadcontent.net/wiltondb/wiltondb/ubuntu/ ${distro_codename} main' }}
- { name: mysql ,description: 'MySQL' ,module: mysql ,releases: [11,12,20,22] ,baseurl: { default: 'https://repo.mysql.com/apt/${distro_name} ${distro_codename} mysql-8.0 mysql-tools', china: 'https://mirrors.tuna.tsinghua.edu.cn/mysql/apt/${distro_name} ${distro_codename} mysql-8.0 mysql-tools' }}
- { name: docker-ce ,description: 'Docker' ,module: docker ,releases: [11,12,20,22] ,baseurl: { default: 'https://download.docker.com/linux/${distro_name} ${distro_codename} stable' ,china: 'https://mirrors.tuna.tsinghua.edu.cn/docker-ce/linux//${distro_name} ${distro_codename} stable' }}
- { name: kubernetes ,description: 'Kubernetes' ,module: kube ,releases: [11,12,20,22] ,baseurl: { default: 'https://pkgs.k8s.io/core:/stable:/v1.31/deb/ /', china: 'https://mirrors.aliyun.com/kubernetes-new/core/stable/v1.31/deb/ /' }}
repo_packages_default: # used according to `os_package`, if `repo_packages` not set
- ansible python3 python3-pip python3-venv python3-jmespath dpkg-dev sshpass # Distro & Boot
- nginx dnsmasq etcd haproxy vip-manager pg-exporter pgbackrest-exporter # Pigsty Addons
- grafana loki logcli promtail prometheus2 alertmanager pushgateway node-exporter blackbox-exporter nginx-exporter keepalived-exporter # Infra Packages
- redis-exporter redis minio mcli ferretdb duckdb # Extra Modules
- lz4 unzip bzip2 zlib1g pv jq git ncdu make patch bash lsof wget uuid tuned nvme-cli numactl sysstat iotop htop rsync tcpdump acl chrony # Node Tools 1
- socat lrzsz net-tools ipvsadm dnsutils telnet ca-certificates libreadline-dev vim-tiny keepalived openssl openssh-server openssh-client # Node Tools 2
- patroni pgbouncer pgbackrest pgbadger pg-activity postgresql-filedump pgxnclient pgformatter pgcopydb pgloader # PGDG Common
- postgresql-16 postgresql-client-16 postgresql-server-dev-16 postgresql-plpython3-16 postgresql-plperl-16 postgresql-pltcl-16 # PostgreSQL 16
- timescaledb-2-postgresql-16 postgresql-16-periods postgresql-16-temporal-tables postgresql-16-emaj postgresql-16-tableversion postgresql-16-cron postgresql-16-pg-later postgresql-16-pg-background pg-timetable
- postgresql-16-postgis-3 postgresql-16-postgis-3-scripts postgresql-16-pgrouting postgresql-16-pgrouting-scripts postgresql-16-pointcloud postgresql-16-h3 postgresql-16-q3c postgresql-16-ogr-fdw postgresql-16-geoip postgresql-16-mobilitydb
- postgresql-16-pgvector postgresql-16-pgvectorscale postgresql-16-pg-vectorize postgresql-16-similarity postgresql-16-pg-tiktoken postgresql-16-pgml #postgresql-16-smlar
- postgresql-16-pg-search postgresql-16-pg-bigm postgresql-16-zhparser postgresql-16-hunspell-cs-cz postgresql-16-hunspell-de-de postgresql-16-hunspell-en-us postgresql-16-hunspell-fr postgresql-16-hunspell-ne-np postgresql-16-hunspell-nl-nl postgresql-16-hunspell-nn-no postgresql-16-hunspell-pt-pt postgresql-16-hunspell-ru-ru postgresql-16-hunspell-ru-ru-aot
- postgresql-16-citus-12.1 postgresql-16-hydra postgresql-16-pg-analytics postgresql-16-pg-lakehouse postgresql-16-duckdb-fdw postgresql-16-pg-fkpart postgresql-16-partman postgresql-16-plproxy #postgresql-16-pg-duckdb
- postgresql-16-pg-hint-plan postgresql-16-age postgresql-16-hll postgresql-16-rum postgresql-16-pg-graphql postgresql-16-pg-jsonschema postgresql-16-jsquery postgresql-16-index-advisor postgresql-16-hypopg postgresql-16-imgsmlr postgresql-16-pg-ivm postgresql-16-pgmq postgresql-16-pgq3 postgresql-16-rdkit
- postgresql-16-pg-tle postgresql-16-plv8 postgresql-16-pllua postgresql-16-plprql postgresql-16-pldebugger postgresql-16-plpgsql-check postgresql-16-plprofiler postgresql-16-plsh #postgresql-16-pljava postgresql-16-plr postgresql-16-pgtap
- postgresql-16-prefix postgresql-16-semver postgresql-16-unit postgresql-16-md5hash postgresql-16-asn1oid postgresql-16-roaringbitmap postgresql-16-pgfaceting postgresql-16-pgsphere postgresql-16-pg-country postgresql-16-pg-currency postgresql-16-pgmp postgresql-16-numeral postgresql-16-rational postgresql-16-pguint postgresql-16-ip4r postgresql-16-debversion postgresql-16-pg-rrule postgresql-16-chkpass #postgresql-16-pg-uri #postgresql-1616-pg-emailaddr #postgresql-16-acl
- postgresql-16-topn postgresql-16-gzip postgresql-16-http postgresql-16-pg-net postgresql-16-pg-html5-email-address postgresql-16-pgsql-tweaks postgresql-16-pg-extra-time postgresql-16-pg-timeit postgresql-16-count-distinct postgresql-16-extra-window-functions postgresql-16-first-last-agg postgresql-16-tdigest postgresql-16-aggs-for-arrays postgresql-16-pg-arraymath postgresql-16-pg-idkit postgresql-16-pg-uuidv7 postgresql-16-permuteseq postgresql-16-pg-hashids postgresql-16-sequential-uuids
- postgresql-16-pg-math postgresql-16-random postgresql-16-base36 postgresql-16-base62 postgresql-16-floatvec postgresql-16-pg-financial postgresql-16-pgjwt postgresql-16-pg-hashlib postgresql-16-shacrypt postgresql-16-cryptint postgresql-16-pg-ecdsa postgresql-16-pgpcre postgresql-16-icu-ext postgresql-16-pg-envvar postgresql-16-url-encode #postgresql-16-pg-zstd #postgresql-16-aggs-for-vecs #postgresql-16-quantile #postgresql-16-lower-quantile #postgresql-16-pgqr #postgresql-16-pg-protobuf
- postgresql-16-repack postgresql-16-squeeze postgresql-16-dirtyread postgresql-16-pgfincore postgresql-16-pgdd postgresql-16-ddlx postgresql-16-prioritize postgresql-16-pg-checksums postgresql-16-pg-readonly postgresql-16-pg-safeupdate postgresql-16-pg-permissions postgresql-16-auto-failover postgresql-16-pg-catcheck postgresql-16-preprepare postgresql-16-pgcozy postgresql-16-pg-orphaned postgresql-16-pg-crash postgresql-16-pg-cheat-funcs postgresql-16-pg-savior postgresql-16-tablelog postgresql-16-pg-fio #postgresql-16-pgpool2 pgagent
- postgresql-16-pg-profile postgresql-16-show-plans postgresql-16-pg-stat-kcache postgresql-16-pg-stat-monitor postgresql-16-pg-qualstats postgresql-16-pg-store-plan postgresql-16-pg-track-settings postgresql-16-pg-wait-sampling postgresql-16-system-stats postgresql-16-pg-meta postgresql-16-pgnodemx postgresql-16-pg-sqlog postgresql-16-bgw-replstatus postgresql-16-pgmeminfo postgresql-16-toastinfo postgresql-16-pagevis postgresql-16-powa #postgresql-16-pg-mon #postgresql-16-statviz
- postgresql-16-passwordcheck-cracklib postgresql-16-supautils postgresql-16-pgsodium postgresql-16-vault postgresql-16-anonymizer postgresql-16-pg-tde postgresql-16-pgsmcrypto postgresql-16-pgaudit postgresql-16-pgauditlogtofile postgresql-16-pg-auth-mon postgresql-16-credcheck postgresql-16-pgcryptokey postgresql-16-pg-jobmon postgresql-16-logerrors postgresql-16-login-hook postgresql-16-set-user postgresql-16-snakeoil postgresql-16-pgextwlist postgresql-16-pg-auditor postgresql-16-noset #postgresql-16-sslutils
- postgresql-16-wrappers postgresql-16-mysql-fdw postgresql-16-tds-fdw postgresql-16-sqlite-fdw postgresql-16-redis-fdw postgresql-16-pg-redis-pubsub postgresql-16-kafka-fdw postgresql-16-aws-s3 postgresql-16-log-fdw #postgresql-16-oracle-fdw postgresql-16-firebird-fdw
- postgresql-16-orafce postgresql-16-pgtt postgresql-16-session-variable postgresql-16-pg-statement-rollback postgresql-16-pgmemcache #wiltondb
- postgresql-16-pglogical postgresql-16-pglogical-ticker postgresql-16-pgl-ddl-deploy postgresql-16-pg-failover-slots postgresql-16-wal2json postgresql-16-wal2mongo postgresql-16-decoderbufs postgresql-16-decoder-raw postgresql-16-mimeo postgresql-16-repmgr pgcopydb pgloader postgresql-16-pg-fact-loader postgresql-16-pg-bulkload
systemd_dir: /lib/systemd/system
node_packages_default: # used according to `os_package`, if `node_default_packages` not set
- lz4,unzip,bzip2,pv,jq,git,ncdu,make,patch,bash,lsof,wget,uuid,tuned,nvme-cli,numactl,sysstat,iotop,htop,rsync,tcpdump
- python3,python3-pip,socat,lrzsz,net-tools,ipvsadm,telnet,ca-certificates,openssl,keepalived,etcd,haproxy,chrony
- zlib1g,acl,dnsutils,libreadline-dev,vim-tiny,node-exporter,openssh-server,openssh-client
infra_packages_default: # used according to `os_package`, if `infra_packages` not set
- grafana,loki,logcli,promtail,prometheus2,alertmanager,pushgateway
- node-exporter,blackbox-exporter,nginx-exporter,pg-exporter
- nginx,dnsmasq,ansible,etcd,python3-requests,redis,mcli
pg_home_map:
pgsql: '/usr/lib/postgresql/$v'
citus: '/usr/lib/postgresql/$v'
mssql: '/usr/lib/postgresql/$v'
polar: '/u01/polardb_pg'
oracle: '/u01/polardb_pg'
#ivory
#gpsql
pg_package_map:
#-----------------------------------------------------------------
# MODULE: NODE
#-----------------------------------------------------------------
debian-node-adhoc: "netcat-openbsd,tnftp,linux-perf"
ubuntu-node-adhoc: "netcat,ftp,linux-tools-generic"
#-----------------------------------------------------------------
# MODULE: PGSQL
#-----------------------------------------------------------------
#--------------------------------#
# ALIAS: Minimal Installation
#--------------------------------#
postgresql: "postgresql-*-$v"
pgsql-common: "patroni,pgbouncer,pgbackrest,pg-exporter,pgbadger,vip-manager"
pgsql-utils: "postgresql-$v-repack,postgresql-$v-wal2json"
#--------------------------------#
# PGSQL: the Kernel Packages
#--------------------------------#
pgsql: "postgresql*-$v"
pgsql-client: "postgresql-client-$v"
pgsql-server: "postgresql-$v"
pgsql-simple: "postgresql-$v,postgresql-client-$v,postgresql-plperl-$v,postgresql-plpython3-$v,postgresql-pltcl-$v"
pgsql-all: "postgresql-$v,postgresql-client-$v,postgresql-plperl-$v,postgresql-plpython3-$v,postgresql-pltcl-$v,postgresql-server-dev-$v"
pgsql-devel: "postgresql-server-dev-$v"
pgsql-devel-all: "postgresql-server-dev-16,postgresql-server-dev-15,postgresql-server-dev-14,postgresql-server-dev-13,postgresql-server-dev-12"
pgsql-17: "postgresql*-17"
pgsql-16: "postgresql*-16"
pgsql-15: "postgresql*-15"
pgsql-14: "postgresql*-14"
pgsql-13: "postgresql*-13"
pgsql-12: "postgresql*-12"
babelfish: "wiltondb" # WiltonDB, Ubuntu only, N/A in Debian System
polardb: "polardb-for-postgresql" # PolarDB PG, Ubuntu only, N/A in Debian System
ivorysql: "" # N/A in Deb Distro
greenplum6: "" # N/A in Deb Distro
greenplum7: "" # N/A in Deb Distro
#--------------------------------#
# COMMON: Important Utils
#--------------------------------#
patroni: "patroni"
pgbouncer: "pgbouncer"
pgbackrest: "pgbackrest"
pg_exporter: "pg-exporter"
vip-manager: "vip-manager"
pgbadger: "pgbadger"
pg_activity: "pg-activity"
pg_filedump: "postgresql-filedump"
pgxnclient: "pgxnclient"
pgformatter: "pgformatter"
#--------------------------------#
# STACK: Pre-defined Collections
#--------------------------------#
gis-stack: "postgresql-$v-postgis-3,postgresql-$v-postgis-3-scripts,postgresql-$v-pointcloud,postgresql-$v-h3,postgresql-$v-q3c,postgresql-$v-ogr-fdw,postgresql-$v-pgrouting,postgresql-$v-pgrouting-scripts"
rag-stack: "postgresql-$v-pgvector,postgresql-$v-pgvectorscale,postgresql-$v-pg-vectorize,postgresql-$v-similarity,postgresql-$v-pg-tiktoken,postgresql-$v-pgml"
fts-stack: "postgresql-$v-pg-search,postgresql-$v-pg-bigm,postgresql-$v-zhparser,postgresql-$v-hunspell-cs-cz,postgresql-$v-hunspell-de-de,postgresql-$v-hunspell-en-us,postgresql-$v-hunspell-fr,postgresql-$v-hunspell-ne-np,postgresql-$v-hunspell-nl-nl,postgresql-$v-hunspell-nn-no,postgresql-$v-hunspell-ru-ru,postgresql-$v-hunspell-ru-ru-aot"
fdw-stack: "postgresql-$v-wrappers,postgresql-$v-mysql-fdw,postgresql-$v-tds-fdw,postgresql-$v-sqlite-fdw"
etl-stack: "postgresql-$v-pglogical,postgresql-$v-pglogical-ticker,postgresql-$v-pgl-ddl-deploy,postgresql-$v-wal2json,postgresql-$v-wal2mongo,postgresql-$v-decoderbufs,postgresql-$v-pg-fact-loader,postgresql-$v-pg-bulkload,pgloader,pgcopydb"
feat-stack: "postgresql-$v-age,postgresql-$v-hll,postgresql-$v-rum,postgresql-$v-pg-graphql,postgresql-$v-pg-jsonschema,postgresql-$v-jsquery,postgresql-$v-pg-ivm,postgresql-$v-pgq3,postgresql-$v-gzip,postgresql-$v-http,postgresql-$v-topn,postgresql-$v-pgjwt"
olap-stack: "duckdb,postgresql-$v-duckdb-fdw,postgresql-$v-pg-lakehouse,postgresql-$v-hydra,timescaledb-2-postgresql-$v,postgresql-$v-pg-fkpart,postgresql-$v-partman,postgresql-$v-plproxy"
supa-stack: "postgresql-$v-pg-graphql,postgresql-$v-pg-jsonschema,postgresql-$v-wrappers,postgresql-$v-pgvector,postgresql-$v-cron,postgresql-$v-pgsodium,postgresql-$v-vault,postgresql-$v-pgjwt,postgresql-$v-http,postgresql-$v-pg-net,postgresql-$v-supautils,postgresql-$v-index-advisor"
stat-stack: "postgresql-$v-show-plans,postgresql-$v-pg-stat-kcache,postgresql-$v-pg-qualstats,postgresql-$v-pg-track-settings,postgresql-$v-pg-wait-sampling,postgresql-$v-pg-sqlog"
json-stack: "postgresql-$v-plv8,postgresql-$v-pg-jsonschema,postgresql-$v-pgjwt,postgresql-$v-jsquery,postgresql-$v-pg-graphql,ferretdb"
#--------------------------------#
# TIME: TSDB, Temporal, Cron
#--------------------------------#
timescaledb: 'timescaledb-2-postgresql-$v'
periods: 'postgresql-$v-periods'
temporal_tables: 'postgresql-$v-temporal-tables'
emaj: 'postgresql-$v-emaj'
table_version: 'postgresql-$v-tableversion'
pg_cron: 'postgresql-$v-cron'
pg_later: 'postgresql-$v-pg-later'
pg_background: 'postgresql-$v-pg-background'
pg_timetable: "pg-timetable"
#--------------------------------#
# GIS: GeoSpatial, Routing
#--------------------------------#
postgis: 'postgresql-$v-postgis-3,postgresql-$v-postgis-3-scripts'
pgrouting: 'postgresql-$v-pgrouting,postgresql-$v-pgrouting-scripts'
pointcloud: 'postgresql-$v-pointcloud'
pg_h3: 'postgresql-$v-h3'
q3c: 'postgresql-$v-q3c'
ogr_fdw: 'postgresql-$v-ogr-fdw'
geoip: 'postgresql-$v-geoip'
pg_geohash: '' # N/A for Deb Distro & PG16
mobilitydb: 'postgresql-$v-mobilitydb'
#--------------------------------#
# RAG: AI, ML, Vector
#--------------------------------#
pgvector: 'postgresql-$v-pgvector'
pgvectorscale: 'postgresql-$v-pgvectorscale'
pg_vectorize: 'postgresql-$v-pg-vectorize'
pg_similarity: 'postgresql-$v-similarity'
smlar: 'postgresql-$v-smlar' # N/A for PG16
pg_tiktoken: 'postgresql-$v-pg-tiktoken'
pgml: 'postgresql-$v-pgml'
#--------------------------------#
# FTS: Full-Text Search
#--------------------------------#
pg_search: 'postgresql-$v-pg-search'
pg_bigm: 'postgresql-$v-pg-bigm'
zhparser: 'postgresql-$v-zhparser'
hunspell: 'postgresql-$v-hunspell-cs-cz,postgresql-$v-hunspell-de-de,postgresql-$v-hunspell-en-us,postgresql-$v-hunspell-fr,postgresql-$v-hunspell-ne-np,postgresql-$v-hunspell-nl-nl,postgresql-$v-hunspell-nn-no,postgresql-$v-hunspell-ru-ru,postgresql-$v-hunspell-ru-ru-aot'
hunspell_cs_cz: 'postgresql-$v-hunspell-cs-cz'
hunspell_de_de: 'postgresql-$v-hunspell-de-de'
hunspell_en_us: 'postgresql-$v-hunspell-en-us'
hunspell_fr: 'postgresql-$v-hunspell-fr'
hunspell_ne_np: 'postgresql-$v-hunspell-ne-np'
hunspell_nl_nl: 'postgresql-$v-hunspell-nl-nl'
hunspell_nn_no: 'postgresql-$v-hunspell-nn-no'
hunspell_pt_pt: 'postgresql-$v-hunspell-pt-pt'
hunspell_ru_ru: 'postgresql-$v-hunspell-ru-ru'
hunspell_ru_ru_aot: 'postgresql-$v-hunspell-ru-ru-aot'
#--------------------------------#
# OLAP: Columnar, Lakehouse, Shard
#--------------------------------#
citus: 'postgresql-$v-citus-12.1' # conflict with hydra, choose one from them
hydra: 'postgresql-$v-hydra' # conflict with citus, choose one from them
pg_analytics: 'postgresql-$v-pg-analytics'
pg_lakehouse: 'postgresql-$v-pg-lakehouse'
duckdb_fdw: 'postgresql-$v-duckdb-fdw'
pg_fkpart: 'postgresql-$v-pg-fkpart'
pg_partman: 'postgresql-$v-partman'
plproxy: 'postgresql-$v-plproxy'
pg_strom: '' # N/A for Deb Distro
#--------------------------------#
# FEAT: Featured, Graph, AM, MQ
#--------------------------------#
age: 'postgresql-$v-age'
hll: 'postgresql-$v-hll'
rum: 'postgresql-$v-rum'
pg_graphql: 'postgresql-$v-pg-graphql'
pg_jsonschema: 'postgresql-$v-pg-jsonschema'
jsquery: 'postgresql-$v-jsquery'
pg_hint_plan: 'postgresql-$v-pg-hint-plan'
index_advisor: 'postgresql-$v-index-advisor'
hypopg: 'postgresql-$v-hypopg'
imgsmlr: 'postgresql-$v-imgsmlr'
pg_ivm: 'postgresql-$v-pg-ivm'
pgmq: 'postgresql-$v-pgmq'
pgq: 'postgresql-$v-pgq3'
rdkit: 'postgresql-$v-rdkit'
#--------------------------------#
# LANG: PL/Languages & Test
#--------------------------------#
pg_tle: 'postgresql-$v-pg-tle'
plv8: 'postgresql-$v-plv8'
pllua: 'postgresql-$v-pllua'
plprql: 'postgresql-$v-plprql'
pldebugger: 'postgresql-$v-pldebugger'
plpgsql_check: 'postgresql-$v-plpgsql-check'
plprofiler: 'postgresql-$v-plprofiler'
plsh: 'postgresql-$v-plsh'
pljava: 'postgresql-$v-pljava' # too-heavy, N/A by default
plr: 'postgresql-$v-plr' # too-heavy, N/A by default
pgtap: 'postgresql-$v-pgtap' # broken perl deps
faker: '' # N/A for Deb Distro
dbt2: '' # N/A for Deb Distro
#--------------------------------#
# TYPE: New Data Types
#--------------------------------#
prefix: 'postgresql-$v-prefix'
semver: 'postgresql-$v-semver'
pgunit: 'postgresql-$v-unit'
md5hash: 'postgresql-$v-md5hash'
asn1oid: 'postgresql-$v-asn1oid'
roaringbitmap: 'postgresql-$v-roaringbitmap'
pgfaceting: 'postgresql-$v-pgfaceting'
pgsphere: 'postgresql-$v-pgsphere'
pg_country: 'postgresql-$v-pg-country'
pg_currency: 'postgresql-$v-pg-currency'
pgmp: 'postgresql-$v-pgmp'
numeral: 'postgresql-$v-numeral'
pg_rational: 'postgresql-$v-rational'
pguint: 'postgresql-$v-pguint'
ip4r: 'postgresql-$v-ip4r'
pg_uri: 'postgresql-$v-pg-uri' # N/A for PG16
pgemailaddr: 'postgresql-$v$v-pg-emailaddr' # N/A for PG16
acl: 'postgresql-$v-acl' # N/A for PG16
debversion: 'postgresql-$v-debversion'
pg_rrule: 'postgresql-$v-pg-rrule'
timestamp9: '' # N/A for Deb Distro
chkpass: 'postgresql-$v-chkpass'
#--------------------------------#
# FUNC: Agg, Utils, IDKits
#--------------------------------#
topn: 'postgresql-$v-topn'
pg_gzip: 'postgresql-$v-gzip'
pg_zstd: 'postgresql-$v-pg-zstd' # N/A for PG16
pg_http: 'postgresql-$v-http'
pg_net: 'postgresql-$v-pg-net'
pg_html5_email_address: 'postgresql-$v-pg-html5-email-address'
pgsql_tweaks: 'postgresql-$v-pgsql-tweaks'
pg_extra_time: 'postgresql-$v-pg-extra-time'
pg_timeit: 'postgresql-$v-pg-timeit'
count_distinct: 'postgresql-$v-count-distinct'
extra_window_functions: 'postgresql-$v-extra-window-functions'
first_last_agg: 'postgresql-$v-first-last-agg'
tdigest: 'postgresql-$v-tdigest'
aggs_for_vecs: 'postgresql-$v-aggs-for-vecs' # N/A for PG16
aggs_for_arrays: 'postgresql-$v-aggs-for-arrays'
pg_arraymath: 'postgresql-$v-pg-arraymath'
quantile: 'postgresql-$v-quantile'
lower_quantile: 'postgresql-$v-lower-quantile' # N/A for PG16
pg_idkit: 'postgresql-$v-pg-idkit'
pg_uuidv7: 'postgresql-$v-pg-uuidv7'
permuteseq: 'postgresql-$v-permuteseq'
pg_hashids: 'postgresql-$v-pg-hashids'
sequential_uuids: 'postgresql-$v-sequential-uuids'
pg_math: 'postgresql-$v-pg-math'
pg_random: 'postgresql-$v-random'
pg_base36: 'postgresql-$v-base36'
pg_base62: 'postgresql-$v-base62'
floatvec: 'postgresql-$v-floatvec'
pg_financial: 'postgresql-$v-pg-financial'
pgjwt: 'postgresql-$v-pgjwt'
pg_hashlib: 'postgresql-$v-pg-hashlib'
shacrypt: 'postgresql-$v-shacrypt'
cryptint: 'postgresql-$v-cryptint'
pg_ecdsa: 'postgresql-$v-pg-ecdsa'
pgpcre: 'postgresql-$v-pgpcre'
icu_ext: 'postgresql-$v-icu-ext'
pgqr: 'postgresql-$v-pgqr' # N/A for PG16
envvar: 'postgresql-$v-pg-envvar'
pg_protobuf: 'postgresql-$v-pg-protobuf' # N/A for PG16
url_encode: 'postgresql-$v-url-encode'
#--------------------------------#
# ADMIN: Tools & Utilities
#--------------------------------#
pg_repack: 'postgresql-$v-repack'
pg_squeeze: 'postgresql-$v-squeeze'
pg_dirtyread: 'postgresql-$v-dirtyread'
pgfincore: 'postgresql-$v-pgfincore'
pgdd: 'postgresql-$v-pgdd'
ddlx: 'postgresql-$v-ddlx'
pg_prioritize: 'postgresql-16-prioritize'
pg_checksums: 'postgresql-$v-pg-checksums'
pg_readonly: 'postgresql-$v-pg-readonly'
safeupdate: 'postgresql-$v-pg-safeupdate'
pg_permissions: 'postgresql-$v-pg-permissions'
pgautofailover: 'postgresql-16-auto-failover'
pg_catcheck: 'postgresql-$v-pg-catcheck'
preprepare: 'postgresql-$v-preprepare'
pgcozy: 'postgresql-$v-pgcozy'
pg_orphaned: 'postgresql-$v-pg-orphaned'
pg_crash: 'postgresql-$v-pg-crash'
pg_cheat_funcs: 'postgresql-$v-pg-cheat-funcs'
pg_savior: 'postgresql-$v-pg-savior'
table_log: 'postgresql-$v-tablelog'
pg_fio: 'postgresql-$v-pg-fio'
pgpool: 'postgresql-$v-pgpool2' # not used
pgagent: 'pgagent' # not used
#--------------------------------#
# STAT: Monitor & Observability
#--------------------------------#
pg_profile: 'postgresql-$v-pg-profile'
pg_show_plans: 'postgresql-$v-show-plans'
pg_stat_kcache: 'postgresql-$v-pg-stat-kcache'
pg_stat_monitor: 'postgresql-$v-pg-stat-monitor'
pg_qualstats: 'postgresql-$v-pg-qualstats'
pg_store_plans: 'postgresql-$v-pg-store-plan'
pg_track_settings: 'postgresql-$v-pg-track-settings'
pg_wait_sampling: 'postgresql-$v-pg-wait-sampling'
system_stats: 'postgresql-$v-system-stats'
pg_meta: 'postgresql-$v-pg-meta'
pgnodemx: 'postgresql-$v-pgnodemx'
pg_sqlog: 'postgresql-$v-pg-sqlog'
bgw_replstatus: 'postgresql-$v-bgw-replstatus'
pgmeminfo: 'postgresql-$v-pgmeminfo'
toastinfo: 'postgresql-$v-toastinfo'
pg_mon: 'postgresql-$v-pg-mon' # N/A for PG16
pg_statviz: 'postgresql-$v-statviz'
pgexporter_ext: '' # N/A for Deb Distro
pg_top: '' # N/A for Deb Distro
pagevis: 'postgresql-$v-pagevis'
powa: 'postgresql-$v-powa'
#--------------------------------#
# SEC: ACL, Audit, Crypto
#--------------------------------#
passwordcheck: 'postgresql-$v-passwordcheck-cracklib'
supautils: 'postgresql-$v-supautils'
pgsodium: 'postgresql-$v-pgsodium'
pg_vault: 'postgresql-$v-vault'
anonymizer: 'postgresql-$v-anonymizer'
pg_tde: 'postgresql-$v-pg-tde'
pgsmcrypto: 'postgresql-$v-pgsmcrypto'
pgaudit: 'postgresql-$v-pgaudit'
pgauditlogtofile: 'postgresql-$v-pgauditlogtofile'
pg_auth_mon: 'postgresql-$v-pg-auth-mon'
credcheck: 'postgresql-$v-credcheck'
pgcryptokey: 'postgresql-$v-pgcryptokey'
pg_jobmon: 'postgresql-$v-pg-jobmon'
logerrors: 'postgresql-$v-logerrors'
login_hook: 'postgresql-$v-login-hook'
set_user: 'postgresql-$v-set-user'
pg_snakeoil: 'postgresql-$v-snakeoil'
pgextwlist: 'postgresql-$v-pgextwlist'
pg_auditor: 'postgresql-$v-pg-auditor'
sslutils: 'postgresql-$v-sslutils' # N/A for PG16
noset: 'postgresql-$v-noset'
#--------------------------------#
# FDW: Foreign-Data-Wrapper
#--------------------------------#
wrappers: 'postgresql-$v-wrappers'
multicorn: '' # N/A for Deb Distro
jdbc_fdw: '' # N/A for Deb Distro
odbc_fdw: '' # N/A for Deb Distro
mysql_fdw: 'postgresql-$v-mysql-fdw'
oracle_fdw: 'postgresql-$v-oracle-fdw'
tds_fdw: 'postgresql-$v-tds-fdw'
db2_fdw: '' # N/A for Deb Distro
sqlite_fdw: 'postgresql-$v-sqlite-fdw'
pgbouncer_fdw: '' # N/A for Deb Distro
mongo_fdw: '' # N/A for Deb Distro
redis_fdw: 'postgresql-$v-redis-fdw'
pg_redis_pubsub: 'postgresql-$v-pg-redis-pubsub'
kafka_fdw: 'postgresql-$v-kafka-fdw'
hdfs_fdw: '' # N/A for Deb Distro
firebird_fdw: '' # N/A for Deb Distro
aws_s3: 'postgresql-$v-aws-s3'
log_fdw: 'postgresql-$v-log-fdw'
#--------------------------------#
# SIM: Oracle, MSSQL, etc...
#--------------------------------#
orafce: 'postgresql-$v-orafce'
pgtt: 'postgresql-$v-pgtt'
session_variable: 'postgresql-$v-session-variable'
pg_statement_rollback: 'postgresql-$v-pg-statement-rollback'
pg_dbms_metadata: '' # N/A for Deb Distro
pg_dbms_lock: '' # N/A for Deb Distro
pg_dbms_job: '' # N/A for Deb Distro
babelfishpg_common: 'babelfishpg-common' # WiltonDB with PG15, Ubuntu only
babelfishpg_tsql: 'babelfishpg-tsql' # WiltonDB with PG15, Ubuntu only
babelfishpg_tds: 'babelfishpg-tds' # WiltonDB with PG15, Ubuntu only
babelfishpg_money: 'babelfishpg-money' # WiltonDB with PG15, Ubuntu only
pgmemcache: 'postgresql-$v-pgmemcache'
#--------------------------------#
# ETL: CDC, Decoding, Replication
#--------------------------------#
pglogical: 'postgresql-$v-pglogical'
pglogical_ticker: 'postgresql-$v-pglogical-ticker'
pgl_ddl_deploy: 'postgresql-$v-pgl-ddl-deploy'
pg_failover_slots: 'postgresql-$v-pg-failover-slots'
wal2json: 'postgresql-$v-wal2json'
wal2mongo: 'postgresql-$v-wal2mongo'
decoderbufs: 'postgresql-$v-decoderbufs'
decoder_raw: 'postgresql-$v-decoder-raw'
mimeo: 'postgresql-$v-mimeo'
repmgr: 'postgresql-$v-repmgr' # not used
pgcopydb: 'pgcopydb' # binary
pgloader: 'pgloader' # binary
pg_fact_loader: 'postgresql-$v-pg-fact-loader'
pg_bulkload: 'postgresql-$v-pg-bulkload'
pg_comparator: '' # N/A for Deb Distro
pgimportdoc: '' # N/A for Deb Distro
pgexportdoc: '' # N/A for Deb Distro
...