Re: Delete rule does not prevent truncate

From: Tim Smith <randomdev4+postgres(at)gmail(dot)com>
To: Rob Sargent <robjsargent(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Delete rule does not prevent truncate
Date: 2015-07-24 09:29:21
Message-ID: CA+HuS5F180pPPpi-FrbwFcMbnPh7NtaBWaO7LVWe1WRj4aM1hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24 July 2015 at 01:37, Rob Sargent <robjsargent(at)gmail(dot)com> wrote:

> Fair enough but both blackhats and the authorized are just as likely to drop
> the database as truncate something (intentionally or not) and backups
> stashed everywhere is the first order of business.

That's not the point. Backups are important, but so is the concept of
various layers of anti-fat-finger protection. Restoring off backups
should be last resort, not first.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andres Freund 2015-07-24 09:32:06 Re: Delete rule does not prevent truncate
Previous Message Tim Smith 2015-07-24 09:27:23 Re: Delete rule does not prevent truncate