Re: BAcking up a Postgres Database - Mailing list pgsql-admin

From Mike Castle
Subject Re: BAcking up a Postgres Database
Date
Msg-id 20010114172905.B3604@thune.yy.com
Whole thread Raw
In response to Re: BAcking up a Postgres Database  (Tim White <twhite26@kc.rr.com>)
List pgsql-admin
On Thu, Jan 11, 2001 at 08:57:26AM -0600, Tim White wrote:
> In Oracle, you restore the data files from a previous backup and then
> re-apply the transaction (archive)
> logs, a process called "rolling forward", then you can open the database
> for use, and it is in the state
> just prior to the failure.  I've seen some creative dialogue on this list

And where do you get this transaction log?

hmmmm
let me guess:

From a backup?

mrc
--
       Mike Castle       Life is like a clock:  You can work constantly
  dalgoda@ix.netcom.com  and be right all the time, or not work at all
www.netcom.com/~dalgoda/ and be right at least twice a day.  -- mrc
    We are all of us living in the shadow of Manhattan.  -- Watchmen

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Another backup q
Next
From: Bruce Momjian
Date:
Subject: Re: JDBC Trouble