Date: Mon, 23 Dec 2013 09:35:03 -0800 (PST)
From: olimaz <oliver.mazariegos@gmail.com>
To: pgsql-admin@postgresql.org
Message-ID: <1387820103987-5784441.post@n5.nabble.com>
In-Reply-To: <5137EE26.6010405@consistentstate.com>
References: <5137EE26.6010405@consistentstate.com>
Subject: Re: HOT Standby - slave does not appear to be removing wal files
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

I had the very same problem, and after checking postgres log file, found the
following warning every 5 minutes:

archive_cleanup_command  "pg_archivecleanup /srv/postgresql/wals/ %r":
return code 32512

wich means the pg_archivecleanup script was not found.  

The solution: edit the file  /var/lib/postgresql/9.1/main/recovery.conf  and
make sure it is set like this:

archive_cleanup_command = '/usr/lib/postgresql/9.1/bin/pg_archivecleanup 
/srv/postgresql/wals/ %r'

(be careful: I keep my wal files in a special dir "/srv/postgresql/wals/" 
yours will be a different location)

in my case, after 5 minutes, my 140 GB wal dir changed to just 2 files,
being one of them a .backup file.  Before that, I did not had a .backup file
at all, so I could not make use of wal cleanup procedures.

 
--
View this message in context: http://postgresql.1045698.n5.nabble.com/HOT-Standby-slave-does-not-appear-to-be-removing-wal-files-tp5747774p5784441.html
Sent from the PostgreSQL - admin mailing list archive at Nabble.com.


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin