databases/pgterm 0.4.0_1 FreeBSD

Terminal UI that monitors multiple PostgreSQL databases

System: FreeBSD
Repository: FreeBSD ports
Maintainer: [email protected]
Port added: 2026-08-29
Last update: 2026-10-14
Commit: 9c878207a1
License: APACHE20
Categories: databases
Package size: 1313.6 KiB, 2927.7 KiB installed

Description

pgterm is "htop for all your Postgres databases": an interactive terminal UI that monitors every PostgreSQL database you care about in one place. Each tab is one database. pgterm checks them all in the background and flags the tab that needs attention, without stealing focus from the one you are looking at.

Features:

Health overview per database: connections, cache, locks, queries, indexes, vacuum and replication, with an overall score
Inspect, Queries, Indexes, Tables and Why views for each database
Command bar with a closed set of verbs, including natural-language questions handed to pgbot's optional AI layer
Configuration stores environment variable names only; connection strings never touch disk, logs or the screen
Strictly read-only: every diagnostic runs through pgbot, and there is no SQL console or shell

pgterm drives pgbot (databases/pgbot) as a child process and renders its JSON output.

Install

Binary package:

pkg install pgterm

From the ports tree:

cd /usr/ports/databases/pgterm/ && make install clean

To depend on this port in another port's Makefile:

RUN_DEPENDS=	pgterm>0:databases/pgterm

Packages

The version each package repository carries. “-” means the repository builds no package of it, “n/a” that there is no such repository.

Repository

aarch64

amd64

armv6

armv7

i386

FreeBSD:14:latest

0.4.0

0.4.0_1

FreeBSD:14:quarterly

0.3.1

n/a

0.3.1

FreeBSD:15:latest

0.4.0_1

n/a

FreeBSD:15:quarterly

0.3.1

n/a

FreeBSD:16:latest

0.3.1

0.4.0_1

n/a

FreeBSD:16:quarterly

n/a

Dependencies

As this port's Makefile names them.

Runtime 1

pgbot : databases/pgbot

The full lists below include those, and their dependencies in turn.

Build dependencies 11

Run dependencies 1

databases/pgbot

No port depends on this one.

Configuration

No options to configure.

USES: cargo
Service scripts: none

Files

distinfo 278

File

Size

SHA256

rust/crates/aho-corasick-1.1.5.crate

184315

c982642fa9e8606056828ee9a8505737230110bb1099153c79efe865c59d12ba

rust/crates/allocator-api2-0.2.21.crate

63622

683d7910e743518b0e34f1186f92494becacb047c7b6bf616c96772180fef923

rust/crates/anyhow-1.0.104.crate

48819

330a5ed07fa54e4702c9d6c4174f74427fc0ef6e214bbd677ae50a5099946470

rust/crates/approx-0.5.1.crate

15100

cab112f0a86d568ea0e627cc1d6be74a1e9cd55214684db5561995f6dad897c6

rust/crates/async-trait-0.1.92.crate

32039

82f6aeea286b8eb4dd3431a1be1b59d290ace00f5bfd8e2a159bc2a05e2c1667

rust/crates/atomic-0.6.1.crate

15243

a89cbf775b137e9b968e67227ef7f775587cde3fd31b0d8599dbd0f598a48340

rust/crates/autocfg-1.5.1.crate

18911

f2032f911046de80f0a198e0901378627c33f59ea0ac00e363d481118bd70a53

rust/crates/base64-0.22.1.crate

81597

72b3254f16251a8381aa12e40e3c4d2f0199f8c6508fbecb9d91f575e0fbb8c6

rust/crates/base64ct-1.8.3.crate

32227

2af50177e190e07a26ab74f8b1efbfe2ef87da2116221318cb1c2e82baf7de06

rust/crates/bit-set-0.5.3.crate

14470

0700ddab506f33b20a03b13996eccd309a48e5ff77d0d95926aa0210fb4e95f1

rust/crates/bit-vec-0.6.3.crate

19927

349f9b6a179ed607305526ca489b34ad0a41aed5f7980fa90eb03160b69598fb

rust/crates/bitflags-1.3.2.crate

23021

bef38d45163c2f1dde094a7dfd33ccf595c92905c8f8f4fdc18d06fb1037718a

rust/crates/bitflags-2.13.1.crate

51395

b588b76d00fde79687d7646a9b5bdf3cc0f655e0bbd080335a95d7e96f3587da

rust/crates/block-buffer-0.10.4.crate

10538

3078c7629b62d3f0439517fa394996acacc5cbc91c5a20d8c658e77abd503a71

rust/crates/block-buffer-0.12.1.crate

15902

d2f6c7dbe95a6ed67ad9f18e57daf93a2f034c524b99fd2b76d18fdfeb6660aa

rust/crates/bumpalo-3.20.3.crate

98671

72f5acc6cb2ba439de613abc23857ec3d78374d8ed5ac84e9d11336e87da8649

rust/crates/by_address-1.2.1.crate

8437

64fa3c856b712db6612c019f14756e64e4bcea13337a6b33b696333a9eaa2d06

rust/crates/bytemuck-1.25.2.crate

54075

95832e849adfb21180ccb6826a99da14e5d266ae5c2e668e1602cf234f153797

rust/crates/byteorder-1.5.0.crate

23288

1fd0f2584146f6f2ef48085050886acf353beff7305ebd1ae69500e27c67f64b

rust/crates/bytes-1.12.1.crate

75667

fc652a48c352aef3ea3aed32080501cf3ef6ed5da78602a020c991775b0aff04

Commit history 6

Date Commit Credits Log message

2026-10-14

9c878207a1

Mikael Urankar

lang/rust: Bump revisions after 1.99.0

PR: 299016

2026-10-04 e5e4c85649 Jimmy Olgeni databases/pgterm: Update to 0.4.0

2026-09-11 c7bb885026 Jimmy Olgeni databases/pgterm: Update to 0.3.1

2026-09-08

7316461925

Mikael Urankar

lang/rust: Bump revisions after 1.98.1

PR: 298139

2026-09-07

1155ae4c4d

Jimmy Olgeni

databases/pgterm: Update to 0.1.4

Upstream 0.1.4 declares the fake-pgbot test fixture as a [[bin]] target, which cargo then installs alongside pgterm. Restrict the install to the pgterm binary, matching upstream's own release packaging.

The latest 5 of 6 in the history this site was built from.