On Sat, 2007-08-04 at 00:00 +0100, Donald Fraser wrote:
> Our company has two sites, a master and a disaster recovery site.
> I am trying to assess whether data has been lost during a fail-over,
> due to the asynchronous method of transporting WAL file data between
> sites (we use DRBD).
>
> Disa
>From my reading, I can use PITR recovery to restore my database to its state
just prior to a recent change (not even an hour ago). The erroneous change
resulted from an UPDATE with no WHERE on a small table (<700 rows); I
mention this only in case there is a simpler recovery technique I can use
fo
