Barman issue
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
Sent from Yahoo Mail on Android
Import Notes
Reference msg id not found: 175753061.5116038.1538733055387.ref@mail.yahoo.com
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