Wal logs

Started by Jason Tesseralmost 22 years ago6 messagesgeneral

Jump to latest

Jason Tesser

JTesser@nbbc.edu

almost 22 years ago

This question may seem trivial but how do I rebuild a database with the
wal logs?

Bruce Momjian

bruce@momjian.us

almost 22 years ago

In reply to: Jason Tesser (#1)

Re: 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

Jason Tesser

JTesser@nbbc.edu

almost 22 years ago

In reply to: Bruce Momjian (#2)

Re: Wal logs

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

Import Notes

Resolved by subject fallback

Bruce Momjian

bruce@momjian.us

almost 22 years ago

In reply to: Jason Tesser (#3)

Re: 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

JTesser@nbbc.edu

almost 22 years ago

In reply to: Bruce Momjian (#4)

Re: Wal logs

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

Import Notes

Resolved by subject fallback

Bruce Momjian

bruce@momjian.us

almost 22 years ago

In reply to: Jason Tesser (#5)

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