Vonng / pigsty

Battery-Included PostgreSQL Distro as a Free & Better RDS Alternative —— Pigsty
https://pigsty.io
GNU Affero General Public License v3.0
3.3k stars 256 forks source link

Use os-independt extension name in additional to os package in `pg_extensions` #434

Closed Vonng closed 1 month ago

Vonng commented 2 months ago

We want to use:

pg_extensions:
  - postgis timescaledb vector wal2json pg_repack

Rather than os-specific package names such as:

deb:

- postgresql-$v-repack postgresql-$v-wal2json
- postgresql-$v-postgis* timescaledb-2-postgresql-$v postgresql-$v-pgvector

rpm:

- pg_repack_$v* wal2json_$v* passwordcheck_cracklib_$v*                        # important extensions
- postgis34_$v* timescaledb-2-postgresql-$v* pgvector_$v*                      # featured extensions installed by default

To address this, we will need an extension map for that.

pg_extension_map:                 # internal data: translate pg_extension to os package
  rpm:
    postgis:     postgis34_$v*
    timescaledb: timescaledb-2-postgresql-$v*
    vector:      pgvector_$v*
    wal2json:    wal2json_$v*
    pg_repack:   pg_repack_$v*
  deb:
    postgis:     postgresql-$v-postgis*
    timescaledb: timescaledb-2-postgresql-$v
    vector:      postgresql-$v-pgvector
    wal2json:    postgresql-$v-wal2json
    pg_repack:   postgresql-16-repack
Vonng commented 1 month ago

resolved