pg_savior

pg_savior

Postgres extension to save OOPS mistakes

Overview

IDExtensionPackageVersionCategoryLicenseLanguage
5810
pg_savior
pg_savior
0.0.1
ADMIN
Apache-2.0
C
AttributeHas BinaryHas LibraryNeed LoadHas DDLRelocatableTrusted
--s-d-r
No
Yes
No
Yes
yes
no
Relationships
See Also
pg_upless
safeupdate
pg_drop_events
pg_cheat_funcs
table_log
pg_snakeoil
pg_auditor
temporal_tables

-tuplestore_donestoring , breaks on pg18 @ el

Packages

TypeRepoVersionPG Major AvailabilityPackage PatternDependencies
EL
PIGSTY
0.0.1
18
17
16
15
14
13
pg_savior_$v*-
Debian
PIGSTY
0.0.1
18
17
16
15
14
13
postgresql-$v-pg-savior-
Linux / PGPG18PG17PG16PG15PG14PG13
el8.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el8.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el9.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el9.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el10.x86_64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
el10.aarch64
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d12.x86_64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d12.aarch64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
d13.x86_64
MISS
MISS
MISS
MISS
MISS
MISS
d13.aarch64
MISS
MISS
MISS
MISS
MISS
MISS
u22.x86_64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u22.aarch64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u24.x86_64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
u24.aarch64
MISS
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PIGSTY 0.0.1
PackageVersionOSORGSIZEFile URL
pg_savior_180.0.1el8.x86_64pigsty13.5 KiBpg_savior_18-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_180.0.1el8.aarch64pigsty13.7 KiBpg_savior_18-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_180.0.1el9.x86_64pigsty13.4 KiBpg_savior_18-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_180.0.1el9.aarch64pigsty13.5 KiBpg_savior_18-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_180.0.1el10.x86_64pigsty13.4 KiBpg_savior_18-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_180.0.1el10.aarch64pigsty13.6 KiBpg_savior_18-0.0.1-2PIGSTY.el10.aarch64.rpm
PackageVersionOSORGSIZEFile URL
pg_savior_170.0.1el8.x86_64pigsty13.5 KiBpg_savior_17-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_170.0.1el8.aarch64pigsty13.7 KiBpg_savior_17-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_170.0.1el9.x86_64pigsty13.5 KiBpg_savior_17-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_170.0.1el9.aarch64pigsty13.5 KiBpg_savior_17-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_170.0.1el10.x86_64pigsty13.4 KiBpg_savior_17-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_170.0.1el10.aarch64pigsty13.7 KiBpg_savior_17-0.0.1-2PIGSTY.el10.aarch64.rpm
postgresql-17-pg-savior0.0.1d12.x86_64pigsty19.5 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-17-pg-savior0.0.1d12.aarch64pigsty19.4 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-17-pg-savior0.0.1u22.x86_64pigsty20.3 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-17-pg-savior0.0.1u22.aarch64pigsty20.0 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-17-pg-savior0.0.1u24.x86_64pigsty16.8 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-17-pg-savior0.0.1u24.aarch64pigsty16.3 KiBpostgresql-17-pg-savior_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_savior_160.0.1el8.x86_64pigsty13.5 KiBpg_savior_16-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_160.0.1el8.aarch64pigsty13.7 KiBpg_savior_16-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_160.0.1el9.x86_64pigsty13.5 KiBpg_savior_16-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_160.0.1el9.aarch64pigsty13.5 KiBpg_savior_16-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_160.0.1el10.x86_64pigsty13.4 KiBpg_savior_16-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_160.0.1el10.aarch64pigsty13.7 KiBpg_savior_16-0.0.1-2PIGSTY.el10.aarch64.rpm
postgresql-16-pg-savior0.0.1d12.x86_64pigsty19.0 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-16-pg-savior0.0.1d12.aarch64pigsty18.9 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-16-pg-savior0.0.1u22.x86_64pigsty19.8 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-16-pg-savior0.0.1u22.aarch64pigsty19.5 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-16-pg-savior0.0.1u24.x86_64pigsty16.8 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-16-pg-savior0.0.1u24.aarch64pigsty16.3 KiBpostgresql-16-pg-savior_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_savior_150.0.1el8.x86_64pigsty13.5 KiBpg_savior_15-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_150.0.1el8.aarch64pigsty13.7 KiBpg_savior_15-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_150.0.1el9.x86_64pigsty13.5 KiBpg_savior_15-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_150.0.1el9.aarch64pigsty13.6 KiBpg_savior_15-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_150.0.1el10.x86_64pigsty13.5 KiBpg_savior_15-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_150.0.1el10.aarch64pigsty13.7 KiBpg_savior_15-0.0.1-2PIGSTY.el10.aarch64.rpm
postgresql-15-pg-savior0.0.1d12.x86_64pigsty19.1 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-15-pg-savior0.0.1d12.aarch64pigsty18.9 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-15-pg-savior0.0.1u22.x86_64pigsty19.8 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-15-pg-savior0.0.1u22.aarch64pigsty19.5 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-15-pg-savior0.0.1u24.x86_64pigsty16.8 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-15-pg-savior0.0.1u24.aarch64pigsty16.4 KiBpostgresql-15-pg-savior_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_savior_140.0.1el8.x86_64pigsty13.5 KiBpg_savior_14-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_140.0.1el8.aarch64pigsty13.7 KiBpg_savior_14-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_140.0.1el9.x86_64pigsty13.5 KiBpg_savior_14-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_140.0.1el9.aarch64pigsty13.5 KiBpg_savior_14-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_140.0.1el10.x86_64pigsty13.5 KiBpg_savior_14-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_140.0.1el10.aarch64pigsty13.7 KiBpg_savior_14-0.0.1-2PIGSTY.el10.aarch64.rpm
postgresql-14-pg-savior0.0.1d12.x86_64pigsty17.9 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-14-pg-savior0.0.1d12.aarch64pigsty17.7 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-14-pg-savior0.0.1u22.x86_64pigsty18.6 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-14-pg-savior0.0.1u22.aarch64pigsty18.3 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-14-pg-savior0.0.1u24.x86_64pigsty16.8 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-14-pg-savior0.0.1u24.aarch64pigsty16.3 KiBpostgresql-14-pg-savior_0.0.1-1PIGSTY~noble_arm64.deb
PackageVersionOSORGSIZEFile URL
pg_savior_130.0.1el8.x86_64pigsty13.4 KiBpg_savior_13-0.0.1-2PIGSTY.el8.x86_64.rpm
pg_savior_130.0.1el8.aarch64pigsty13.7 KiBpg_savior_13-0.0.1-2PIGSTY.el8.aarch64.rpm
pg_savior_130.0.1el9.x86_64pigsty13.5 KiBpg_savior_13-0.0.1-2PIGSTY.el9.x86_64.rpm
pg_savior_130.0.1el9.aarch64pigsty13.5 KiBpg_savior_13-0.0.1-2PIGSTY.el9.aarch64.rpm
pg_savior_130.0.1el10.x86_64pigsty13.5 KiBpg_savior_13-0.0.1-2PIGSTY.el10.x86_64.rpm
pg_savior_130.0.1el10.aarch64pigsty13.6 KiBpg_savior_13-0.0.1-2PIGSTY.el10.aarch64.rpm
postgresql-13-pg-savior0.0.1d12.x86_64pigsty17.6 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~bookworm_amd64.deb
postgresql-13-pg-savior0.0.1d12.aarch64pigsty17.4 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~bookworm_arm64.deb
postgresql-13-pg-savior0.0.1u22.x86_64pigsty18.5 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~jammy_amd64.deb
postgresql-13-pg-savior0.0.1u22.aarch64pigsty18.2 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~jammy_arm64.deb
postgresql-13-pg-savior0.0.1u24.x86_64pigsty16.6 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~noble_amd64.deb
postgresql-13-pg-savior0.0.1u24.aarch64pigsty16.1 KiBpostgresql-13-pg-savior_0.0.1-1PIGSTY~noble_arm64.deb

Source

pig build get pg_savior; # get pg_savior source code
pig build dep pg_savior; # install build dependencies
pig build pkg pg_savior; # build extension rpm or deb
pig build ext pg_savior; # build extension rpms

Install

To add the required PGDG / PIGSTY upstream repository, use:

pig repo add pgsql -u   # add PGDG + Pigsty repo and update cache (leave existing repos)

Install this extension with:

pig ext install pg_savior; # install by extension name, for the current active PG version
pig ext install pg_savior; # install via package alias, for the active PG version
pig ext install pg_savior -v 18;   # install for PG 18
pig ext install pg_savior -v 17;   # install for PG 17
pig ext install pg_savior -v 16;   # install for PG 16
pig ext install pg_savior -v 15;   # install for PG 15
pig ext install pg_savior -v 14;   # install for PG 14
pig ext install pg_savior -v 13;   # install for PG 13

Create this extension with:

CREATE EXTENSION pg_savior;
Last updated on