logical decoding/replication: new functions pg_ls_logicaldir and pg_ls_replslotdir
Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-10-08T11:09:12Z
Lists: pgsql-hackers
Hi, At times, users want to know what are the files (snapshot and mapping files) that are available under pg_logical directory and also the spill files that are under pg_replslot directory and how much space they occupy. This will help to better know the storage usage pattern of these directories. Can we have two new functions pg_ls_logicaldir and pg_ls_replslotdir on the similar lines of pg_ls_logdir, pg_ls_logdir,pg_ls_tmpdir, pg_ls_archive_statusdir [1]? [1] - https://www.postgresql.org/docs/devel/functions-admin.html Regards, Bharath Rupireddy.
Commits
-
Add SQL functions to monitor the directory contents of replication slots
- 1922d7c6e1a7 15.0 landed