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

Re: WAL rotation question version 8.3.0

From: Evan Rempel <erempel(at)uvic(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL rotation question version 8.3.0
Date: 2008-05-15 21:16:49
Message-ID: 482CA841.8000605@uvic.ca (view raw or flat)
Thread:
Lists: pgsql-admin
Alvaro Herrera wrote:
> Evan Rempel wrote:
> 
>> Now to the question.
>>
>> Once the archive_command starts lying about its success, postgresql  deletes
>> a number of the xlog files that it has been told have been successfuly archived.
>> Why does it do this? Can I control it? Can I turn it off?
> 
> Because they're no longer needed.
> 
> If you want to keep those files, make the archive_command not lie.


Normally posgres will rename the old WAL files that have been archived and are no longer needed,
keeping the number of WAL files constant. In this case, it actually deletes them.
Why is the behaviour different?

-- 
Evan Rempel

In response to

Responses

pgsql-admin by date

Next:From: Alvaro HerreraDate: 2008-05-15 21:31:28
Subject: Re: WAL rotation question version 8.3.0
Previous:From: Alvaro HerreraDate: 2008-05-15 21:13:53
Subject: Re: WAL rotation question version 8.3.0

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