Re: BAcking up a Postgres Database

Yes, you do restore the archive logs from some backup medium.  But I don't
understand you point, the discussion relates to transaction logging, meaning
that as dml statements are executed and committed they are logged, thus making
it possible to re-apply them.  To my knowledge Postgres does not do
transaction logging, this makes it nearly impossible to do point of failure
recovery without doing a pg_dump after every transaction, which is rather
impractical.

Tim White

Mike Castle wrote:

> 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