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

Re: Postges 8.0.2 Online backup Errors!

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Postges 8.0.2 Online backup Errors!
Date: 2005-04-29 17:04:19
Message-ID: 6852.1114794259@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
Pallav Kalva <pkalva(at)deg(dot)cc> writes:
> bash-2.05b$ ./backup.sh b
> 17/8E3DA9F0
> tar: tabledata/165899758/165958430: file changed as we read it
> tar: Error exit delayed from previous errors
> 17/8E8CB0A8
> bash-2.05b$

You may need to use a stupider version of tar that doesn't consider that
an error condition.  (Offhand I see nothing in the gnu tar man page
about suppressing this error check :-()  Perhaps cpio would do instead?

The problem is not that you have an unusable backup, it is that if your
script ignores error exits from tar, you won't be able to detect real
problems.

			regards, tom lane

In response to

pgsql-admin by date

Next:From: Mauri SahlbergDate: 2005-04-30 08:16:59
Subject: Backing up users?
Previous:From: Chris BrowneDate: 2005-04-29 16:45:24
Subject: Re: Database Encryption (now required by law in Italy)

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