Contents

• pg_log
• Installation
  • Compiling
  • PostgreSQL setup
• Usage
  • Example

pg_log

PostgreSQL extension to display log from SQL

Installation

Compiling

This module can be built using the standard PGXS infrastructure. For this to work, the pg_config program must be available in your $PATH:

git clone https://github.com/pierreforstmann/pg_log.git
cd pg_log
make
make install

This extension has been validated with PostgreSQL 10, 11, 12, 13 and 14.

PostgreSQL setup

Extension must loaded at server level with shared_preload_libraries parameter.

Usage

pg_log has 3 specific GUC settings: 1. pg_log.fraction which is the log fraction that is displayed between 0 and 1. To display 10% of log contents starting from the end, use pg_log.fraction=0.1. 2. pg_log.naptime is the duration between each log refresh in the database. Default is 30 seconds. 3. pg_log.datname is the database name where pglog table and log view are created. This database must be created before installing the extension. Default database name is pg_log.

Example

Add in postgresql.conf:

shared_preload_libraries = 'pg_log'

Create database pg_log:

create database pg_log;

Run in database pg_log:
create extension pg_log;

To display 10% of log contents connect to database pg_log and query the log view:
\c pg_log
select * from log;