Re: Recovery Features

From: Mike Mascari <mascarm(at)mascari(dot)com>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Recovery Features
Date: 2004-07-05 22:40:51
Message-ID: 40E9D8F3.30906@mascari.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Simon Riggs wrote:

> On Mon, 2004-07-05 at 22:30, Tom Lane wrote:
>
> ...Nobody is shouting YES, so its a dodo...

I can imagine a scenario where the junior DBA accidentally deletes
all rows from some obscure table that wouldn't have logical
implications for later transactions. But I suspect most people would
perform recovery in a separate instance, and just hand-dump/restore
the table in question. The point at which the above process becomes
too complex (or less than obvious) for hand-recovery is precisely
when unforeseen consequences of nixing a single transaction become
too great.

IMHO,

Mike Mascari

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2004-07-05 23:04:12 Re: Security...
Previous Message Andrew Dunstan 2004-07-05 22:34:15 Re: plperl security