RE: Re: Backup and Recovery - Mailing list pgsql-hackers

From Mikheev, Vadim
Subject RE: Re: Backup and Recovery
Date
Msg-id 3705826352029646A3E91C53F7189E320166AA@sectorbase2.sectorbase.com
Whole thread Raw
In response to Backup and Recovery  (Naomi Walker <nwalker@eldocomp.com>)
List pgsql-hackers
> 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

It's true or better say should be, keeping in mind probability of bugs.

> lose all in the log, or just those not yet written to the DB?

BAR is not for "simple crash" but for the disk crashes. In this case
one will lose as much as WAL files lost.

Vadim


pgsql-hackers by date:

Previous
From: "Matthew T. O'Connor"
Date:
Subject: Help with SI buffer overflow error
Next
From: Matthew
Date:
Subject: Help with SI buffer overflow error