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(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