Re: pg_xlog not cleaned up

From: Christian Kastner <techmail(at)kvr(dot)at>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Wayne Conrad <wconrad(at)yagni(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog not cleaned up
Date: 2006-08-05 11:48:34
Message-ID: 44D48592.6080800@kvr.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Christian Kastner <techmail(at)kvr(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2006-08-05 16:11:48 Re: PostgreSQL Internals
Previous Message Germán Hüttemann Arza 2006-08-05 10:44:04 PostgreSQL Internals