pig-v1.0.0

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

pig-v0.9.0

• Refactor command pig sty install to pig sty deploy
• Add new parameters to command pig sty conf to align with the configure script
• Add llvmjit package to the pgsql-full alias

Changelog

• 6cd2aaa add -g|-p|-o option to pig sty conf sub command
• ab0adf3 use pig sty deploy instead of pig sty install
• 80c89c6 version 0.9.0

pig-v0.8.1

Changelog

• acfaba2 add llvmjit back to pgsql-full alias
• 59a005a bump version string to 0.8.1

pig-v0.8.0

Extension Update

• 440 extensions
• new extension: pg_ai_query : 0.1.1
• new extension: pg_textsearch : 0.1.0
• new extension: pg_clickhouse : 0.1.0
• bump pg_bsicuit from 1.0 to 2.0.1 (switch to new repo, rename to biscuit)
• bump pg_search from 0.20.3 to 0.20.5
• bump pg_duckdb to the official 1.1.1 release
• bump vchord_bm25 from 0.2.2 to 0.3.0
• bump pg_semver from 0.40.0 to 0.41.0
• bump pg_timeseries from 0.1.7 to 0.1.8
• bump pigsty version to 4.0.0

Repository Update

• remove pgdg yum sysupdate repo due to upstream change
• remove pgdg yum llvmjit packages due to upstream change
• fix el9.aarch64 patroni 3.0.4 duplicate package issue
• add priority to el repo definition and skip if unavailable for docker repo
• add epel 10 / pgdg 9/10 os minior version hot fixes
• fix debian/ubuntu pg18 extension: supautils, pg_summarize , pg_vectorize, pg_tiktoken, pg_tzf, pglite_fusion, pgsmcrypto, pgx_ulid, plprql

Checksums

e457832fb290e2f9975bf719966dc36e650bdcbf8505d319c9e0431f4c03bc9e  pig-0.8.0-1.aarch64.rpm
c97b1bfdd7541f0f464cab0ecc273e65535c8dd2603c38d5cf8dccbf7e95b523  pig-0.8.0-1.x86_64.rpm
d892f06d3d3b440671529f40e6cc7949686e0167e2a4758adc666b8a3d75254d  pig-v0.8.0.darwin-amd64.tar.gz
222413bafdf5a62dc682dac32ea1118cbc34ec3544e2a1b85076ec450b9cc7ae  pig-v0.8.0.darwin-arm64.tar.gz
d50aa9806bbab8fee5ad9228e104fc9e7ead48729228116b5bf889000791fedc  pig-v0.8.0.linux-amd64.tar.gz
d2f410f7b243a8323c8d479f462a0267ac72d217aa4a506c80b5a9927d12dff8  pig-v0.8.0.linux-arm64.tar.gz
4ccd330a995911d4f732e8c9d62aa0db479c21c9596f64c4bc129ec43f156abe  pig_0.8.0-1_amd64.deb
5cb9eccce659110f3ba58e502575564bd6befffd51992a43d84df5a17f8eb8a0  pig_0.8.0-1_arm64.deb

pig-v0.7.5

Changelog

• 4ecfa66 bump go to 1.25.5 and deps to the latest version
• 732e0c6 bump version string to 0.7.5
• 4f55ad9 routine extension update
• 05b3144 routine extension update
• a44dfed v0.7.5

pig-v0.7.4

Changelog

• 3cdb7c6 bump ivorsql to version 5 (pg18)
• bef0f6f routine update on extensions and repo.yml
• 8c73c1f update ivorysql & percona tde kernel alias
• 650fbc9 v0.7.4

pig-v0.7.3

Changelog

• faf6311 add nginx / timescaledb debian 13 repo
• e379f76 add python3-etcd to patroni alias in debian/ubuntu systems
• 3a70b87 bump pigsty version to 3.7.0
• d3afdfc feat: add pig repo reload command
• 8475530 fix pgdg sysupdate aarch64 repo
• c0c2306 fix: Handle EL10 aarch64 pgdg repo $releasever substitution
• 1b630ce rollback rhel-10.0-aarch64 repo adhoc logic
• 5dfabb1 routine extension update
• c687521 v0.7.3 release

pig-v0.7.2

Changelog

• 93dfb64 add llvm apt repo to the repo list
• 47dc323 add pgdg-el10fix repo to the default repo list
• 6d1a434 bump dev version string to 0.7.2
• 700ecdc bump go deps to the latest version to fix security issue
• 2bc0ede bump pgdg extension version to the latest version
• bb2dd17 reload pgext catalog when running pig build command
• c62faf6 routine extension list version update
• 38ca0b5 routine extension update
• 5893b3a v0.7.2

pig-v0.7.1

• The brand new website: https://pgext.cloud
• remove unnecessary sudo usage, now can be used inside docker
• allow using pg18, pg17 arg format in pig ext link command
• add environment var PIG_NO_SUDO to force not using sudo
• RPM Changelog: Add PG 18 support to almost all extensions
• DEB Changelog: Add PG 18 support to almost all extensions
• Infra Changelog: Routine update to the latest version

Changelog

• 11d3c5c add new timescaledb lib special case
• 325998d allow using all pig ext add args in pig install sub-cmd
• 2047678 allow using prefixed version like pg18 pg17 in pig ext link
• 1dd9d56 bump the default postgres major version to 18
• db5f9c9 bump tmp version to 0.7.1
• a40aa8f fix the missing log field
• 83c2266 more robust home dir detect logic
• 8631107 optimize sudo/root detect logic to work in docker
• 71890b0 remove docs, now move to pgsty/pgext
• aaebcf6 rename the pig ext upgrade command to pig ext reload
• 5e29614 routine update some deb extension metadata
• bf297c2 update omnigres extension series
• e2ecc3b use the pgext.cloud as extension info base
• 9cdb57a v0.7.1 release

pig-v0.7.0

Changelog

• c84df9d add Debian/MacOS stub to pig build pkg
• 91538b7 add build dep impl for el system
• c3c73e9 add el10 d13 build tool stub
• fc06668 add more special to build get
• 4a19681 add new subcommand pig build pkg
• 63d7302 add path builder to pig build ext
• 702151f add pig build all subcommand to run the full workflow
• c42a918 add pig build pkg QA_RPATHS special case for el10
• 6b5a576 adjust pig build command layout
• deb208e build spec will remove /tmp/deb /tmp/rpm before clone
• 9ce1618 bump default pgrx version to 0.16.1 and add pg18 init path
• 06321da bump extension.csv to the latest version
• 0579f45 bump version string to 0.7.0
• 9b92613 bump version string to 0.7.0
• 3093900 default repo module adjust to node,pgsql,infra
• aee28d9 feat add deb build spec support
• 3933d02 feat: check rust & pgrx version when building rust extension
• fae62d3 feat: optimize el artifect find logic with pkg glob
• b774197 feat: upgrade extension catalog to the new format
• 1fad964 fix deb package dependency fix logic
• 86c30e5 fix pig build dep pgver arg issue
• ed1a64a fix: remove unused outputChan to prevent deadlock in build command
• 66244c0 fsync before log file close
• 533d05d optimize build subcommand structure
• d754d22 optimize pig build ext error output
• b91c308 refactor build spec logic
• 356e384 refactor pig build command impl
• a58b6b1 refactor pig build ext sub command
• 43eeafc refactor pig build get to get src from ext.source
• 1b3c057 remove pig build init command and refactor ext builder
• 7be9e0d rename Catalog.ExtAliasMap to ExtPkgMap
• 0637aa9 routine update: update extension list
• 036055e split build pgrx command from build rust
• 3a2a6db update debian extension list
• 788dda5 use pig repo set when pig build repo