select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Extensions / Administration

pgelog

Extended logging via pseudo-autonomous transactions

pgext.cloud · Source code · License text · Control file · PGXN

Overview

Packagepgelog
Version1.0.2
PostgreSQL versions14 · 15 · 16 · 17 · 18
RepositoryPIGSTY
Extension typeSQL only
Requires CREATE EXTENSIONYes
Requires preloadNo
TrustedNo
RelocatableNo
Stars4
Latest commit2025-09-26
Latest release2025-09-25
Catalogue updated2026-08-30

Related extensions

Requires

dblinkconnect to other PostgreSQL databases from within a database
pg_variablesSession-scoped variables with scalar, array, and record types

See also

pg_stat_logTrack cumulative PostgreSQL log message statistics by backend, database, user, level, and SQLSTATE.
logerrorsFunction for collecting statistics about messages in logfile
pgauditprovides auditing functionality
table_logrecord table modification logs and PITR for table/row
pg_drop_eventslogs transaction ids of drop table, drop column, drop materialized view statements
pgmementoTransaction-based audit trail with schema versioning
pg_auth_monmonitor connection attempts per user
pg_sqlogProvide SQL interface to logs
log_fdwforeign-data wrapper for Postgres log file access
pgdisablelogerrorDisable selected SQLSTATE error codes from PostgreSQL server logging.