Re: Backup and Recovery - Mailing list pgsql-hackers

From nj7e@yahoo.com (John Moore)
Subject Re: Backup and Recovery
Date
Msg-id f91dbbdd.0106280733.8612a95@posting.google.com
Whole thread Raw
In response to Re: Backup and Recovery  (Matthew Kirkwood <matthew@hairy.beasts.org>)
Responses Re: Re: Backup and Recovery
List pgsql-hackers
matthew@hairy.beasts.org (Matthew Kirkwood) wrote in message
news:<Pine.LNX.4.33.0106201212240.25630-100000@sphinx.mythic-beasts.com>...
> On Tue, 19 Jun 2001, Naomi Walker wrote:
> 
> > Even more important that uptime to us, is to never put ourselves in a
> > position where we could lose data.  I understand I can do a hot backup
> > with pg_dumpall.  What we need on top of that is the ability to replay
> > the transaction logs against the previous database archive.  Without
> > such a feature, even if I did a full backup a few times a day, we
> > would be vulnerable to losing hours of data (which would not be
> > acceptable to our users).
> 
> This is what I'd like too (though I'm not that bothered about
> rolling forward from a dump if I can just do it by replaying
> logs onto real datafiles).

With stock PostgreSQL... how many committed transactions can one lose
on a simple system crash/reboot? With Oracle or Informix, the answer
is zero. Is that true with PostgreSQL in fsync mode? If not, does it
lose all in the log, or just those not yet written to the DB?

Thanks

John


pgsql-hackers by date:

Previous
From: Ilan Fait
Date:
Subject: how to monitor/examine the database
Next
From: "David D. Kilzer"
Date:
Subject: Re: [PATCH] Contrib C source for casting MONEY to INT[248] and FLOAT[48]