pkg.soopen package index

brew / rank 13122

Install pgtoolkit with Homebrew

Tools for PostgreSQL maintenance. Version 1.0.2 via Homebrew; verified from local package data.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install pgtoolkit

local Homebrew formula metadata

overview

Package summary

Tools for PostgreSQL maintenance

Commands and aliases

  • pgcompact

history

Project history and usage

PgToolkit is a Perl-based PostgreSQL maintenance toolkit whose principal utility, pgcompact, reduces table and index bloat with limited locking and incremental operation.

Project history

PgToolkit was created as a collection of PostgreSQL maintenance utilities, although its documented package currently centers on pgcompact.

The authors describe pgcompact as an automation of established community techniques for reducing PostgreSQL bloat without prolonged exclusive locking. The repository copyright record covers 2011–2014 and names Sergey Konoplev and Maxim Boguk.

Adoption history

PgToolkit was designed for lightweight deployment: its autonomous fatpack scripts require only Perl and can be copied directly to a server, while non-autonomous scripts can use DBD::Pg, DBD::PgPP, or psql.

The project credits testing and operational input from PostgreSQL-Consulting.com and several PostgreSQL community contributors.

How it is used

Administrators use `pgcompact` to analyze and compact selected tables, databases, or an entire cluster, optionally reindexing bloated indexes and excluding specified schemas or objects.

The tool supports incremental and parallel runs, load-aware throttling, and portable fatpack scripts. Installing pgstattuple is recommended for more accurate bloat estimates.

Why package nerds care

PgToolkit reflects the sysadmin tradition of portable database-maintenance scripts: pgcompact can be deployed without a large runtime stack and adapts to whichever PostgreSQL client interface is available.

pgcompact is notable for addressing table and index bloat incrementally, avoiding heavy locks and full-table rebuilding while adjusting its behavior to database load.

Timeline

  • 2011–2014: Copyright period recorded in the official project README.
  • Documented package state: PgToolkit contains pgcompact as its sole current tool, with additional tools planned.

Related projects

  • PostgreSQL's pgstattuple extension is recommended for more precise table and index bloat estimates.
  • PgCookbook is listed by the project as a related PostgreSQL documentation project.
  • DBD::Pg, DBD::PgPP, and psql are alternative database access backends used by pgcompact.

security posture

Risk level: blue

broad file, network, media, or database tool signal.

Risk classifier

blue risk · medium confidence · tool

Why

  • broad file, network, media, or database tool signal

Signals

  • text:sql

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 1 platform targets.

Recommended review

Before unattended agent use, check whether the tool reads plaintext credentials, writes remote state, publishes artifacts, or shells out to plugins.

executables

Installed executables

CommandKindExposureNote
pgcompactcliglobal executable

freshness

Version and freshness

These signals separate page generation age, package-manager activity, and upstream release comparison. Version lag is warned only when an evidence URL and comparable versions are present.

page generated2026-09-19
manager version1.0.2
manager updated
local dataok
upstreamcurrent
latest detectedv1.0.2

https://github.com/grayhemp/pgtoolkit

  • infoNo package-manager update timestamp was available.low confidence

install metadata

Package metadata

Package keybrew:pgtoolkit
Version1.0.2
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/pgtoolkit
Homepagehttps://github.com/grayhemp/pgtoolkit
Repositoryhttps://github.com/grayhemp/pgtoolkit
LicensePostgreSQL
Source archivehttps://github.com/grayhemp/pgtoolkit/archive/refs/tags/v1.0.2.tar.gz
Bottleavailable (on all)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepgtoolkit
Version Scheme0
Revision0
Bottle Stable Root URLhttps://ghcr.io/v2/homebrew/core
Deprecatedno
Disabledno
Keg Onlyno
URL Keys
  • stable

package graph

Links come from deterministic package relationships, av.db category and tag curation, ecosystem matches, and package hub membership.

Same workflow

  • pgsliceShares pkgdb curated category or tags: cli, data, database-maintenance, databases, postgresql.
  • pgwebShares pkgdb curated category or tags: cli, data, databases, postgresql.
  • pgxnclientShares pkgdb curated category or tags: cli, data, databases, postgresql.
  • pgstreamShares pkgdb curated category or tags: cli, data, databases, postgresql.
  • pgsyncShares pkgdb curated category or tags: cli, data, databases, postgresql.
  • ephemeralpgShares pkgdb curated category or tags: cli, data, databases, postgresql.

source trail

Generated from repository data

This page is generated by av-web from the private package SQLite artifact built by scripts/generate-pkg-sqlite.py.

Used sources

  • Geiger risk classifier
  • cross-ecosystem install command graph
  • curated package history
  • package relationship graph
  • package version freshness
  • package-page enrichment
  • pkg.so package database
  • pkgdb category and tag curation