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

Re: WAL rotation question version 8.3.0

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Evan Rempel <erempel(at)uvic(dot)ca>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL rotation question version 8.3.0
Date: 2008-05-15 21:13:53
Message-ID: 20080515211353.GO8221@alvh.no-ip.org (view raw or flat)
Thread:
Lists: pgsql-admin
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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

In response to

Responses

pgsql-admin by date

Next:From: Evan RempelDate: 2008-05-15 21:16:49
Subject: Re: WAL rotation question version 8.3.0
Previous:From: Evan RempelDate: 2008-05-15 20:47:47
Subject: WAL rotation question version 8.3.0

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