> With stock PostgreSQL... how many committed transactions can one
> 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?
With WAL the theory is that it will not lose a committed transaction.
Bugs have plagged previous versions (7.1.2 looks clean) and it none
(Oracle, Informix, Postgres) can protect against coding errors in the
certain cases but from general power failure it's fine.
This assumes adequate hardware too. Some harddrives claim to have
written when they haven't among other things, but Postgres itself
won't lose the information -- your hardware might :do that silently
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2001-07-03 19:45:59|
|Subject: Re: [PATCH] Patch to make pg_hba.conf handle virtualhost access control and samehost keyword |
|Previous:||From: Nathan Myers||Date: 2001-07-03 19:36:19|
|Subject: Re: Buffer access rules, and a probable bug|