osss apt repository apt.osss.net

Install the osss command-line tools on Debian and Ubuntu straight from apt. The repository is osss-signed and serves prebuilt amd64 packages; each is a single static binary with no dependencies, so it installs cleanly on any recent Debian/Ubuntu.

Set it up

1. Trust the signing key

curl -fsSL https://apt.osss.net/osss-ppa.asc \
  | sudo tee /etc/apt/keyrings/osss-ppa.asc >/dev/null

2. Add the repository

echo 'deb [signed-by=/etc/apt/keyrings/osss-ppa.asc] https://apt.osss.net trixie main' \
  | sudo tee /etc/apt/sources.list.d/osss.list >/dev/null

Prefer the modern deb822 format? Drop this into /etc/apt/sources.list.d/osss.sources instead:

Types: deb
URIs: https://apt.osss.net
Suites: trixie
Components: main
Signed-By: /etc/apt/keyrings/osss-ppa.asc

3. Update and install

sudo apt update
sudo apt 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.

Packages

postgres-sql-formatter → pgsf: Format PostgreSQL SQL to match style-guide conventions.
postgres-schema-management → pgsm: Diff, plan, apply, and verify a PostgreSQL schema against a declarative repository.
postgres-schema-to-directory → pgstd: Extract a PostgreSQL schema into structured SQL files.
postgres-test → pgt: A Postgres testing framework: SQL-native assertions run by a Rust harness.
worktree → wt: Manage the per-branch git worktree checkouts of a multi-repo workspace.

Left is the package you install (Debian uses hyphens; the project/FreeBSD/Homebrew name uses underscores); right is the command it provides.

Upgrades

sudo apt update && sudo apt 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 apt-mark hold <name>.

Verifying

The repository's Release is signed by the dedicated OSSS PPA key (ppa@osss.net), fingerprint:

29BF 4713 B779 1C24 623E  CA3C 309B B80F 1B49 9876

The public key is at apt.osss.net/osss-ppa.asc; apt verifies every package list against it via the Signed-By line above. You can browse the repository tree under /dists/ and /pool/.