Re: pg_xlog not cleaned up - Mailing list pgsql-general

From Christian Kastner
Subject Re: pg_xlog not cleaned up
Date
Msg-id 44D48592.6080800@kvr.at
Whole thread Raw
In response to Re: pg_xlog not cleaned up  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tom Lane wrote:
> Christian Kastner <techmail@kvr.at> writes:
>> That's not what I'm seeing. The following log messages are repeated
>> every few minutes after a successful backup run:
>
>> LOG:  Archivbefehl >/usr/local/bin/archive_wal.sh
>> pg_xlog/000000010000000200000009.0018C208.backup
>> 000000010000000200000009.0018C208.backup< fehlgeschlagen: Fehlercode 256
>> File already exists
>> ...
>
> Yes, but are there .ready and/or .done files for that .backup file in the
> archive_status subdirectory?
>
>             regards, tom lane

Yes, there is a corresponding .done file in archive_status.

The problem is quite easy to reproduce (IIRC calling pg_start_backup and
pg_stop_backup without actually doing anything in between is enough). I
will post detailed reproduction steps as well as pg_xlog activity when I
get back to the office on Monday.

Best regards,
Chris

--
Christian Kastner
PGP Key: AE90E13F

pgsql-general by date:

Previous
From: "Germán Hüttemann Arza"
Date:
Subject: PostgreSQL Internals
Next
From: Tom Lane
Date:
Subject: Re: PostgreSQL Internals