Install the osss command-line tools on Fedora and RHEL-family distributions straight
from dnf. The repository is osss-signed and serves prebuilt x86_64 packages;
each is a single static binary with no dependencies, so it installs cleanly anywhere.
The repository is signed with an Ed25519 key, which older rpm releases
cannot verify. The boundary below was measured by installing from this repository on each distribution,
not inferred from version numbers:
Header DSA signature: BAD (invalid OpenPGP signature).On EL8 or older, use the static binary tarball from the tool's release page — it has no dependencies and runs on any Linux.
sudo rpm --import https://rpm.osss.net/osss-rpm.asc
sudo tee /etc/yum.repos.d/osss.repo >/dev/null <<'REPO' [osss] name=osss tools baseurl=https://rpm.osss.net/ enabled=1 gpgcheck=1 repo_gpgcheck=1 gpgkey=https://rpm.osss.net/osss-rpm.asc REPO
gpgcheck verifies each package; repo_gpgcheck verifies the
repository metadata as well. Both are on deliberately — leave them on.
sudo dnf install postgres-sql-formatter postgres-schema-management \
postgres-schema-to-directory postgres-test worktree
Install only what you want — each package stands alone. Packages use the full project name (so they don't collide with unrelated packages); the command you run is the short name.
pgsfpgsmpgstdpgtwtLeft is the package you install (hyphenated, as both RPM and Debian spell it; the
project, FreeBSD port and Homebrew formula use underscores); right is the command it provides. A tool
appears here once it has cut a release carrying an .rpm — browse
/Packages/ for what is actually published right now.
sudo dnf upgrade picks up new releases as they ship — a new version lands in the
repository within moments of its release. Hold a package at its current version with
sudo dnf versionlock add <name>.
Packages and repository metadata are both signed by the dedicated OSSS RPM key
(rpm@osss.net), fingerprint:
6417 2B3E 9D59 AA7F D65B BC36 1C07 B661 8671 E5D7
The public key is at rpm.osss.net/osss-rpm.asc. Check
what your system trusts with rpm -qa gpg-pubkey --qf '%{SUMMARY}\n'. You can browse the
repository tree under /Packages/ and /repodata/.