Re: BAcking up a Postgres Database

From: Mike Castle <dalgoda(at)ix(dot)netcom(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: BAcking up a Postgres Database
Date: 2001-01-15 01:29:05
Message-ID: 20010114172905.B3604@thune.yy.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)ix(dot)netcom(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bruce Momjian 2001-01-15 02:04:02 Re: JDBC Trouble
Previous Message Tom Lane 2001-01-15 00:34:49 Re: Another backup q