Re: Cross-backend signals and administration (Was: Re: pg_terminate_backend for same-role)

From: Daniel Farina <daniel(at)heroku(dot)com>
To: Andrew Dunstan <andrew(at)dunslane(dot)net>
Cc: Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, Andres Freund <andres(at)anarazel(dot)de>, pgsql-hackers(at)postgresql(dot)org, Robert Haas <robertmhaas(at)gmail(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, Noah Misch <noah(at)leadboat(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Cross-backend signals and administration (Was: Re: pg_terminate_backend for same-role)
Date: 2012-03-27 22:52:04
Message-ID: CAAZKuFbG4wkzwWmh3Ze1QDcc25q-9TheE22117Otc-NV+70hiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Mar 27, 2012 at 1:30 PM, Andrew Dunstan <andrew(at)dunslane(dot)net> wrote:
>> Well, that does sort of leave an arguable vulnerability.  Should the
>> same user only be allowed to kill the process from a connection to
>> the same database?
>>
>
> It might be a reasonable restriction in theory, but I doubt it's much of a
> security gain.

If this restriction makes anyone feel better, it doesn't bother/change
anything for me in the slightest (for both terminate and cancel), and
that way no interesting pg_hba.conf trickery will be broken, as far as
I can see.

--
fdr

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Robert Haas 2012-03-28 00:30:12 Re: Patch: add timing of buffer I/O requests
Previous Message Alex 2012-03-27 22:49:40 Re: Another review of URI for libpq, v7 submission