From: olimaz <oliver.mazariegos@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: HOT Standby - slave does not appear to be removing wal files
Date: Mon, 23 Dec 2013 09:35:03 -0800 (PST)
Message-ID: <1387820103987-5784441.post@n5.nabble.com> (raw)
In-Reply-To: <5137EE26.6010405@consistentstate.com>
References: <5137EE26.6010405@consistentstate.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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-t...
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: oliver.mazariegos@gmail.com
Subject: Re: HOT Standby - slave does not appear to be removing wal files
In-Reply-To: <1387820103987-5784441.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox