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.



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

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 ===

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

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



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster