Bug in postgres 9.2 installation: pg_archivecleanup: command not found

Hi,

You probably need to install -contrib subpackage as well.

Regards,

"Niels Kristian Schjødt" <nielskristian@autouncle.com> wrote:

I have installed postgres 9.2 on ubuntu 12.04 like this:

sudo add-apt-repository ppa:pitti/postgresql
sudo apt-get update
sudo apt-get install postgresql-9.2

However after this, i get the following error:

2012-11-12 17:49:38 GMT WARNING: archive_cleanup_command
"pg_archivecleanup /var/lib/postgresql/9.2/wals/ %r": return code 32512
sh: 1: pg_archivecleanup: not found

The same happens if I try directly as root:

root@slave-db ~ # pg_archivecleanup
pg_archivecleanup: command not found

What can I do about it?

--
Sent from my Android phone with K-9 Mail. Please excuse my brevity.

I found this is the manual:

http://www.postgresql.org/docs/9.1/static/pgarchivecleanup.html
F.25.4. Supported Server Versions

pg_archivecleanup is designed to work with PostgreSQL 8.0 and later when used as a standalone utility, or with PostgreSQL 9.0 and later when used as an archive cleanup command.

How does that match your answer? I would expect it to be part of the installation, when used in this:

archive_cleanup_command "pg_archivecleanup /var/lib/postgresql/9.2/wals/ %r"

inside my recovery.conf file.

Den 12/11/2012 kl. 19.55 skrev Devrim Gündüz <devrim@gunduz.org>: