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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-admin by date

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