pig v1.0.0

Ruohang FengAuthor of pig and founder of Pigsty.

This release introduces three major new subcommand groups (pig pg, pig pt, pig pb) for managing PostgreSQL, Patroni, and pgBackRest, along with an orchestrated PITR command and enhanced extension availability display.

New Commands

• pig pg - PostgreSQL instance management

  • pg init/start/stop/restart/reload/status - Control and manage PostgreSQL instances
  • pg role/promote - Detect and switch instance role (primary/replica)
  • pg psql/ps/kill - Connection and session management
  • pg vacuum/analyze/freeze/repack - Database maintenance operations
  • pg log - Log viewing (list/tail/cat/less)

• pig pt - Patroni cluster management

  • pt list/config - View cluster status and configuration
  • pt restart/reload/reinit - Manage cluster members
  • pt switchover/failover - Cluster failover operations
  • pt pause/resume - Control automatic failover
  • pt start/stop/status/log - Patroni service management

• pig pb - pgBackRest backup management

  • pb info/ls - View backup information
  • pb backup/restore/expire - Backup operations
  • pb create/upgrade/delete - Stanza management
  • pb check/start/stop/log - Control operations

• pig pitr - Orchestrated Point-In-Time Recovery

  • Automatic Patroni/PostgreSQL coordination
  • Multiple recovery targets: time, LSN, XID, restore point
  • Dry-run mode and post-recovery guidance

New Features

• Add availability matrix to pig ext avail and pig ext ls

Improvements

• Unified command aliases across pg/pt/pb commands
• Standardized error message format
• Code refactoring and cleanup

Bug Fixes

• Fix missing UTIL extension category

Checksums