Обсуждение: Failure Recovery

Greetings..

I have seen some databases writing to a 'Before Image' and 'After Image'
that processes pening and completed transactions so that incase of an
abnormal termination the DB can be automatically recovered.

Do we have this ability or anything similar to it?

--Hal.

am  27.02.2006, um 11:21:50 -0500 mailte Hal Davison folgendes:
> Greetings..
>
> I have seen some databases writing to a 'Before Image' and 'After Image'
> that processes pening and completed transactions so that incase of an
> abnormal termination the DB can be automatically recovered.
>
> Do we have this ability or anything similar to it?

Perhaps do you search for
http://www.postgresql.org/docs/current/static/wal.html


Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

On Mon, 2006-02-27 at 11:28, A. Kretschmer wrote:
> am  27.02.2006, um 11:21:50 -0500 mailte Hal Davison folgendes:
> > Greetings..
> >
> > I have seen some databases writing to a 'Before Image' and 'After Image'
> > that processes pening and completed transactions so that incase of an
> > abnormal termination the DB can be automatically recovered.
> >
> > Do we have this ability or anything similar to it?
>
> Perhaps do you search for
> http://www.postgresql.org/docs/current/static/wal.html
>
>
> Andreas

Yes, I read the WAL docs. Just wanted a personal opinion on the
viability of the feature in real life.

--Hal
Davison Consulting
Sarasota, Florida