Re: FW: Setting up of PITR system.

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Spiegelberg, Greg" <gspiegelberg(at)cranel(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, andy(dot)shellam(at)mailnetwork(dot)co(dot)uk, Rajesh Kumar Mallah <mallah(dot)rajesh(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: FW: Setting up of PITR system.
Date: 2006-04-11 12:14:39
Message-ID: 200604111214.k3BCEdu06824@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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: pgsql-admin-owner(at)postgresql(dot)org on behalf of Tom Lane
> Sent: Mon 4/10/2006 7:19 PM
> To: Bruce Momjian
> Cc: andy(dot)shellam(at)mailnetwork(dot)co(dot)uk; 'Rajesh Kumar Mallah'; pgsql-admin(at)postgresql(dot)org
> Subject: Re: FW: [ADMIN] Setting up of PITR system.
>
>
>
> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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 majordomo(at)postgresql(dot)org 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. +

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bruno G. Albuquerque 2006-04-11 12:29:41 Large scale PostgreSQL deployment.
Previous Message FM 2006-04-11 12:11:59 advice on PGSQL cluster (active/passive)