Re: HOT Standby - slave does not appear to be removing wal files

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.