Allowing non-SUPERUSER to use Server Status to see logfiles

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Allowing non-SUPERUSER to use Server Status to see logfiles
Date: 2015-08-06 19:37:37
Message-ID: CAMkU=1xnJYWSrUvFs74s4v_nqDmZ=mKb8_HML6pe7YP+h8rXfQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Is there a way to designate a specific non-SUPERUSER role to be able to see
the pg_log logfiles via pgAdmin?

I could write wrapper functions with SECURITY DEFINER with the correct
rights to observe the pg_log directory, but without the ability to get
pgAdmin to invoke the wrapper functions in place of the usual functions, it
won't do me much good.

Thanks,

Jeff

Browse pgadmin-support by date

  From Date Subject
Next Message Donald Kolafa 2015-08-08 01:49:44 HELP - you have disabled by Dell XPS 13 laptop
Previous Message Josh Berkus 2015-08-05 21:26:31 Re: greenplum question