Обсуждение: Bug in postgres 9.2 installation: pg_archivecleanup: command not found

Поиск
Список
Период
Сортировка

Bug in postgres 9.2 installation: pg_archivecleanup: command not found

От
Niels Kristian Schjødt
Дата:
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?

Re: Bug in postgres 9.2 installation: pg_archivecleanup: command not found

От
Devrim Gündüz
Дата:
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.

Re: Bug in postgres 9.2 installation: pg_archivecleanup: command not found

От
Niels Kristian Schjødt
Дата:
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>:

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.