From: | Paul Jungwirth <pj(at)illuminatedcomputing(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | pg_archivecleanup not deleting anything? |
Date: | 2015-11-02 15:44:22 |
Message-ID: | 563784D6.9090902@illuminatedcomputing.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello,
I'm running Postgres 9.3 in a warm standby configuration, and the slave
has this setting in recovery.conf:
archive_cleanup_command = '/usr/lib/postgresql/9.3/bin/pg_archivecleanup
/secure/pgsql/archive/ %r'
But I noticed that the archive directory had files going back to
February 2014:
$ ls -ltr archive | head
total 9126292
-rw------- 1 postgres postgres 300 Feb 15 2014
000000010000000000000002.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
000000010000000000000003.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
000000010000000000000004.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
000000010000000000000006.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
000000010000000000000007.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
00000001000000000000000B.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
00000001000000000000000C.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
00000001000000000000000E.00000028.backup
-rw------- 1 postgres postgres 300 Feb 15 2014
00000001000000000000000F.00000028.backup
And even if I run the command by hand, nothing is actually deleted:
$ pg_archivecleanup -d /secure/pgsql/archive/
00000001000000000000000F.00000028.backup
pg_archivecleanup: keep WAL file
"/secure/pgsql/archive//00000001000000000000000F" and later
Despite the message, and the same files remain.
Does anyone have any idea why pg_archivecleanup isn't deleting anything?
Thanks,
Paul
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2015-11-02 15:58:23 | Re: pg_archivecleanup not deleting anything? |
Previous Message | Tom Dearman | 2015-11-02 15:32:08 | Re: Waiting on ExclusiveLock on extension 9.3, 9.4 and 9.5 |