Creating a System Backup in Foresight Mobile Platform 22.04 or Earlier

#!/bin/bash

set -e

# Declare directory for storing backup files
DATA_FOLDER=$(cd "$(dirname "${BASH_SOURCE[0]}")"; pwd -P)/standalone_backup_$(date "+%F-%H-%M-%S")
mkdir ${DATA_FOLDER}

function save_postgres_data(){
  # Specify databases to be copied
  for db_label in main cache local
  do
    # Create a command for creating a database backup
    DUMP_COMMAND="PGPASSWORD=\$POSTGRES_${db_label^^}_PASSWORD pg_dump -O -x --clean --if-exists -h \$POSTGRES_${db_label^^}_HOST -p \$POSTGRES_${db_label^^}_PORT -d \$POSTGRES_${db_label^^}_NAME -U \$POSTGRES_${db_label^^}_USERNAME"

    echo "Create backup of ${db_label} database in ${DATA_FOLDER}/${db_label}db.sql..."
    docker compose -f docker-compose.standalone.yml exec hhive bash -c "${DUMP_COMMAND}" > ${DATA_FOLDER}/${db_label}db.sql
  done
}

function save_minio_data(){
  echo "Create a backup of minio database…"
  DUMP_COMMAND="mkdir -p /tmp/minio_backup/ && mc mirror --overwrite --remove local /tmp/minio_backup/"
  docker compose -f docker-compose.standalone.yml exec minio bash -c "${DUMP_COMMAND}"

  echo "Copy backup of the minio database to ${DATA_FOLDER}/minio_backup"
  docker compose -f docker-compose.standalone.yml cp minio:/tmp/minio_backup ${DATA_FOLDER}/minio_backup

  echo "Delete backup of the minio database from container"
  docker compose -f docker-compose.standalone.yml exec minio rm -fR /tmp/minio_backup
}

save_postgres_data
save_minio_data
echo "Creating backup is finished"

#!/bin/bash

set -e

# Declare directory for placing backup files
DATA_FOLDER=$(cd "$(dirname "${BASH_SOURCE[0]}")"; pwd -P)/cluster_backup_$(date "+%F-%H-%M-%S")
mkdir ${DATA_FOLDER}

# Declare the namespace, in which mobile platform server is running
NAMESPACE=fmp

function save_postgres_data(){
  DASHBOARD_POD=$(kubectl -n ${NAMESPACE} get pod -l app=dashboard -o jsonpath="{.items[0].metadata.name}")
  echo "Dashboard container for operations ${DASHBOARD_POD}"

  # Specify databases to be copied
  for db_label in main cache local
  do
    DUMP_COMMAND="PGPASSWORD=\$POSTGRES_${db_label^^}_PASSWORD pg_dump -O -x --clean --if-exists -h \$POSTGRES_${db_label^^}_HOST -p \$POSTGRES_${db_label^^}_PORT -d \$POSTGRES_${db_label^^}_NAME -U \$POSTGRES_${db_label^^}_USERNAME"

    echo "Create a backup of ${db_label} database to ${DATA_FOLDER}/${db_label}db.sql..."
    kubectl -n ${NAMESPACE} exec ${DASHBOARD_POD} -c dashboard -i -- bash -c "${DUMP_COMMAND}" > ${DATA_FOLDER}/${db_label}db.sql
  done
}

function save_minio_data(){
  MINIO_POD=$(kubectl -n ${NAMESPACE} get pod -l app.kubernetes.io/name=minio -o jsonpath="{.items[0].metadata.name}")
  echo "Minio container for operations ${MINIO_POD}"

  echo "Creste a backup of minio database…"
  DUMP_COMMAND="mc alias set local http://localhost:9000 \$MINIO_ROOT_USER \$MINIO_ROOT_PASSWORD && mkdir -p /tmp/minio_backup/ && mc mirror --overwrite --remove local /tmp/minio_backup/"
  kubectl -n ${NAMESPACE} exec $MINIO_POD -- bash -c "${DUMP_COMMAND}"

  echo "Copy backup if the minio database to ${DATA_FOLDER}/minio_backup"
  kubectl cp --retries=-1 ${NAMESPACE}/${MINIO_POD}:/tmp/minio_backup ${DATA_FOLDER}/minio_backup

  echo "Delete backup of the minio database from the pod"
  kubectl -n ${NAMESPACE} exec $MINIO_POD -- rm -fR /tmp/minio_backup
}

save_postgres_data
save_minio_data
echo "Creating backup is finished"

#!/bin/bash

set -e

# Declare directory for placing backup files
DATA_FOLDER=$(cd "$(dirname "${BASH_SOURCE[0]}")" ; pwd -P )

# Declare the namespace, in which mobile platform server is running
NAMESPACE=fmp

# Declare names of pods, via which data will be exported and imported
DASHBOARD_POD=$(kubectl -n ${NAMESPACE} get pod -l app=dashboard -o jsonpath="{.items[0].metadata.name}")
echo "Dashboard container for operation ${DASHBOARD_POD}"
STORAGE_POD=$(kubectl -n ${NAMESPACE} get pod -l app=storage -o jsonpath="{.items[0].metadata.name}")
echo "Storage container for operation ${STORAGE_POD}"

function save_postgres_data(){
  # Specify databases to be copied
  for db_label in main cache local
  do
    for var in POSTGRES_${db_label^^}_HOST POSTGRES_${db_label^^}_PORT POSTGRES_${db_label^^}_NAME POSTGRES_${db_label^^}_USERNAME POSTGRES_${db_label^^}_PASSWORD
    do
      # Declare variables for connecting to databases
      echo "export ${var}"
      echo $(kubectl -n ${NAMESPACE} exec $DASHBOARD_POD -- env | grep $var | cut -d "=" -f2)
    done

    # Create a command for executing database dump
    DUMP_COMMAND="PGPASSWORD=\$POSTGRES_${db_label^^}_PASSWORD pg_dump -O -x -h \$POSTGRES_${db_label^^}_HOST -p \$POSTGRES_${db_label^^}_PORT -d \$POSTGRES_${db_label^^}_NAME -U \$POSTGRES_${db_label^^}_USERNAME > /tmp/${db_label}db_dump.sql"
    echo "Execute dump of ${db_label} database…"
    kubectl -n ${NAMESPACE} exec $DASHBOARD_POD -- bash -c "${DUMP_COMMAND}"

    echo "Dump of ${db_label} database is executed. Download this dump…"
    kubectl cp ${NAMESPACE}/${DASHBOARD_POD}:/tmp/${db_label}db_dump.sql $DATA_FOLDER/${db_label}db_dump.sql

    echo "Dump of ${db_label}-database is downloaded. Clear temporary dump file…"
    kubectl -n ${NAMESPACE} exec ${DASHBOARD_POD} -- rm /tmp/${db_label}db_dump.sql

    echo "Temporary dump file of ${db_label} database is deleted"
  done
}

function save_minio_data(){
  echo "Copy files from local storage to ${DATA_FOLDER}/share/"
  kubectl cp ${NAMESPACE}/${STORAGE_POD}:/share/ ${DATA_FOLDER}/share/

  echo "Copy media files to ${DATA_FOLDER}/media/"
  kubectl cp ${NAMESPACE}/${DASHBOARD_POD}:/var/hhive/media/ ${DATA_FOLDER}/media/

  echo "Copy certificates to ${DATA_FOLDER}/media/ssl/"
  kubectl cp ${NAMESPACE}/${DASHBOARD_POD}:/var/hhive/nginx/ssl/ ${DATA_FOLDER}/media/ssl/
}

save_postgres_data
save_minio_data