pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Mr. Dan <bitsandbytes88@hotmail.com>
To: marco.bizzarri@gmail.com
To: pgsql-admin@postgresql.org
Subject: Re: On-line backup - /bin/tar: Error exit delayed from previous errors
Date: Thu, 03 Aug 2006 09:13:00 -0400
Message-ID: <BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl> (raw)
In-Reply-To: <3f0d61c40608030102i141db9bteb8bbfb47db749f2@mail.gmail.com>


Hi Marco/all,

Thanks for the response.  I've been running the same online-backup commands 
for over a year and restores have always worked fine.  I've never seen 'file 
changed as we read it' though,  before yesterday.  The database is new to 
the server, as of a week.  So, I'm more inclined to think it's somehting 
going on with the database instead of  the command to do the backup.  BTW, I 
received the same message this morning.  So, 2 days in a row (no pun 
intended) on the same database and the same second number following the 
databe number.
/bin/tar: /sqldata/Linux.pgsql/base/19473856/19524666: file changed as we 
read it

psql -d DBN -c "SELECT pg_start_backup('somehting.backup');"
tar -zcvf /something.tar.gz /PGDATA/dir/*
psql -d DBN -c "SELECT pg_stop_backup();"

Thanks,
~DjK






>From: "Marco Bizzarri" <marco.bizzarri@gmail.com>
>To: "Mr. Dan" <bitsandbytes88@hotmail.com>
>Subject: Re: [ADMIN] On-line backup - /bin/tar: Error exit delayed from 
>previous errors
>Date: Thu, 3 Aug 2006 10:02:25 +0200
>
>I think you should post the command you're using, as well as the
>condition in which you're doing the tar: is the postgresql running or
>not?
>
>IMHO, I would be *VERY* concerned about such a message.
>
>Regards
>Marco
>
>On 8/2/06, Mr. Dan <bitsandbytes88@hotmail.com> wrote:
>>/bin/tar: /sqldata/Linux.pgsql/base/19473856/19524666: file changed as we
>>read it
>>
>>Hi,
>>
>>I'm seeing that a file changed during the /bin/tar process.  Is that
>>anything to be concerned about?
>>This is the first time this happened in a month.  Does that mean I'm still
>>backed up in regards to that database?  I'm using v810 here.
>>
>>The tar file exists, so the tar file was created.
>>
>>Thanks,
>>~DjK
>>
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 9: In versions below 8.0, the planner will ignore your desire to
>>        choose an index scan if your joining column's datatypes do not
>>        match
>>
>
>
>--
>Marco Bizzarri
>http://notenotturne.blogspot.com/





view thread (5+ messages)  latest in thread

Message-ID: <BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl>
Permalink:  ../BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl/
Also on:    postgresql.org/message-id/BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: bitsandbytes88@hotmail.com, marco.bizzarri@gmail.com
  Subject: Re: On-line backup - /bin/tar: Error exit delayed from previous errors
  In-Reply-To: <BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl>
  References: <3f0d61c40608030102i141db9bteb8bbfb47db749f2@mail.gmail.com> <BAY116-F267CC3896A0BFB60DF12D2D1530@phx.gbl>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox