| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2005-10-25 20:44:23 | Re: Why different execution times for different instances for the same query? |
| Previous Message | Alvaro Herrera | 2005-10-25 20:33:45 | Re: Replaying archived wal files after a dump restore? |