DBs Backups

dbs_dump.sh

#!/bin/bash

versions="80 90 100 110"
for version in $versions;do
    echo "Creating ~ /mnt/manager1/BACKUPS/odoo$version ...."
    mkdir -p ~ /mnt/manager1/BACKUPS/odoo$version 
done   


############################ V8 ################################################                                         

## aws80
#all_databases="arq247 base.quality80.tkobr.com cna coexiste elsever ferneto impala itacarepar itacareville kappa pjcontabil primeschool tkobr tracelayout unitedhr vistaalegre"  
databases="arq247 cna coexiste elsever ferneto impala itacarepar itacareville pjcontabil primeschool tkobr tracelayout unitedhr"
dbuser="80"
dbhost="pg01-20181030090000.c3ajltqycujc.sa-east-1.rds.amazonaws.com"
echo "Starting backup in ~ /mnt/manager1/BACKUPS/odoo$dbuser ..."
for database in $databases; do
   echo "starting backup $database .."
   pg_dump $database -p 6543 -U aws$dbuser -h $dbhost -O > /mnt/manager1/BACKUPS/odoo$dbuser/$(date +'%Y_%m_%d_%H_%M')_$database.sql
   echo "backup done for $database "
done

############################ V10 ################################################

#all_databases="001.tko-br.com 001.tko-uk.com 002.tko-br.com 003.tko-br.com acert.tko-br.com base.tko-uk.com base_template.tko-br.com base_template.tko-pt.com bv.lincersolucoes.com.br coexiste.com.br coexiste.tko-br.com coexiste_odoo.tko-br.com coexiste_odoo_cashflow.tko-br.com coexiste_rpt.tko-br.com crm.tko-uk.com demo.tko-uk.com elsever.tko-br.com hr.tko-uk.com kappa.tko-br.com mgs.tko-br.com mmp.quality100.tko-br.com mmp10 nfse.v100.tko-br.com pjcontabil10.tkobr.com primeeducation.tko-pt.com primegroup.tko-pt.com primeschool.pt primeschool10.tkobr.com primeuniversity.tko-pt.com primeuniversity2.tko-pt.com project.tko-uk.com pronova.tkobr.com pronova10.tko-br.com server.quality100.tko-uk.com server.tko-br.com server.tko-pt.com server.tko-uk.com template.tko-br.com tko.tko-br.com tko.tko-pt.com tko.tko-uk.com tracelayout-bkp.tko-br.com tracelayout.tko-br.com tracelayout10.tkobr.com website.tko-uk.com zimbora.tko-uk.com"

databases="base.tko-uk.com coexiste.com.br coexiste.tko-br.com coexiste_odoo.tko-br.com elsever.tko-br.com mmp.quality100.tko-br.com mmp10 pjcontabil10.tkobr.com primeschool.pt primeuniversity.tko-pt.com"
dbuser="100"
dbhost="pg01-20181030090000.c3ajltqycujc.sa-east-1.rds.amazonaws.com"
echo "Starting backup in ~ /mnt/manager1/BACKUPS/odoo$dbuser ..."
for database in $databases; do
   echo "starting backup $database .."
   pg_dump $database -p 6543 -U aws$dbuser -h $dbhost -O > /mnt/manager1/BACKUPS/odoo$dbuser/$(date +'%Y_%m_%d_%H_%M')_$database.sql
   echo "backup done for $database "
done


############################ V11 ################################################

#all_databases="base_br.tkopen.com br_base.tkopen.com csarts.tkopen.com ddmrp.tkopen.com demo.tkopen.com demo.v110.tko-br.com demo.v110.tkobr.com liveintellectus.com meritsunday.tkopen.com primeschool.tkopen.com primeschool_backup_v2.tkopen.com primeschool_bkp.tkopen.com primeschool_template.tkopen.com primeschoool.tkopen.com primeuniversity.tkopen.com probuse.tkopen.com pronova.com.br quintadavigia.com saas_server.tkopen.com saturnprogress.com tkobr.com tkopen.com tracelayout-bkp.tkopen.com tracelayout.tkopen.com tracelayout_backup.tkopen.com"
databases="base.tkopen.com liveintellectus.com meritsunday.tkopen.com pronova.com.br quintadavigia.com saas_server.tkopen.com saturnprogress.com tkobr.com tkopen.com tracelayout.tkopen.com"
dbuser="110"
dbhost="pg01-20181030090000.c3ajltqycujc.sa-east-1.rds.amazonaws.com"
echo "Starting backup in ~ /mnt/manager1/BACKUPS/odoo$dbuser ..."
for database in $databases; do
   echo "starting backup $database .."
   pg_dump $database -p 6543 -U aws$dbuser -h $dbhost -O > /mnt/manager1/BACKUPS/odoo$dbuser/$(date +'%Y_%m_%d_%H_%M')_$database.sql
   echo "backup done for $database "
done