[Staging] the backup scripts are enable on the ZFS node

Currently it seems the backup script is enabled on the node : patroni-zfs-01-db-gstg.c.gitlab-staging-1.internal

root@patroni-zfs-01-db-gstg.c.gitlab-staging-1.internal:/home/jfinotto# su - gitlab-psql
$ crontab -l
# Chef Name: full wal-g backup
0 0 * * * /opt/wal-g/bin/backup.sh >> /var/log/wal-g/wal-g_backup_push.log 2>&1

this node is a cascade node from staging:

+ Cluster: pg11-ha-cluster-zfs (6951753467583460143) +---------------+----------------+---------+----+-----------+
| Member                                             | Host          | Role           | State   | TL | Lag in MB |
+----------------------------------------------------+---------------+----------------+---------+----+-----------+
| patroni-zfs-01-db-gstg.c.gitlab-staging-1.internal | 10.224.48.101 | Standby Leader | running |  2 |           |
+----------------------------------------------------+---------------+----------------+---------+----+-----------+

My understanding is that this script should be enabled on the node where we execute the GCS snapshots (On node 06 or 05, to be similar to production) :

root@patroni-01-db-gstg.c.gitlab-staging-1.internal:/home/jfinotto# gitlab-patronictl list
+ Cluster: pg12-ha-cluster-stg (6951753467583460143) ------------+---------+---------+----+-----------+---------------------+
| Member                                         | Host          | Role    | State   | TL | Lag in MB | Tags                |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-01-db-gstg.c.gitlab-staging-1.internal | 10.224.29.101 | Leader  | running |  2 |           |                     |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-02-db-gstg.c.gitlab-staging-1.internal | 10.224.29.102 | Replica | running |  2 |        11 |                     |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-03-db-gstg.c.gitlab-staging-1.internal | 10.224.29.103 | Replica | running |  2 |        11 |                     |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-04-db-gstg.c.gitlab-staging-1.internal | 10.224.29.104 | Replica | running |  2 |        11 |                     |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-05-db-gstg.c.gitlab-staging-1.internal | 10.224.29.105 | Replica | running |  2 |         0 | nofailover: true    |
|                                                |               |         |         |    |           | noloadbalance: true |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-06-db-gstg.c.gitlab-staging-1.internal | 10.224.29.106 | Replica | running |  2 |        10 | nofailover: true    |
|                                                |               |         |         |    |           | noloadbalance: true |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+
| patroni-07-db-gstg.c.gitlab-staging-1.internal | 10.224.29.107 | Replica | running |  2 |         0 |                     |
+------------------------------------------------+---------------+---------+---------+----+-----------+---------------------+

Acceptance criteria:

  • Fix backup script location and understand why changed with the new node.