MySQLBackup/postgres-backup.sh at master · jdineen21/MySQLBackup · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
#!/bin/bash

# set -o pipefail
# set -o errexit
# set -o errtrace
# set -o nounset
# set -o xtrace

BACKUP_DIR=${BACKUP_DIR:-/tmp/scstemp}
BOTO_CONFIG_PATH=${BOTO_CONFIG_PATH:-/root/.boto}
GCS_BUCKET=${GCS_BUCKET:-}
GCS_KEY_FILE_PATH=${GCS_KEY_FILE_PATH:-}

PSQL_HOST=${PSQL_HOST:-0.0.0.0}
PSQL_PORT=${PSQL_PORT:-5432}
PSQL_DB=${PSQL_DB:-tobackup}
PSQL_USER=${PSQL_USER:-root}
PSQL_PASSWORD=${PSQL_PASSWORD:-root}

MONGODB_OPLOG=${MONGODB_OPLOG:-true}

backup() {
  # mkdir -p $BACKUP_DIR
  date=$(date "+%Y-%m-%dT%H:%M:%SZ")
  archive_name="backup-$date.tar.gz"

#   cmd_auth_part=""
#   if [[ ! -z $MONGODB_USER ]] && [[ ! -z $MONGODB_PASSWORD ]]
#   then
#     cmd_auth_part="--username=\"$MONGODB_USER\" --password=\"$MONGODB_PASSWORD\""
#   fi

#   cmd_db_part=""
#   if [[ ! -z $MONGODB_DB ]]
#   then
#     cmd_db_part="--db=\"$MONGODB_DB\""
#   fi

#   cmd_oplog_part=""
#   if [[ $MONGODB_OPLOG = "true" ]]
#   then
#     cmd_oplog_part="--oplog"
#   fi

  #cmd="mysql -h\"$MYSQL_HOST\" -P\"$MYSQL_PORT\" $cmd_auth_part $cmd_db_part $cmd_oplog_part --gzip --archive=$BACKUP_DIR/$archive_name"
  #cmd="mysql -h\"$MYSQL_HOST\" -P\"$MYSQL_PORT\" $cmd_auth_part $cmd_db_part $cmd_oplog_part --gzip --archive=$BACKUP_DIR/$archive_name"
  cmd="pg_dump -h${PSQL_HOST} \
   -p${PSQL_PORT} \
   -U${PSQL_USER} \
   -P${PSQL_PASSWORD} \
   ${PSQL_DB} | gzip > ${archive_name}"

  echo "$cmd"
  echo "starting to backup Postgres database host=$MYSQL_HOST port=$MYSQL_PORT"
  eval "$cmd"
}

# upload_to_gcs() {
#   if [[ $GCS_KEY_FILE_PATH != "" ]]
#   then
# cat <<EOF > $BOTO_CONFIG_PATH
# [Credentials]
# gs_service_key_file = $GCS_KEY_FILE_PATH
# [Boto]
# https_validate_certificates = True
# [GoogleCompute]
# [GSUtil]
# content_language = en
# default_api_version = 2
# [OAuth2]
# EOF
#   fi
#   echo "uploading backup archive to GCS bucket=$GCS_BUCKET"
#   gsutil cp $BACKUP_DIR/$archive_name $GCS_BUCKET
# }

err() {
  err_msg="something went wrong on line $(caller)"
  echo $err_msg >&2
}

cleanup() {
  rm $BACKUP_DIR/$archive_name
}

trap err ERR
backup
#upload_to_gcs
#cleanup
echo "backup done!"