[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.