pkg.soopen package index

brew / rank 7340

Install pgslice with Homebrew

Postgres partitioning as easy as pie. Version 0.7.2 via Homebrew; verified 2026-09-13.

Install commandSecurity notes

install

Additional install commands

macOS

Homebrewverified · 100%
brew install pgslice

local Homebrew formula metadata

overview

Package summary

Postgres partitioning as easy as pie

Commands and aliases

  • pgslice

history

Project history and usage

pgslice is a PostgreSQL partition-management CLI designed to convert new or populated tables to range partitioning with minimal application changes and downtime.

Project history

Andrew Kane's pgslice first shipped in April 2016 as a Ruby command-line tool for partitioning PostgreSQL tables with minimal downtime.

The project added PostgreSQL declarative partitioning and foreign-key support in 2017, then continued tracking PostgreSQL and Ruby compatibility, including generated columns and newer PostgreSQL releases.

Adoption history

The official project describes pgslice as battle-tested at Instacart.

Distribution expanded beyond RubyGems to include Homebrew and Docker, making the command available through several packaging cultures.

How it is used

Operators set the `PGSLICE_URL` environment variable, prepare an intermediate partitioned table, create partitions, fill it in batches, analyze it, swap it with the original table, and then capture any remaining rows.

The CLI prints executed SQL and supports `--dry-run`; rolling partition creation and archival can keep database size under control.

Why package nerds care

pgslice packages a careful, multi-stage PostgreSQL partition migration into a repeatable CLI while still printing the SQL it executes and offering dry-run and lock-safety controls.

It is useful to database operators who want declarative partitioning or rolling archival without installing a PostgreSQL server extension.

Timeline

  • 2016-04-24: Version 0.1.0, the first release.
  • 2017-10-07: Version 0.4.0 added declarative partitioning and foreign-key support.
  • 2023-04-22: Version 0.6.0 added generated-column support and updated runtime requirements.
  • 2026-01-05: Version 0.7.2 added Ruby 4.0 support.

Related projects

  • pgsync is recommended by the project for transferring data between databases.
  • pg_dump and psql are used in the documented retirement and backup workflow.

security posture

Risk level: green

narrow executable package without higher-risk signals.

Risk classifier

green risk · low confidence · appliance

Why

  • narrow executable package without higher-risk signals

Signals

  • metadata:no-higher-risk-signals

Install behavior

  • No Homebrew post-install hook is recorded in formula metadata.
  • Homebrew bottle metadata is available for 6 platform targets.
  • Installs with 2 runtime dependencies.

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
pgslicecliglobal 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 version0.7.2
manager updated2026-09-13
local dataok
upstreamcurrent
latest detectedv0.7.2

https://github.com/ankane/pgslice

  • okNo freshness warnings were generated.

install metadata

Package metadata

Package keybrew:pgslice
Version0.7.2
Package managerHomebrew
Package manager pagehttps://formulae.brew.sh/formula/pgslice
Homepagehttps://github.com/ankane/pgslice
Repositoryhttps://github.com/ankane/pgslice
LicenseMIT
Source archivehttps://github.com/ankane/pgslice/archive/refs/tags/v0.7.2.tar.gz
Last updated2026-09-13T11:36:57Z
Pulseupdated
Dependencieslibpq, ruby
Bottleavailable (on arm64_linux, arm64_sequoia, arm64_sonoma, arm64_tahoe, sonoma, x86_64_linux)
Homebrew post-installnot defined
Servicenone declared

registry facts

Source database details

Source DatabaseHomebrew formula API
Taphomebrew/core
Full Namepgslice
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.

Related tools

  • rubyRuntime dependency declared by Homebrew.
  • libpqRuntime dependency declared by Homebrew.

Same workflow

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