Kenny00
@Kenny00

Почему Barman не находит pg_receivexlog?

Имеется отдельный сервер для бекапа PostgreSQL 10.5.

OC:
Distributor ID: Debian
Description: Debian GNU/Linux 9.13 (stretch)
Release: 9.13
Codename: stretch

Установлено:
psql --version
psql (PostgreSQL) 10.5 (Ubuntu 10.5-24.1C)

barman --version
2.1
Barman by 2ndQuadrant (www.2ndQuadrant.com)

Клиент 1С psql ставился из deb:
Список пакетов
libgcrypt20_1.8.5-3_amd64.deb
libicu55_55.1-7_amd64.deb
libpq5_10.5-24.1C_amd64.deb
libssl1.0.0_1.0.2g-1ubuntu4.15_amd64.deb
libxslt1.1_1.1.32-2.1_amd64.deb
postgresql-client-10_10.5-24.1C_amd64.deb
postgresql-client-common_190_all.deb
postgresql-common_190_all.deb
ssl-cert_1.0.39_all.deb

barman show-server pg_main
Server pg_main:
active: True
archiver: False
archiver_batch_size: 0
backup_directory: /var/lib/barman/pg_main
backup_method: postgres
backup_options: BackupOptions(['concurrent_backup'])
bandwidth_limit: None
barman_home: /var/lib/barman
barman_lock_directory: /var/lib/barman
basebackup_retry_sleep: 30
basebackup_retry_times: 0
basebackups_directory: /var/lib/barman/pg_main/base
check_timeout: 30
compression: None
connection_error: None
conninfo: host=pg port=5432 user=barman dbname=postgres
current_size: None
current_xlog: None
custom_compression_filter: None
custom_decompression_filter: None
data_directory: /var/lib/postgresql/10/main
description: pg_main
disabled: False
errors_directory: /var/lib/barman/pg/errors
immediate_checkpoint: False
incoming_wals_directory: /var/lib/barman/pg/incoming
is_superuser: True
last_backup_maximum_age: None
minimum_redundancy: 2
msg_list: []
name: pg_main
network_compression: False
path_prefix: /usr/lib/postgresql/10/bin
pg_basebackup_bwlimit: True
pg_basebackup_compatible: True
pg_basebackup_installed: True
pg_basebackup_path: /usr/lib/postgresql/10/bin/pg_basebackup
pg_basebackup_tbls_mapping: True
pg_basebackup_version: 10.5-24.1C)
pg_receivexlog_compatible: None
pg_receivexlog_installed: True
pg_receivexlog_path: /usr/bin/pg_receivexlog
pg_receivexlog_supports_slots: None
pg_receivexlog_synchronous: None
pg_receivexlog_version: None
pgespresso_installed: False
post_archive_retry_script: None
post_archive_script: None
post_backup_retry_script: None
post_backup_script: None
pre_archive_retry_script: None
pre_archive_script: None
pre_backup_retry_script: None
pre_backup_script: None
recovery_options: RecoveryOptions([])
replication_slot: None
replication_slot_support: True
retention_policy: RECOVERY WINDOW OF 7 DAYS
retention_policy_mode: auto
reuse_backup: None
server_txt_version: 10.5
slot_name: pg03_main
ssh_command: None
streaming: True
streaming_archiver: True
streaming_archiver_batch_size: 0
streaming_archiver_name: barman_receive_wal
streaming_backup_name: barman_streaming_backup
streaming_conninfo: host=pg port=5432 user=streaming_barman
streaming_supported: True
streaming_wals_directory: /var/lib/barman/pg_main/streaming
synchronous_standby_names: None
systemid: 6874880056196028997
tablespace_bandwidth_limit: None
timeline: 1
wal_level: replica
wal_retention_policy: MAIN
wals_directory: /var/lib/barman/pg_main/wals
xlogpos: 7/950001B0

barman check pg
Server pg:
        WAL archive: FAILED (please make sure WAL shipping is setup)
        PostgreSQL: FAILED
        directories: OK
        retention policy settings: OK
        backup maximum age: OK (no last_backup_maximum_age provided)
        compression settings: OK
        failed backups: OK (there are 0 failed backups)
        minimum redundancy requirements: FAILED (have 0 backups, expected at least 2)
        pg_basebackup: OK
        pg_basebackup compatible: OK
        pg_receivexlog: OK
        pg_receivexlog compatible: FAILED (PostgreSQL version: 10.5, pg_receivexlog version: None)
        receive-wal running: FAILED (See the Barman log file for more details)
        archiver errors: OK


Проблема pg_receivexlog compatible: FAILED (PostgreSQL version: 10.5, pg_receivexlog version: None)

В /etc/barman.conf внес PATH
path_prefix = /usr/lib/postgresql/10/bin

Ничего не поменялось, что не хватает? В документации и в гугле ничего не нашел подходящего.
Пишут смотри pg_receivexlog_path: /usr/bin/pg_receivexlog , так 10 версия сборка 1С, туда ничего не ставит в принципе.

На сколько я знаю pg_receivexlog стал pg_receivewal или я ошибаюсь?
  • Вопрос задан
  • 229 просмотров
Решения вопроса 1
Melkij
@Melkij
PostgreSQL DBA
https://www.pgbarman.org/barman-2-3-released/
5 September 2017: 2ndQuadrant is proud to announce the release of Barman version 2.3, a Backup and Recovery Manager for PostgreSQL.

This minor release introduces support for PostgreSQL 10.
Ответ написан
Пригласить эксперта
Ваш ответ на вопрос

Войдите, чтобы написать ответ

Войти через центр авторизации
Похожие вопросы