pg_ls_waldir() & pg_ls_logdir()

From: Dave Page <dpage(at)pgadmin(dot)org>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_ls_waldir() & pg_ls_logdir()
Date: 2017-02-20 11:21:58
Views: Raw Message | Whole Thread | Download mbox
Lists: pgsql-hackers


Following various conversations on list and in person, including the
developer meeting in Brussels earlier this month, here is a patch that
implements pg_ls_logdir() and pg_ls_waldir() functions.

The ultimate aim of this (and followup work I'll be doing) is to
provide functionality to enable monitoring of PostgreSQL without
requiring a user with superuser permissions as many of us have users
for whom security policies prevent this or make it very difficult.

In order to achieve that, there are various pieces of functionality
such as pg_ls_dir() that need to have superuser checks removed to
allow permissions to be granted to a monitoring role. There were
objections in previous discussions to doing this with such generic
functions, hence this patch which adds two narrowly focussed functions
to allow tools to monitor the contents of the log and WAL directories.
Neither function has a hard-coded superuser check, but have ACLs that
prevent public execution by default.

Patch includes the code and doc updates.

Dave Page
Twitter: @pgsnake

EnterpriseDB UK:
The Enterprise PostgreSQL Company

Attachment Content-Type Size
lsdir.diff text/plain 6.8 KB


Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2017-02-20 11:48:22 pg_monitor role
Previous Message Andres Freund 2017-02-20 11:04:56 Re: Replication vs. float timestamps is a disaster