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(at)candle(dot)pha(dot)pa(dot)us]
> Sent: Thu 7/29/2004 11:34 PM
> To: Jason Tesser
> Cc: pgsql-general(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us]
> > Sent: Thu 7/29/2004 7:56 PM
> > To: Jason Tesser
> > Cc: pgsql-general(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073