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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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