[HACKERS] background writer, WAL and snapshot backups

2003-11-28 Thread Paul Tuckfield
I really like the idea of taking a snapshot backup with postgres, using either volume manager or hardware splits in a disk array to get a physical backup. In other, lesser database systems :) the system is structured to prevent problems arising from split block writes, meaning that though the

Re: [HACKERS] background writer, WAL and snapshot backups

2003-11-28 Thread Bruce Momjian
Paul Tuckfield wrote: I really like the idea of taking a snapshot backup with postgres, using either volume manager or hardware splits in a disk array to get a physical backup. In other, lesser database systems :) the system is structured to prevent problems arising from split block writes,

Re: [HACKERS] background writer, WAL and snapshot backups

2003-11-28 Thread Gavin Sherry
On Wed, 25 Nov 2003, Paul Tuckfield wrote: I really like the idea of taking a snapshot backup with postgres, using either volume manager or hardware splits in a disk array to get a physical backup. Does anyone else see any value in snapshotting. It would, I image, essentially work like this: