continuous archiving: FAILED , Barman check

[savita...@gmail.com]

I have setup the archive command and still getting this on barman check 

My archive command

postgres-# ;

 wal_level

-----------

 logical

(1 row)

postgres=# show archive_command ;

                              archive_command

----------------------------------------------------------------------------

 rsync -a %p barman@<barman server ip>:/mnt/data/barman/cgdb_streaming/incoming/%f

(1 row)

postgres=# show archive_mode ;

 archive_mode

--------------

 on

(1 row)

barman@prod-usw2-cs-main-dbbackups:~$ barman check cgdb_streaming

Server cgdb_streaming:

PostgreSQL: OK

superuser or standard user with backup privileges: OK

PostgreSQL streaming: OK

wal_level: OK

replication slot: OK

directories: OK

retention policy settings: OK

backup maximum age: FAILED (interval provided: 3 days, latest backup age: No available backups)

compression settings: OK

failed backups: FAILED (there are 1 failed backups)

minimum redundancy requirements: FAILED (have 0 backups, expected at least 7)

ssh: OK (PostgreSQL server)

systemid coherence: OK

pg_receivexlog: OK

pg_receivexlog compatible: OK

receive-wal running: OK

archive_mode: OK

archive_command: OK

continuous archiving: FAILED

archiver errors: OK

Thanks

Savita Pandey

[Luca Ferrari]

On Wed, May 5, 2021 at 9:54 PM savita...@gmail.com
<savita...@gmail.com> wrote:
> continuous archiving: FAILED
> archiver errors: OK

I would chec:
1) postgresql error log to see if there is something wrong with your
archive_command (e.g., ssh connection keys);
2) barman cron not running (even if with rsync you should not need it
with regard to archiving);
3) barman switch-xlog --force --archive

My guess is for 1.

Luca

[Savita Pandey]

I checked 

There is no error in the Postgresql log , the receive-wal process runs 

barman cron runs

3) barman switch-xlog --force --archive --command worked , but barman check still failed on continuous archiving 

Thanks

Savita 

--
--
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/CAKoxK%2B4kQQMkKbAuGVq-91s-64nCPv10HN9%2B1MJ-VW_WYtAnXw%40mail.gmail.com.

--

Thanks

Savita Pandey

469537803 

[Luca Ferrari]

On Thu, May 6, 2021 at 9:03 PM Savita Pandey <savita...@gmail.com> wrote:
>
> I checked
>
> There is no error in the Postgresql log , the receive-wal process runs
> barman cron runs
> 3) barman switch-xlog --force --archive --command worked , but barman check still failed on continuous archiving
>

Any hint in the barman logs?

Luca

[Savita Pandey]

Ok Digged more in the postgresql logs i see message 

The failed archive command was: rsync -a pg_wal/0000000100003F4B00000010 bar...@10.1.1.62:/mnt/data/barman/cgdb_streaming/incoming/0000000100003F4B00000010

But the ssh between barman server and the pg server works , not sure what else i am doing wrong 

Thanks

Savita pandey

--
--
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/CAKoxK%2B5ewExcaBbX0BMNJD%2BTQQ8a3APw4joKGq8PqA5RyOxQ1A%40mail.gmail.com.

[Luca Ferrari]

On Fri, May 7, 2021 at 5:37 PM Savita Pandey <savita...@gmail.com> wrote:
>
> Ok Digged more in the postgresql logs i see message
>
> The failed archive command was: rsync -a pg_wal/0000000100003F4B00000010 bar...@10.1.1.62:/mnt/data/barman/cgdb_streaming/incoming/0000000100003F4B00000010

You should become the postgres user (or the one that sends the WALs)
and try the command, you could have a mispelled archive path or an ssh
key problem:


cd $PGDATA
sudo -u postgres rsync -a pg_wal/0000000100003F4B00000010
bar...@10.1.1.62:/mnt/data/barman/cgdb_streaming/incoming/0000000100003F4B00000010

or something like that.
Unless you have a very good reason, I would also use
barman-wal-archive to push wals to the other machine, and the command
has also a test option:

archive_command='barman-wal-archive -U barman 10.1.1.62 cgdb_streaming %p'

Luca

[Savita Pandey]

barman-wal-archive -- This command is not working 

I have set archive command correctly this does work on other server , where i did testing , just doesnt work on this particular server 

Thanks

Savita Pandey 

--
--
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/CAKoxK%2B5Er_eZUk0UDMQMXiHP6ci5NdpN0xbsqH2YX6Jm1L_2XQ%40mail.gmail.com.

[Luca Ferrari]

On Mon, May 10, 2021 at 5:20 PM Savita Pandey <savita...@gmail.com> wrote:
>
> barman-wal-archive -- This command is not working
> I have set archive command correctly this does work on other server , where i did testing , just doesnt work on this particular server
>

When you say it does not work, you are referring to rsync or
barman-wal-archive? And what is not working?
As far as I remembeer barman-wal-archive is now shipped with packaged
barman, but I could be wrong.
Can you provide more details about what is working (if anything is)
and what is not?

Luca