On Thu, Jun 2, 2016 at 4:29 PM, Stephen Frost <sfr...@snowman.net> wrote:
> * Sameer Kumar (sameer.ku...@ashnik.com) wrote: > > On Fri, 3 Jun 2016, 12:14 a.m. Alex Ignatov, <a.igna...@postgrespro.ru> > > wrote: > > > Can I list all WAL files in pg_xlog by using some sql query in > Postgres? > > > > Try > > > > Select pg_ls_dir('pg_xlog'); > > Note that this currently requires superuser privileges. > > Given the usefulness of this specific query and that it could be used > without risk of the user being able to gain superuser access through it, > I'd like to see a new function added which does not have the superuser > check, but is not allowed to be called by public initially either. > > Something along the lines of 'pg_xlog_file_list()', perhaps. There is a > check in check_postgres.pl which could take advantage of this also. > Should be a very straight-forward function to write, perhaps good as a > starter project for someone. > Isn't this the reason we created the newfangled pg_* roles in 9.6? David J.