Re: [HACKERS] VACUUM as a denial-of-service attack - Mailing list pgsql-hackers

From Keith Parks
Subject Re: [HACKERS] VACUUM as a denial-of-service attack
Date
Msg-id 199911291930.TAA27498@mtcc.demon.co.uk
Whole thread Raw
List pgsql-hackers
Tom Lane <tgl@sss.pgh.pa.us>
>
>Keith Parks <emkxp01@mtcc.demon.co.uk> writes:
>> In the dim and distant past I produced a patch that put vacuum
>> into the list of things that you could GRANT on a per-table
>
>Thanks for the code, but for now I just threw in a quick pg_ownercheck
>call: VACUUM will now vacuum all tables if you are the superuser, else
>just the tables you own, skipping the rest with a NOTICE.  What you had
>looked like more infrastructure than I thought the problem was worth...
>I suspect most people will run VACUUMs from the superuser account
>anyway...

I didn't think it was worth reworking the code, although I may do
just for fun. Your solution is fine.

Keith.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: [GENERAL] drop/rename table and transactions
Next
From: The Hermit Hacker
Date:
Subject: Re: [HACKERS] VACUUM as a denial-of-service attack