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 =)
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 |