| From: | Bradley McLean <brad(at)bradm(dot)net> |
|---|---|
| To: | Larry Rosenman <ler(at)lerctr(dot)org> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, gearond(at)cvc(dot)net, Dmitry Tkach <dmitry(at)openratings(dot)com>, mike McGire <mmcgire(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: A few questions to real pgsql gurus |
| Date: | 2003-02-24 19:58:16 |
| Message-ID: | 20030224195816.GA7551@nia.bradm.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
* Larry Rosenman (ler(at)lerctr(dot)org) [030224 13:48]:
>
> --On Monday, February 24, 2003 12:28:03 -0500 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
> wrote:
>
> >If he's got an accurate snapshot of the WAL files, everything the
> >database has claimed to be committed will be committed. It's the same
> >scenario as a crash.
>
> the netapp facility is called SnapShot.
>
> What happens is that the original blocks of the file are write protected,
> and any changes are put elsewhere. (I don't recall whether it's the new or
> the old blocks that get saved, but it doesn't matter, the effect is the
> same).
>
> The snapshot stuff in Veritas' VxFS is very similar.
>
> It makes a consistent view of the filesystem available for backup.
And just for completeness, this is also available in Linux via LVM
see http://tldp.org/HOWTO/LVM-HOWTO/index.html - it works great out of
the box on RH8 - we have a 2TB NFS/SMB server built on it.
-Brad
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-02-24 20:09:02 | Re: A few questions to real pgsql gurus |
| Previous Message | Darko Prenosil | 2003-02-24 19:53:05 | I cant find it or I'm just lazy ? |