Barman compatible error

[Rajasekar Arumugam]

Hi Team,

I am getting below error on barman check. Any idea how to fix this 

barman check db-test
Server db-test:
PostgreSQL: OK
superuser or standard user with backup privileges: OK
PostgreSQL streaming: FAILED (connection to server at "xxxxxxxx", port 5432 failed: FATAL:  no pg_hba.conf entry for replication connection from host "xxxxxxxxxx", user "postgres", SSL on)
wal_level: OK
replication slot: FAILED (replication slot 'barman_xxx' doesn't exist. Please execute 'barman receive-wal --create-slot db-test')
directories: OK
retention policy settings: OK
backup maximum age: OK (no last_backup_maximum_age provided)
backup minimum size: OK (8.5 GiB)
wal maximum age: OK (no last_wal_maximum_age provided)
wal size: OK (0 B)
compression settings: OK
failed backups: OK (there are 0 failed backups)
minimum redundancy requirements: OK (have 1 backups, expected at least 0)
pg_basebackup: OK
pg_basebackup compatible: FAILED (PostgreSQL version: None, pg_basebackup version: 10.23)
pg_basebackup supports tablespaces mapping: OK
systemid coherence: OK
pg_receivexlog: OK
pg_receivexlog compatible: FAILED (PostgreSQL version: None, pg_receivexlog version: 10.23)
receive-wal running: FAILED (See the Barman log file for more details)
archiver errors: OK

PostgreSQL server hba file: (One of the other server has the same file but it is working)

cat /etc/postgresql/10/main/pg_hba.conf
local   all             postgres                                peer
local   all             all                                     peer
host    all             all             127.0.0.1/32            md5
host    all             all             ::1/128                 md5
host    all             all             0.0.0.0/0               md5

[Luca Ferrari]

On Fri, Feb 23, 2024 at 1:50 PM 'Rajasekar Arumugam' via Barman,
Backup and Recovery Manager for PostgreSQL <pgba...@googlegroups.com>
wrote:

> PostgreSQL streaming: FAILED (connection to server at "xxxxxxxx", port 5432 failed: FATAL: no pg_hba.conf entry for replication connection from host "xxxxxxxxxx", user "postgres", SSL on)

> cat /etc/postgresql/10/main/pg_hba.conf
> local all postgres peer
> local all all peer
> host all all 127.0.0.1/32 md5
> host all all ::1/128 md5
> host all all 0.0.0.0/0 md5
>

You need replication entries, not only host ones.
And probably an upgrade of PostgreSQL 10...

Luca

[kaido vaikla]

Hi, 
In pg_hba.conf is missing:

host replication postgres ... ...

br
Kaido

--
--
You received this message because you are subscribed to the "Barman for PostgreSQL" group.
To post to this group, send email to pgba...@googlegroups.com
To unsubscribe from this group, send email to
pgbarman+u...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/pgbarman?hl=en?hl=en-GB

---
You received this message because you are subscribed to the Google Groups "Barman, Backup and Recovery Manager for PostgreSQL" group.
To unsubscribe from this group and stop receiving emails from it, send an email to pgbarman+u...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/pgbarman/a63d475f-e2f3-44f2-b6b5-c360fa459b7bn%40googlegroups.com.