This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Category: ADMIN

ADMIN: Utilities for Bloat Control, DirtyRead, BufferInspect, DDL Generate, ChecksumVerify, Permission, Priority, Catalog,…

1: prioritize
2: pg_repack
3: pg_squeeze
4: pg_dirtyread
5: pgfincore
6: pgdd
7: ddlx
8: prioritize
9: pg_checksums
10: pg_readonly
11: safeupdate
12: pg_permissions
13: pgautofailover
14: pg_catcheck
15: pre_prepare
16: pgcozy
17: pg_orphaned
18: pg_crash
19: pg_cheat_funcs
20: pg_savior
21: table_log
22: pg_fio
23: pgpool_adm
24: pgagent
25: vacuumlo
26: pg_prewarm
27: oid2name
28: lo
29: basic_archive
30: basebackup_to_shell
31: old_snapshot
32: adminpack
33: amcheck
34: pg_surgery

ADMIN category has 33 available extensions:

Extension (URL)	Alias	Repo	Version	Category	License	Description
pg_repack	`pg_repack`	PGDG	1.5.0	`ADMIN`	BSD 3	Reorganize tables in PostgreSQL databases with minimal locks
pg_squeeze	`pg_squeeze`	PGDG	1.7	`ADMIN`	BSD 2	A tool to remove unused space from a relation.
pg_dirtyread	`pg_dirtyread`	PIGSTY	2	`ADMIN`	BSD 3	Read dead but unvacuumed rows from table
pgfincore	`pgfincore`	PGDG	1.3.1	`ADMIN`	BSD 3	examine and manage the os buffer cache
pgdd	`pgdd`	PIGSTY	0.5.2	`ADMIN`	MIT	An in-database data dictionary providing database introspection via standard SQL query syntax. Developed using pgx (https://github.com/zombodb/pgx).
ddlx	`ddlx`	PGDG	0.27	`ADMIN`	PostgreSQL	DDL eXtractor functions
prioritize	`pg_prioritize`	PGDG	1.0	`ADMIN`	PostgreSQL	get and set the priority of PostgreSQL backends
pg_checksums	`pg_checksums`	PGDG	1.1	`ADMIN`	BSD 2	Activate/deactivate/verify checksums in offline Postgres clusters
pg_readonly	`pg_readonly`	PGDG	1.0.0	`ADMIN`	PostgreSQL	cluster database read only
safeupdate	`safeupdate`	PGDG	1.4	`ADMIN`	ISC	Require criteria for UPDATE and DELETE
pg_permissions	`pg_permissions`	PGDG	1.3	`ADMIN`	BSD 2	view object permissions and compare them with the desired state
pgautofailover	`pgautofailover`	PGDG	2.1	`ADMIN`	PostgreSQL	pg_auto_failover
pg_catcheck	`pg_catcheck`	PGDG	1.4.0	`ADMIN`	BSD 3	Diagnosing system catalog corruption
pre_prepare	`preprepare`	PIGSTY	0.4	`ADMIN`	PostgreSQL	Pre Prepare your Statement server side
pgcozy	`pgcozy`	PIGSTY	1.0	`ADMIN`	PostgreSQL	Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.
pg_orphaned	`pg_orphaned`	PIGSTY	1.0	`ADMIN`	PostgreSQL	Deal with orphaned files
pg_crash	`pg_crash`	PIGSTY	1.0	`ADMIN`	BSD-3	Send random signals to random processes
pg_cheat_funcs	`pg_cheat_funcs`	PIGSTY	1.0	`ADMIN`	PostgreSQL	Provides cheat (but useful) functions
pg_savior	`pg_savior`	PIGSTY	0.0.1	`ADMIN`	Apache-2.0	Postgres extension to save OOPS mistakes
table_log	`table_log`	PIGSTY	0.6.1	`ADMIN`	PostgreSQL	record table modification logs and PITR for table/row
pg_fio	`pg_fio`	PIGSTY	1.0	`ADMIN`	BSD-3	PostgreSQL File I/O Functions
pgpool_adm	`pgpool`	PGDG	1.5	`ADMIN`	PostgreSQL	Administrative functions for pgPool
pgpool_recovery	`pgpool`	PGDG	1.4	`ADMIN`	PostgreSQL	recovery functions for pgpool-II for V4.3
pgpool_regclass	`pgpool`	PGDG	1.0	`ADMIN`	PostgreSQL	replacement for regclass
pgagent	`pgagent`	PGDG	4.2	`ADMIN`	PostgreSQL	A PostgreSQL job scheduler
vacuumlo	`vacuumlo`	CONTRIB	16.3	`ADMIN`	PostgreSQL	utility program that will remove any orphaned large objects from a PostgreSQL database
pg_prewarm	`pg_prewarm`	CONTRIB	1.2	`ADMIN`	PostgreSQL	prewarm relation data
oid2name	`oid2name`	CONTRIB	16.3	`ADMIN`	PostgreSQL	utility program that helps administrators to examine the file structure used by PostgreSQL
lo	`lo`	CONTRIB	1.1	`ADMIN`	PostgreSQL	Large Object maintenance
basic_archive	`basic_archive`	CONTRIB	16.3	`ADMIN`	PostgreSQL	an example of an archive module
basebackup_to_shell	`basebackup_to_shell`	CONTRIB	16.3	`ADMIN`	PostgreSQL	adds a custom basebackup target called shell
old_snapshot	`old_snapshot`	CONTRIB	1.0	`ADMIN`	PostgreSQL	utilities in support of old_snapshot_threshold
adminpack	`adminpack`	CONTRIB	2.1	`ADMIN`	PostgreSQL	administrative functions for PostgreSQL
amcheck	`amcheck`	CONTRIB	1.3	`ADMIN`	PostgreSQL	functions for verifying relation integrity
pg_surgery	`pg_surgery`	CONTRIB	1.0	`ADMIN`	PostgreSQL	extension to perform surgery on a damaged relation

1 - prioritize

get and set the priority of PostgreSQL backends

Overview

PGDG 1st Party Extension: prioritize : get and set the priority of PostgreSQL backends

Information

ID: 4070
Name: prioritize
Alias: prioritize
Category: ADMIN
Website: https://github.com/schmiddy/pg_prioritize
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: prioritize_$v*
RPM Ver : 1.0.4-4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-16-prioritize
DEB Ver : 1.0
DEB Deps: Nil

Details

2 - pg_repack

Reorganize tables in PostgreSQL databases with minimal locks

Overview

PGDG 1st Party Extension: pg_repack : Reorganize tables in PostgreSQL databases with minimal locks

Information

ID: 5010
Name: pg_repack
Alias: pg_repack
Category: ADMIN
Website: https://github.com/reorg/pg_repack
License: BSD 3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.5.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_repack_$v*
RPM Ver : 1.5.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-repack
DEB Ver : 1.5.1
DEB Deps: Nil

Details

3 - pg_squeeze

A tool to remove unused space from a relation.

Overview

PGDG 1st Party Extension: pg_squeeze : A tool to remove unused space from a relation.

Information

ID: 5020
Name: pg_squeeze
Alias: pg_squeeze
Category: ADMIN
Website: https://github.com/cybertec-postgresql/pg_squeeze
License: BSD 2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.7
PG Vers: 17,16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: squeeze
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_squeeze_$v*
RPM Ver : 1.7
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-squeeze
DEB Ver : 1.7
DEB Deps: Nil

Details

4 - pg_dirtyread

Read dead but unvacuumed rows from table

Overview

PIGSTY 3rd Party Extension: pg_dirtyread : Read dead but unvacuumed rows from table

Information

ID: 5030
Name: pg_dirtyread
Alias: pg_dirtyread
Category: ADMIN
Website: https://github.com/df7cb/pg_dirtyread
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_dirtyread_$v*
RPM Ver : 2
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-dirtyread
DEB Ver : 2
DEB Deps: Nil

Details

5 - pgfincore

examine and manage the os buffer cache

Overview

PGDG 1st Party Extension: pgfincore : examine and manage the os buffer cache

Information

ID: 5040
Name: pgfincore
Alias: pgfincore
Category: ADMIN
Website: https://github.com/klando/pgfincore
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.3.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgfincore_$v*
RPM Ver : 1.3.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pgfincore
DEB Ver : 1.3.1
DEB Deps: Nil

Details

6 - pgdd

An in-database data dictionary providing database introspection via standard SQL query syntax. Developed using pgx (https://github.com/zombodb/pgx).

Overview

PIGSTY 3rd Party Extension: pgdd : An in-database data dictionary providing database introspection via standard SQL query syntax. Developed using pgx (https://github.com/zombodb/pgx).

Information

ID: 5050
Name: pgdd
Alias: pgdd
Category: ADMIN
Website: https://github.com/rustprooflabs/pgdd
License: MIT License
Language: Rust
Tags: pgrx
Comment:

Metadata

Version: 0.5.2
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: dd
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pgdd_$v
RPM Ver : 0.5.2
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgdd
DEB Ver : 0.5.2
DEB Deps: Nil

Details

7 - ddlx

DDL eXtractor functions

Overview

PGDG 3rd Party Extension: ddlx : DDL eXtractor functions

Information

ID: 5060
Name: ddlx
Alias: ddlx
Category: ADMIN
Website: https://github.com/lacanoid/pgddl
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment:

Metadata

Version: 0.27
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: ddlx_$v*
RPM Ver : 0.27
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-ddlx
DEB Ver : 0.28
DEB Deps: Nil

Details

8 - prioritize

get and set the priority of PostgreSQL backends

Overview

PGDG 1st Party Extension: pg_prioritize : get and set the priority of PostgreSQL backends

Information

ID: 5070
Name: prioritize
Alias: pg_prioritize
Category: ADMIN
Website: https://github.com/schmiddy/pg_prioritize
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_prioritize_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-16-prioritize
DEB Ver : 1.0
DEB Deps: Nil

Details

9 - pg_checksums

Activate/deactivate/verify checksums in offline Postgres clusters

Overview

PGDG 1st Party Extension: pg_checksums : Activate/deactivate/verify checksums in offline Postgres clusters

Information

ID: 5080
Name: pg_checksums
Alias: pg_checksums
Category: ADMIN
Website: https://github.com/credativ/pg_checksums
License: BSD 2 License
Language: C
Tags: bin
Comment: 无

Metadata

Version: 1.1
PG Vers: 16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_checksums_$v*
RPM Ver : 1.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-checksums
DEB Ver : 1.1
DEB Deps: Nil

Details

10 - pg_readonly

cluster database read only

Overview

PGDG 1st Party Extension: pg_readonly : cluster database read only

Information

ID: 5090
Name: pg_readonly
Alias: pg_readonly
Category: ADMIN
Website: https://github.com/pierreforstmann/pg_readonly
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.0.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_readonly_$v*
RPM Ver : 1.0.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-readonly
DEB Ver : 1.0.0
DEB Deps: Nil

Details

11 - safeupdate

Require criteria for UPDATE and DELETE

Overview

PGDG 1st Party Extension: safeupdate : Require criteria for UPDATE and DELETE

Information

ID: 5100
Name: safeupdate
Alias: safeupdate
Category: ADMIN
Website: https://github.com/eradman/pg-safeupdate
License: ISC License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: safeupdate_$v*
RPM Ver : 1.4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-safeupdate
DEB Ver : 1.4
DEB Deps: Nil

Details

12 - pg_permissions

view object permissions and compare them with the desired state

Overview

PGDG 3rd Party Extension: pg_permissions : view object permissions and compare them with the desired state

Information

ID: 5110
Name: pg_permissions
Alias: pg_permissions
Category: ADMIN
Website: https://github.com/cybertec-postgresql/pg_permissions
License: BSD 2 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_permissions_$v*
RPM Ver : 1.3
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-permissions
DEB Ver : 1.3
DEB Deps: Nil

Details

13 - pgautofailover

pg_auto_failover

Overview

PGDG 1st Party Extension: pgautofailover : pg_auto_failover

Information

ID: 5120
Name: pgautofailover
Alias: pgautofailover
Category: ADMIN
Website: https://github.com/hapostgres/pg_auto_failover
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 2.1
PG Vers: 16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: btree_gist

Packages

RPM Repo: PGDG
RPM Name: pg_auto_failover_$v*
RPM Ver : 2.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-16-auto-failover
DEB Ver : 2.1
DEB Deps: Nil

Details

14 - pg_catcheck

Diagnosing system catalog corruption

Overview

PGDG 1st Party Extension: pg_catcheck : Diagnosing system catalog corruption

Information

ID: 5130
Name: pg_catcheck
Alias: pg_catcheck
Category: ADMIN
Website: https://github.com/EnterpriseDB/pg_catcheck
License: BSD 3 License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 1.4.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pg_catcheck_$v*
RPM Ver : 1.4.0
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pg-catcheck
DEB Ver : 1.4.0
DEB Deps: Nil

Details

15 - pre_prepare

Pre Prepare your Statement server side

Overview

PIGSTY 3rd Party Extension: preprepare : Pre Prepare your Statement server side

Information

ID: 5140
Name: pre_prepare
Alias: preprepare
Category: ADMIN
Website: https://github.com/dimitri/preprepare
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 0.4
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: preprepare_$v*
RPM Ver : 0.4
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-preprepare
DEB Ver : 0.4
DEB Deps: Nil

Details

16 - pgcozy

Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.

Overview

PIGSTY 3rd Party Extension: pgcozy : Pre-warming shared buffers according to previous pg_buffercache snapshots for PostgreSQL.

Information

ID: 5170
Name: pgcozy
Alias: pgcozy
Category: ADMIN
Website: https://github.com/vventirozos/pgcozy
License: PostgreSQL License
Language: Pure SQL
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pgcozy_$v
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pgcozy
DEB Ver : 1.0
DEB Deps: Nil

Details

17 - pg_orphaned

Deal with orphaned files

Overview

PIGSTY 3rd Party Extension: pg_orphaned : Deal with orphaned files

Information

ID: 5180
Name: pg_orphaned
Alias: pg_orphaned
Category: ADMIN
Website: https://github.com/bdrouvot/pg_orphaned
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_orphaned_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-orphaned
DEB Ver : 1.0
DEB Deps: Nil

Details

18 - pg_crash

Send random signals to random processes

Overview

PIGSTY 3rd Party Extension: pg_crash : Send random signals to random processes

Information

ID: 5190
Name: pg_crash
Alias: pg_crash
Category: ADMIN
Website: https://github.com/cybertec-postgresql/pg_crash
License: BSD-3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_crash_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-crash
DEB Ver : 1.0
DEB Deps: Nil

Details

19 - pg_cheat_funcs

Provides cheat (but useful) functions

Overview

PIGSTY 3rd Party Extension: pg_cheat_funcs : Provides cheat (but useful) functions

Information

ID: 5200
Name: pg_cheat_funcs
Alias: pg_cheat_funcs
Category: ADMIN
Website: https://github.com/MasaoFujii/pg_cheat_funcs
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_cheat_funcs_$v*
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-cheat-funcs
DEB Ver : 1.0
DEB Deps: Nil

Details

20 - pg_savior

Postgres extension to save OOPS mistakes

Overview

PIGSTY 3rd Party Extension: pg_savior : Postgres extension to save OOPS mistakes

Information

ID: 5210
Name: pg_savior
Alias: pg_savior
Category: ADMIN
Website: https://github.com/viggy28/pg_savior
License: Apache-2.0 License
Language: C
Tags: N/A
Comment:

Metadata

Version: 0.0.1
PG Vers: 17,16,15,14,13
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Unknown
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_savior_$v*
RPM Ver : 0.0.1
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-savior
DEB Ver : 0.0.1
DEB Deps: Nil

Details

21 - table_log

record table modification logs and PITR for table/row

Overview

PIGSTY 3rd Party Extension: table_log : record table modification logs and PITR for table/row

Information

ID: 5220
Name: table_log
Alias: table_log
Category: ADMIN
Website: https://github.com/df7cb/table_log
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 0.6.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: table_log_$v
RPM Ver : 0.6.1
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-tablelog
DEB Ver : 0.6.1
DEB Deps: Nil

Details

22 - pg_fio

PostgreSQL File I/O Functions

Overview

PIGSTY 3rd Party Extension: pg_fio : PostgreSQL File I/O Functions

Information

ID: 5230
Name: pg_fio
Alias: pg_fio
Category: ADMIN
Website: https://github.com/csimsek/pgsql-fio
License: BSD-3 License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Not Relocatable
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PIGSTY
RPM Name: pg_fio_$v
RPM Ver : 1.0
RPM Deps: Nil
DEB Repo: PIGSTY
DEB Name: postgresql-$v-pg-fio
DEB Ver : 1.0
DEB Deps: Nil

Details

23 - pgpool_adm

Administrative functions for pgPool

Overview

PGDG 1st Party Extension: pgpool : Administrative functions for pgPool

Information

ID: 5300
Name: pgpool_adm
Alias: pgpool
Category: ADMIN
Website: https://pgpool.net/
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.5
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgpool-II-pg$v-extensions
RPM Ver : 1.5
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: postgresql-$v-pgpool2
DEB Ver : 1.4
DEB Deps: Nil

Details

24 - pgagent

A PostgreSQL job scheduler

Overview

PGDG 1st Party Extension: pgagent : A PostgreSQL job scheduler

Information

ID: 5310
Name: pgagent
Alias: pgagent
Category: ADMIN
Website: https://www.pgadmin.org/docs/pgadmin4/development/pgagent.html
License: PostgreSQL License
Language: Unknown
Tags: N/A
Comment: 无

Metadata

Version: 4.2
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

RPM Repo: PGDG
RPM Name: pgagent_$v*
RPM Ver : 4.2
RPM Deps: Nil
DEB Repo: PGDG
DEB Name: pgagent
DEB Ver : 4.2
DEB Deps: Nil

Details

25 - vacuumlo

utility program that will remove any orphaned large objects from a PostgreSQL database

Overview

CONTRIB Built-in Extension: vacuumlo : utility program that will remove any orphaned large objects from a PostgreSQL database

Information

ID: 5900
Name: vacuumlo
Alias: vacuumlo
Category: ADMIN
Website: https://www.postgresql.org/docs/current/vacuumlo.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 16.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

26 - pg_prewarm

prewarm relation data

Overview

CONTRIB Built-in Extension: pg_prewarm : prewarm relation data

Information

ID: 5910
Name: pg_prewarm
Alias: pg_prewarm
Category: ADMIN
Website: https://www.postgresql.org/docs/current/pgprewarm.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.2
PG Vers: 17,16,15,14,13,12
Need Load: Explicit Loading Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

27 - oid2name

utility program that helps administrators to examine the file structure used by PostgreSQL

Overview

CONTRIB Built-in Extension: oid2name : utility program that helps administrators to examine the file structure used by PostgreSQL

Information

ID: 5920
Name: oid2name
Alias: oid2name
Category: ADMIN
Website: https://www.postgresql.org/docs/current/oid2name.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 16.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

28 - lo

Large Object maintenance

Overview

CONTRIB Built-in Extension: lo : Large Object maintenance

Information

ID: 5930
Name: lo
Alias: lo
Category: ADMIN
Website: https://www.postgresql.org/docs/current/lo.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Trusted, Can be created by user with CREATE Privilege
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

29 - basic_archive

an example of an archive module

Overview

CONTRIB Built-in Extension: basic_archive : an example of an archive module

Information

ID: 5940
Name: basic_archive
Alias: basic_archive
Category: ADMIN
Website: https://www.postgresql.org/docs/current/basic-archive.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 16.3
PG Vers: 17,16,15
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

30 - basebackup_to_shell

adds a custom basebackup target called shell

Overview

CONTRIB Built-in Extension: basebackup_to_shell : adds a custom basebackup target called shell

Information

ID: 5950
Name: basebackup_to_shell
Alias: basebackup_to_shell
Category: ADMIN
Website: https://www.postgresql.org/docs/current/basebackup-to-shell.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 16.3
PG Vers: 17,16,15
Need Load: Lib Loading NOT Required
Need DDL: DO NOT CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

31 - old_snapshot

utilities in support of old_snapshot_threshold

Overview

CONTRIB Built-in Extension: old_snapshot : utilities in support of old_snapshot_threshold

Information

ID: 5960
Name: old_snapshot
Alias: old_snapshot
Category: ADMIN
Website: https://www.postgresql.org/docs/current/oldsnapshot.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

32 - adminpack

administrative functions for PostgreSQL

Overview

CONTRIB Built-in Extension: adminpack : administrative functions for PostgreSQL

Information

ID: 5970
Name: adminpack
Alias: adminpack
Category: ADMIN
Website: https://www.postgresql.org/docs/current/adminpack.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 2.1
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

33 - amcheck

functions for verifying relation integrity

Overview

CONTRIB Built-in Extension: amcheck : functions for verifying relation integrity

Information

ID: 5980
Name: amcheck
Alias: amcheck
Category: ADMIN
Website: https://www.postgresql.org/docs/current/amcheck.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.3
PG Vers: 17,16,15,14,13,12
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension

Details

34 - pg_surgery

extension to perform surgery on a damaged relation

Overview

CONTRIB Built-in Extension: pg_surgery : extension to perform surgery on a damaged relation

Information

ID: 5990
Name: pg_surgery
Alias: pg_surgery
Category: ADMIN
Website: https://www.postgresql.org/docs/current/pgsurgery.html
License: PostgreSQL License
Language: C
Tags: N/A
Comment: 无

Metadata

Version: 1.0
PG Vers: 17,16,15,14
Need Load: Lib Loading NOT Required
Need DDL: DO CREATE EXTENSION DDL
Relocatable: Unknown
Trusted: Untrusted, Require Superuser to Create
Schemas: N/A
Requires: N/A

Packages

PostgreSQL Built-in Contrib Extension