Postgres Pro
Downloads
Home   >   mailing lists

Thread: Barman issue

Barman issue

From
Rijo Roy
Date:
Hello Experts,

I have a server rhel 6.9 installed with barman 2.3 which is configured to take backup from Postgresql 10 installed in a remote host and the same is working.

I am trying to do a poc on streaming backup and streaming wal method by making use of the pg_receivewal. I have already created a user with replication privilege the same is added in pg_hba. conf. And I am able to connect remotely using the user created.
But when I am running barman check pg
pg is the name given to the remote dB host. I am getting an error like this
EXCEPTION: LooseVersion instance has no attribute 'version'
Below I am pasting the conf files used:
[pg] 
conninfo
streaming_conninfo
streaming_archiver = on
slot_name = barman
backup_method = postgres 
path_prefix = Postgresql bin path
basebackups_directory
errors_directory
incoming_wals_directory
streaming_wals_directory

-------—-----------------------------------
I have already created the replication slots and started the pg_receivexlog remotely from the batman server. Was are streaming and is coming to the incoming_wals_directory 
Please note that there are 2 more servers configured with barman in this backup hosts which is working fine.. The o my difference theyvhave is that they are configured with backup_method = rsync.

I wanted to make use of pg_receivexlog instead of rsync. Hence this poc..

Please help. 

Thanks,

Roy


Re: Barman issue

From
Martin Marques
Date:
El 05/10/18 a las 06:50, Rijo Roy escribió:
> Hello Experts,
> 
> I have a server rhel 6.9 installed with barman 2.3 which is configured
> to take backup from Postgresql 10 installed in a remote host and the
> same is working.

You should upgrade to 2.4, although I can't see anything relevant in the
changelog to your issue. Anyway, upgrade.

> I am trying to do a poc on streaming backup and streaming wal method by
> making use of the pg_receivewal. I have already created a user with
> replication privilege the same is added in pg_hba. conf. And I am able
> to connect remotely using the user created.
> But when I am running barman check pg
> pg is the name given to the remote dB host. I am getting an error like this
> EXCEPTION: LooseVersion instance has no attribute 'version'

You should be getting more output than just that. Have you checked the
barman logs?

> Below I am pasting the conf files used:
> [pg] 
> conninfo
> streaming_conninfo
> streaming_archiver = on
> slot_name = barman
> backup_method = postgres 
> path_prefix = Postgresql bin path
> basebackups_directory
> errors_directory
> incoming_wals_directory
> streaming_wals_directory

Set log_level to DEBUG while trying to find the reason for that exception.

> -------—-----------------------------------
> I have already created the replication slots and started the
> pg_receivexlog remotely from the batman server. Was are streaming and is
> coming to the incoming_wals_directory 

Did you start start pg_receivexlog (which in PG10 is actually called
pg_receivewal) manually or using `barman receive-wal`? (also, `barman
cron` should automatically start streaming if you have everything
configured correctly)

Regards,

-- 
Martín Marqués                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services