pg_ls_replslotdir()

A function providing information about files in replication slot directories
This entry relates to a PostgreSQL feature which is part of PostgreSQL 15, due to be released in late 2022.

pg_ls_replslotdir() is a system function providing information about files in a specific replication slot directory.

pg_ls_replslotdir() was added in PostgreSQL 15.

Usage

pg_ls_replslotdir ( slot_name text ) 
        → setof record ( name text, size bigint, modification timestamp with time zone )

pg_ls_replslotdir() returns a list of all normal files in the replication slot directory specified by the slot_name parameter.

Note that the rows are not returned in any particular order, so it may be useful to add an explicit sort criteria.

Change history

Examples

Basic usage example for pg_ls_replslotdir():

postgres=# SELECT * FROM pg_ls_replslotdir('node2');
 name  | size |      modification      
-------+------+------------------------
 state |  200 | 2021-11-24 06:13:08+01
(1 row)

Attempting to query a non-existent replication slot:

postgres=# SELECT * FROM pg_ls_replslotdir('node1');
ERROR:  replication slot "node1" does not exist

Categories

Data directory, File access and manipulation, Replication, Replication slots, System function

See also

pg_replication_slots