Re: [GENERAL] Disk Failure Scenarios

2006-04-27 Thread Michael Artz
> -Disk 2: If the transaction log dies, all changes since the last> checkpoint are lost, right?  Again, if I set up an empty pg_xlog > directory somewhere else, the DB should run just fine, right?No, because there's no way to know what state the data pages are in.Data may have made it to disk, may

Re: [GENERAL] Disk Failure Scenarios

2006-04-26 Thread Jim C. Nasby
On Wed, Apr 26, 2006 at 11:54:23PM -0400, Michael Artz wrote: > -Disk1: If the OS/Postgres install disk fails, its possible to > reinstall the OS and the same version of Postgres and point it at disk > 3 and everything should run, right? Only if that doesn't include $PGDATA > -Disk 2: If the tran