Re: tar error while running basebackup

From: Andre Brandt <brandt(at)decoit(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: tar error while running basebackup
Date: 2009-10-13 13:09:03
Message-ID: 4AD47BEF.7060206@decoit.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


>> How can this happen? I always thought, that, when in backup mode,
>> nothing is able to change the database - so the database files shouldn't
>> change. Can autovaccumdb cause the changes?
>>
>
> pg_start_backup() doesn't tell the database to stop writing changes to disk;
> it essentially just says "perform a checkpoint", which means all changes as of
> that instant are written to the base data files. That ensures that you start
> your base backup in a consistent state. When you recover it, replaying the WAL
> files will fix any weirdness in your base backup, and you'll get a working
> database, current up to the last WAL file you recovered.
>
>

I think, I will install a newer version of tar on my cluster. It seems,
that redhat shipped a really old version (1.15.1) with RHEL5. In version
1.16, the return code was changed when an read problem occurs - so I can
differ between an read error and an fatal error.

Thx for your fast help =)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kevin Grittner 2009-10-13 14:14:04 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Previous Message Joshua Tolley 2009-10-13 11:35:56 Re: tar error while running basebackup