Skip site navigation (1) Skip section navigation (2)

Re: files to ignore during pitr base backup

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-admin(at)postgresql(dot)org
Subject: Re: files to ignore during pitr base backup
Date: 2005-10-25 20:35:35
Message-ID: 20051025203535.GC7836@surnet.cl (view raw or flat)
Thread:
Lists: pgsql-admin
Jeff Frost wrote:
> On Tue, 25 Oct 2005, Tom Lane wrote:
> 
> >It's safe to exclude those, but those are hardly the only files that
> >might "disappear" in a live database.  It'd be better to use a dump
> >tool that's less picky about the source data changing under it.  We've
> >had similar reports about GNU tar being too smart for this purpose :-(
> 
> I would have thought that the pg_start_backup() function would tell the 
> postmasters not to take files out from under the base backup process?

That would be impossible unless you wanted backends to freeze from time
to time while you take the base backup.

-- 
Alvaro Herrera                  http://www.amazon.com/gp/registry/5ZYLFMCVHXC
"La rebeldía es la virtud original del hombre" (Arthur Schopenhauer)

In response to

pgsql-admin by date

Next:From: Jim C. NasbyDate: 2005-10-25 20:44:23
Subject: Re: Why different execution times for different instances for the same query?
Previous:From: Alvaro HerreraDate: 2005-10-25 20:33:45
Subject: Re: Replaying archived wal files after a dump restore?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group