Re: [GENERAL] pg_xlog not cleaned up

2006-08-05 Thread Christian Kastner
Tom Lane wrote: Christian Kastner [EMAIL PROTECTED] 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/000100020009.0018C208.backup

Re: [GENERAL] pg_xlog not cleaned up

2006-08-04 Thread Christian Kastner
Tom Lane wrote: Wayne Conrad [EMAIL PROTECTED] writes: On Mon, Jul 31, 2006 at 10:18:31PM +0200, Christian Kastner wrote: After the online backup script runs, all subsequent attempts to run archive_command fail because the first thing it tries to archive away is the still-existing *.backup

Re: [GENERAL] pg_xlog not cleaned up

2006-08-01 Thread Christian Kastner
Simon Riggs wrote: On Mon, 2006-07-31 at 22:18 +0200, Christian Kastner wrote: Bruce Momjian wrote: 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

[GENERAL] pg_xlog not cleaned up

2006-07-31 Thread Christian Kastner
.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) .backup file. I'd appreciate any hints on what might be going on! Chris -- Christian Kastner PGP Key

Re: [GENERAL] pg_xlog not cleaned up

2006-07-31 Thread Christian Kastner
removed. This only applies to *.backup / *.done pairs. I watched WAL segments go from *.ready to *.done, after which the *.done files were removed from pg_xlog/archive_status. Best Regards, Chris -- Christian Kastner PGP Key: AE90E13f ---(end of broadcast