Re: pg_xlog not cleaned up

What PostgreSQL version are you using? I know the *.backup file removal
was added in 8.1:

* Remove old "*.backup" files when we do pg_stop_backup() (Bruce)
This prevents a large number of "*.backup" files from existing in
"/pg_xlog".

but the existance of the files should not cause problems.

---------------------------------------------------------------------------

Christian Kastner wrote:
> Hello,
>
> I don't know why, but the XXXXXXXX.backup file created by
> pg_stop_backup() in my pg_xlog never gets deleted, even though it was
> successfully archived (a good copy is stored in the archive area, no
> errors are raised).
> The directory pg_xlog/archive_status contains a matching
> XXXXXXXX.backup.done file, but that one never gets removed as well. As a
> consequence, all further WAL archiving attempts fail as archive_command
> continuously retries to archive the (already archived) XXXXXXXX.backup file.
>
> I'd appreciate any hints on what might be going on!
>
> Chris
>
> --
> Christian Kastner
> PGP Key: AE90E13f
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

--
Bruce Momjian bruce(at)momjian(dot)us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +