https://gitlab.com/sjstoelting/pgsql-tweaks/
pgsql_tweaks includes several functions and views to help daily PostgreSQL work.
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example pgsql_tweaks for PostgreSQL 17 is named as pgsql_tweaks_17. Similarly pgsql_tweaks for PostgreSQL 15 is named as pgsql_tweaks_15.
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install pgsql_tweaks_17 (or change the version as described above) |
Connect to the database that you want to create the extension as superuser and run:
CREATE EXTENSION pgsql_tweaks;
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14 | Fedora Linux | x86_64 | Available |