Wal-g backup and restore command doenst work Ubuntu 22.04 due syntax issue

[garry-t]

It is not clear why it doesnt work. Problem seems like here '%{http_code}'. I see that it marked was tested in Ubuntu 22.04.
Was wal-g also tested?

postgresql_cluster/vars/main.yml

Lines 483 to 488 in f59badf

	wal_g_backup_command:
	- "[ $(curl -s -o /dev/null -w '%{http_code}' http://{{ inventory_hostname }}:{{ patroni_restapi_port }}) = '200' ]"
	- " && wal-g backup-push {{ postgresql_data_dir }} > {{ postgresql_log_dir }}/walg_backup.log 2>&1"
	wal_g_delete_command:
	- "[ $(curl -s -o /dev/null -w '%{http_code}' http://{{ inventory_hostname }}:{{ patroni_restapi_port }}) = '200' ]"
	- " && wal-g delete retain FULL 4 --confirm > {{ postgresql_log_dir }}/walg_delete.log 2>&1"

Tried with :
/bin/bash
/bin/sh
No reason, same issue.
syslog output CMD (sh -c 'curl -o /dev/null -s -w ")

[vitabaks]

Hi @garry-t

I will be grateful for PR if there is a mistake here and you manage to solve it.

I usually use pgbackrest and a simple check, for example:

if [ $(psql -tAXc 'select pg_is_in_recovery()') = 'f' ]; then pgbackrest --type=full --stanza={{ pgbackrest_stanza }} backup; fi

[vitabaks]

please attach the cron job file located in /etc/cron.d/walg

[garry-t]

Ok, understood.

cat /etc/cron.d/walg 
#Ansible: WAL-G: Create daily backup
30 3 * * * postgres  [ $(curl -s -o /dev/null -w '%{http_code}' http://IP:8008) = '200' ] && wal-g --config /var/lib/postgresql/.walg.json backup-push /var/lib/postgresql/15/main > /var/log/postgresql/walg_backup.log 2>&1
#Ansible: WAL-G: Delete old backups
30 6 * * * postgres  [ $(curl -s -o /dev/null -w '%{http_code}' http://IP:8008) = '200' ] && wal-g --config /var/lib/postgresql/.walg.json delete retain FULL 4 --confirm > /var/log/postgresql/walg_delete.log 2>&1

So I'll think how to solve it.