Headless
PostgreSQL extensions that do not require CREATE EXTENSION
The following 26 extensions can be used without running CREATE EXTENSION.
These extensions typically exist as shared libraries (hooks) or standalone tools that take effect through configuration parameters.
| Extension | Package | Version | Attr | Description |
|---|---|---|---|---|
pg_task | pg_task | 1.0.0 | --sL--- | execute any sql command at any specific time at background |
plan_filter | pg_plan_filter | 0.0.1 | --sL--- | filter statements by their execution plans. |
pg_checksums | pg_checksums | 1.3 | --s---r | Activate/deactivate/verify checksums in offline Postgres clusters |
pg_crash | pg_crash | 1.0 | --sL--- | Send random signals to random processes |
safeupdate | safeupdate | 1.5 | --sL--- | Require criteria for UPDATE and DELETE |
basic_archive | basic_archive | - | c-s---- | an example of an archive module |
basebackup_to_shell | basebackup_to_shell | - | c-s---- | adds a custom basebackup target called shell |
bgw_replstatus | bgw_replstatus | 1.0.8 | --sL--- | Small PostgreSQL background worker to report whether a node is a replication master or standby |
pg_relusage | pg_relusage | 0.0.1 | --sL--- | Log all the queries that reference a particular column |
pg_overexplain | pg_overexplain | 1.0 | c-sL--- | Allow EXPLAIN to dump even more details |
auto_explain | auto_explain | - | c-sL--- | Provides a means for logging execution plans of slow statements automatically |
passwordcheck_cracklib | passwordcheck_cracklib | 3.1.0 | --sL--- | Strengthen PostgreSQL user password checks with cracklib |
supautils | supautils | 3.1.0 | --sL--- | Extension that secures a cluster on a cloud environment |
pg_snakeoil | pg_snakeoil | 1.4 | --sL--r | The PostgreSQL Antivirus |
pgextwlist | pgextwlist | 1.19 | --sL--- | PostgreSQL Extension Whitelisting |
sepgsql | sepgsql | - | c-sL--- | label-based mandatory access control (MAC) based on SELinux security policy. |
auth_delay | auth_delay | - | c-sL--- | pause briefly before reporting authentication failure |
passwordcheck | passwordcheck | - | c-sL--- | checks user passwords and reject weak password |
pg_statement_rollback | pg_statement_rollback | 1.5 | --sL--- | Server side rollback at statement level for PostgreSQL like Oracle or DB2 |
pg_failover_slots | pg_failover_slots | 1.2.0 | --sL--r | PG Failover Slots extension |
wal2json | wal2json | 2.6 | --s---- | Changing data capture in JSON format |
wal2mongo | wal2mongo | 1.0.7 | --s---- | PostgreSQL logical decoding output plugin for MongoDB |
decoderbufs | decoderbufs | 3.4.1 | --s---- | Logical decoding plugin that delivers WAL stream changes using a Protocol Buffer format |
decoder_raw | decoder_raw | 1.0 | --s---- | Output plugin for logical replication in Raw SQL format |
test_decoding | test_decoding | - | c-s---- | SQL-based test/example module for WAL logical decoding |
pgoutput | pgoutput | - | c-s---- | Logical Replication output plugin |
Feedback
Was this page helpful?
Thanks for the feedback! Please let us know how we can improve.
Sorry to hear that. Please let us know how we can improve.