Re: Wal logs - Mailing list pgsql-general

From Bruce Momjian
Subject Re: Wal logs
Date
Msg-id 200407301640.i6UGedH24800@candle.pha.pa.us
Whole thread Raw
In response to Re: Wal logs  ("Jason Tesser" <JTesser@nbbc.edu>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Devrim GUNDUZ
Date:
Subject: Re: 7.2 - 7.4.2 production server migration issue
Next
From: Bruno Wolff III
Date:
Subject: Re: 7.2 - 7.4.2 production server migration issue