Re: debugger from superuser only.... why? - Mailing list pgsql-general

From Alexander Petrossian (PAF)
Subject Re: debugger from superuser only.... why?
Date
Msg-id CA+VOcq820hDvE8063xdJ8hiozbzj8B+=S1EoXrWqqnKR0y=GdQ@mail.gmail.com
Whole thread Raw
In response to Re: debugger from superuser only.... why?  (Luca Ferrari <fluca1978@gmail.com>)
List pgsql-general

> SELECT * FROM pldbg_set_global_breakpoint(1, 65695, -1, NULL);
> ERROR: must be a superuser to create a breakpoint
> I am wondering why is this, why not allow debugging for non-privileged users?

Again, I'm suspecting that this debugger works by performing a
sandboxing and attaching your session back. In order to communicate
back and forth, you probably need such privileges.
You should ask the developers why they need such privileges, or dig
the code by yourself.

Some mail list you would suggest, Luka?
 
> SELECT * FROM pldbg_create_listener();
uh oh, it mentions a listener...then there must be some "sender"
somehwere, that probably needs privileges.

Surprisingly this passes OK under non-privileged user.

PAF

pgsql-general by date:

Previous
From: Luca Ferrari
Date:
Subject: Re: debugger from superuser only.... why?
Next
From: Dominique Devienne
Date:
Subject: Re: How to fork pg_dump or psql w/o leaking secrets?