Обсуждение: Wal logs
This question may seem trivial but how do I rebuild a database with the 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
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
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
I see not out yet :-) So what good are the wal logs to me? What benefit are they? -----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
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