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

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 (view raw or flat)
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

pgsql-admin by date

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

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