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 или я ошибаюсь?
  • Вопрос задан
  • 277 просмотров
Решения вопроса 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.
Ответ написан
Пригласить эксперта
Ваш ответ на вопрос

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

Похожие вопросы