| 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: | Whole Thread | Raw Message | 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
| 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 |