Re: files to ignore during pitr base backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: files to ignore during pitr base backup
Date: 2005-10-25 18:09:25
Message-ID: 18695.1130263765@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jeff Frost <jeff(at)frostconsultingllc(dot)com> writes:
> I noticed recently that my PITR base backups were occassionally returning
> non-zero, so I turned up the verbosity on rsync and it appears that
> occassionally a file vanishes out from under rsync while it's doing the base
> backup:
> ...
> Would it be ok to just exclude the pg_internal.init file since it disappeared
> during the base backup?

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 :-(

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-10-25 19:29:27 Re: files to ignore during pitr base backup
Previous Message Harald Fuchs 2005-10-25 17:39:51 Re: excluding a table from pg_dump