DDT/README.md

DDT

Downloads postgresql dumps from servers via rsync over ssh, tests them by restoring on a test DB server.
Sends results to email via mutt(i'm using it cuz it add attachments).

Servers addresses, dump folders, Dump search patterns and test DB names are stored in dbases array in form of a table:

dbases=(
#-----------------------+-------------------+-----------------------------+--------------------------------------+
#    Ssh alias(addr)    |Dump folder(bkpath)| Dump search pattern(dbname) | Test DB name(dbtest) Must be unique! |
#-----------------------+-------------------+-----------------------------+--------------------------------------+
      'moscow'             '/backup'           'data_db_%d.%m.%Y'                   'moscow_data_prod_db'
      'rybinsk'            '/backup/new'       '%Y%m%d_db_data'                     'rybinsk_data_prod_db'
      'yaroslavl'          '/dumps'            'data_db%Y'                          'yar_data_prod_db'
#-----------------------+-------------------+-----------------------------+--------------------------------------+
); N=${#dbases[*]}; C=4

Have fun)!

^{Don't hold yourself, buy me a beer)}