Re: Wal logs

Jason Tesser wrote:
> I see not out yet :-)  So what good are the wal logs to me?  What benefit are they?
>

Crash recovery after OS failure and reboot.

---------------------------------------------------------------------------

>
> -----Original Message-----
> From:    Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent:    Thu 7/29/2004 11:34 PM
> To:    Jason Tesser
> Cc:    pgsql-general@postgresql.org
> Subject:    Re: [GENERAL] Wal logs
>
> Point-in-time recovery coming in 7.5.  You want instructions?
>
> ---------------------------------------------------------------------------
>
> Jason Tesser wrote:
> > how
> >
> >
> > -----Original Message-----
> > From:    Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> > Sent:    Thu 7/29/2004 7:56 PM
> > To:    Jason Tesser
> > Cc:    pgsql-general@postgresql.org
> > Subject:    Re: [GENERAL] Wal logs
> > Jason Tesser wrote:
> > > This question may seem trivial but how do I rebuild a database with the
> > > wal logs?
> >
> > You can't, but with 7.5 you can archive those logs and use them and a
> > recent backup for point-in-time recovery.
> >
> > --
> >   Bruce Momjian                        |  http://candle.pha.pa.us
> >   pgman@candle.pha.pa.us               |  (610) 359-1001
> >   +  If your life is a hard drive,     |  13 Roberts Road
> >   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
> >
> >
> >
>
> --
>   Bruce Momjian                        |  http://candle.pha.pa.us
>   pgman@candle.pha.pa.us               |  (610) 359-1001
>   +  If your life is a hard drive,     |  13 Roberts Road
>   +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073
>
>
>

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073