Skip to content

pig-v1.0.0

Choose a tag to compare

View all tags
@github-actions github-actions released this 26 Jan 15:53
· 93 commits to main since this release
v1.0.0
dc8f343

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 start/stop/restart/reload - Control PostgreSQL service
    • pg status/log/ps/conf/hba - View instance status and configuration
    • pg psql - Launch psql console
    • pg role - Detect instance role (primary/replica)
    • pg promote/checkpoint/vacuumdb - Maintenance operations

  • 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

306637079e942bcac9ccbc089cd09a80051898f8db1630269bb1acd3fbdaa872  pig-1.0.0-1.aarch64.rpm
d2b9440410f00efbca174d63b507c39d97fc55f402d8e9290ee054c1b1c6414c  pig-1.0.0-1.x86_64.rpm
c8a169e48a8168ee03db508ca2edc22b56ecf6997bae924e9023796ab7ae4e62  pig-v1.0.0.darwin-amd64.tar.gz
c0996037bfeffeae241b545e69d46c06e7fec2d7d456885229f3af9a7f9ea2f8  pig-v1.0.0.darwin-arm64.tar.gz
13837c6f2379edf965888bad9e373e69f70cb72e8428bca18c2c804e2bd879f6  pig-v1.0.0.linux-amd64.tar.gz
08207dfedd6f72745631596a3d3293de65cc12e1544956a643d1da2165d2c876  pig-v1.0.0.linux-arm64.tar.gz
a543882aa905713a0c50088d4e848951b6957a37a1594d7e9f3fe46453d5ce66  pig_1.0.0-1_amd64.deb
4cd6ec54261b09025c12e9c56bcc0cd3c11779ea0e8becdbd4f901cf2e7c8995  pig_1.0.0-1_arm64.deb

Release: https://github.com/pgsty/pig/releases/tag/v1.0.0

Changelog

  • b324a8f add --pkg option to print pkg name instead
  • 35f3aac add avail matrix into ext data
  • d8c22b6 add more command to pig postgres
  • 3ba2fe5 add new subcommand pgbackrest/postgres/patroni
  • dc8f343 add new subcommand pitr
  • 3f0149f add pig pg role sub command
  • 310e45c add pig pg sub command stub
  • 1d44c28 allow using mirror in pig build sub command
  • 3bd468d bump extension with pig 0.9.1
  • 256e87f bump go deps to the latest version (1.25.6)
  • f35bce0 bump version string to 1.0.0
  • dbca98e enhance pg and pt commands with security and usability improvements
  • e8b4c01 feat: add availability matrix to pig ext avail
  • e8a26c5 feat: enhance pig ext ls status with avail matrix
  • 146d6ae fix pig ext scan duplicate extension
  • fb74fef fix pig pg ps SQL syntax and add sudo fallback for log commands
  • 7abad69 fix the default patroni file path
  • 3cd1d94 fix the missing UTIL extension categroy
  • 72141d3 optimize pgbackrest command
  • 6343d83 optimize pig ext info sub command output
  • f5cdcaf refactor pig patroni command with subcommands
  • 77287bc refactor subcommand and internal utils
  • a073958 routine extension update
  • a86e71a routine update extension list
Assets 11
Loading