Re: pg_xlog not cleaned up

[Bruce Momjian <bruce(at)momjian(dot)us>]

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. +