Contents

• pg_procfs
• Installation
  • Compiling
  • PostgreSQL setup
• Usage
  • Example
  • ------+--------------------------------------------------------------------------------------------------------------------------------------

pg_procfs

PostgreSQL extension to display /proc FS data 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_procfs.git
cd pg_procfs
make
make install

This extension has been validated with PostgreSQL 14.

PostgreSQL setup

Extension must loaded at server level with shared_preload_libraries parameter.

Usage

Example

Add in postgresql.conf:

shared_preload_libraries = 'pg_procfs'

Run:
create extension pg_profcs;

To display some /proc FS data:
``` select * from pg_procfs('/proc/version'); line | message

------+--------------------------------------------------------------------------------------------------------------------------------------

0 | Linux version 4.18.0-372.19.1.el8_6.x86_64 (mockbuild@49c5e54ed716424c9ae8c1a3d1fef96f) (gcc version 8.5.0 20210514 (Red Hat 8.5.0-10

) (GCC)) #1 SMP Tue Aug 2 13:42:59 EDT 2022 (1 row) ```