We already recommend file system snapshots as a backup method in our documentation.
--------------------------------------------------------------------------- Spiegelberg, Greg wrote: > You should implement filesystem or volume level snapshots. LVM, Veritas and > the like all have the functionality and it gets the database out of "backup" > mode quickly. > > http://www.tldp.org/HOWTO/LVM-HOWTO/snapshots_backup.html > > Before the lvcreate -s command issue the pg_start_backup() and after > pg_stop_backup(). Then do what you will with the snapshot volume. Just in > case a fsck may be necessary I'd recommend mounting read-only. > > Caveat emptor, I believe certain filesystems take issue with this, like xfs, > however we have not seen anything unusual with ext3. Also note that you must > have some space unallocated in the proper LVM disk group for the snapshot > volume. > > Greg > > ________________________________ > > From: [EMAIL PROTECTED] on behalf of Tom Lane > Sent: Mon 4/10/2006 7:19 PM > To: Bruce Momjian > Cc: [EMAIL PROTECTED]; 'Rajesh Kumar Mallah'; pgsql-admin@postgresql.org > Subject: Re: FW: [ADMIN] Setting up of PITR system. > > > > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Tom Lane wrote: > >> It definitely is a pain in the neck that GNU tar complains about files > >> changing underneath it --- I've looked for a way to disable that, or at > >> least reduce it to a warning instead of an error condition, but gtar > >> doesn't seem to have such a switch. You should try alternative backup > >> tools such as cpio or rsync. > > > You mean the tar exits or that it just returns an error code on > > completion? > > I don't recall whether it finishes making the tarball, but it definitely > returns nonzero exit status, which makes it effectively unusable in any > automated script (you certainly don't want to ignore exit status in a > backup script ...) > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > > -- Bruce Momjian http://candle.pha.pa.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. + ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
