files to ignore during pitr base backup

From: Jeff Frost <jeff(at)frostconsultingllc(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: files to ignore during pitr base backup
Date: 2005-10-25 15:44:40
Message-ID: Pine.LNX.4.64.0510250842410.17611@discord.dyndns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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:

700 4% 52.58kB/s 0:00:00
16384 100% 1.12MB/s 0:00:00 (125, 71.4% of 1024)
file has vanished: "/usr/local/pgsql/data/base/1219609879/pg_internal.init"
base/17229/

sent 258563798 bytes received 1348515 bytes 2809862.84 bytes/sec
total size is 8273133704 speedup is 31.83
rsync warning: some files vanished before they could be transferred (code
24) at main.c(791)
PITR base backup rsync command failed!

Would it be ok to just exclude the pg_internal.init file since it disappeared
during the base backup?

--
Jeff Frost, Owner <jeff(at)frostconsultingllc(dot)com>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jeff Frost 2005-10-25 15:55:06 Re: Replaying archived wal files after a dump restore?
Previous Message Hannes Dorbath 2005-10-25 09:31:51 Re: excluding a table from pg_dump