On Wed, Sep 26, 2018 at 10:36:03PM +0200, Laurenz Albe wrote: > Bossart, Nathan wrote: > > Attached is a patch to add a pg_ls_tmpdir() function that lists the > > contents of a specified tablespace's pgsql_tmp directory. This is > > very similar to the existing pg_ls_logdir() and pg_ls_waldir() > > functions.
On Sun, Sep 30, 2018 at 10:59:20PM +0200, Christoph Moench-Tegeder wrote: > while setting up monitoring for a new PostgreSQL instance, I noticed that > there's no build-in way for a pg_monitor role to check the contents of > the archive_status directory. We got pg_ls_waldir() in 10, but that > only lists pg_wal - not it's (sic) subdirectory. > It may make sense to have a generic function like > pg_ls_dir(dirname text, tablespace oid) > instead. But maybe that's taking it too far... I see Cristoph has another pg_ls_* function, which suggests that Laurenz idea is good, and a generic pg_ls function is desirable. Justin