pkg.soopen package index

brew / Rang 13122

pgtoolkit mit Homebrew installieren

Prüfe Installationswege, Executables, Metadaten und Sicherheitshinweise für pgtoolkit in AI-Agent-Workflows.

InstallationsbefehlSicherheitshinweise

Installation

Weitere Installationsbefehle

macOS

Homebrewverifiziert · 100%
brew install pgtoolkit

local Homebrew formula metadata

Überblick

Paketzusammenfassung

Tools for PostgreSQL maintenance

Befehle und Aliase

  • pgcompact

Verlauf

Projektgeschichte und Nutzung

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

Projektgeschichte

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.

Adoptionsgeschichte

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.

Wie es verwendet wird

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.

Warum Paket-Nerds sich dafür interessieren

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.

Zeitleiste

  • 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.

Sicherheitslage

Risikostufe: blue

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

Risikoklassifikator

blue Risiko · mittel Konfidenz · tool

Warum

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

Signale

  • text:sql

Installationsverhalten

  • In den Formelmetadaten ist kein Homebrew-Post-install-Hook erfasst.
  • Homebrew-Bottle-Metadaten sind für 1 Plattformziele verfügbar.

Empfohlene Prüfung

Prüfe vor unbeaufsichtigter Agent-Nutzung, ob das Tool Klartext-Credentials liest, Remote-Zustand schreibt, Artefakte veröffentlicht oder Plugins ausführt.

Executables

Installierte Executables

BefehlArtSichtbarkeitHinweis
pgcompactcliglobales Executable

Aktualität

Version und Aktualität

Diese Signale trennen das Alter der Seitengenerierung, Aktivität des Paketmanagers und Upstream-Release-Vergleich. Versionsrückstand wird nur gemeldet, wenn eine Evidenz-URL und vergleichbare Versionen vorhanden sind.

Seite generiert2026-09-19
Manager-Version1.0.2
Manager aktualisiert
lokale DatenOK
Upstreamaktuell
neueste erkannte Versionv1.0.2

https://github.com/grayhemp/pgtoolkit

  • InfoNo package-manager update timestamp was available.niedrig Konfidenz

Installationsmetadaten

Paketmetadaten

Paketschlüsselbrew:pgtoolkit
Version1.0.2
PaketmanagerHomebrew
Paketmanager-Seitehttps://formulae.brew.sh/formula/pgtoolkit
Homepagehttps://github.com/grayhemp/pgtoolkit
Repositoryhttps://github.com/grayhemp/pgtoolkit
LizenzPostgreSQL
Quellarchivhttps://github.com/grayhemp/pgtoolkit/archive/refs/tags/v1.0.2.tar.gz
Bottleverfügbar (auf all)
Homebrew post-installnicht definiert
Dienstkeiner deklariert

Registry-Fakten

Details aus der Quelldatenbank

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

Paketgraph

Links stammen aus dem lokalen Paketbeziehungsgraph, Ergänzungen, Abhängigkeitskanten, Ecosystem-Matches und Paket-Hub-Mitgliedschaft.

Gleicher 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.

Quellspur

Aus Repository-Daten generiert

Diese Seite wird von av-web aus dem privaten Paket-SQLite-Artefakt bereitgestellt, das scripts/generate-pkg-sqlite.py erstellt.

Verwendete Quellen

  • 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