source: TI01-discovery-Ingest/trunk/v4.3.0/ingestAutomation-upgrade/backup_postgres.py @ 7183

#
# Make backups of postgres databases on glue
#
# Uses  pg_dump and pg_dumpall to get complete dumps to disc.
# The dump files are named  using the current date and time and
# are placed in a directory which gets backed up to tape.
#
# On glue this is normally run as user postgres
#
# History:
#
#     1-Mar-2006 SEL First version
#
import sys
import os
import commands

outdir = '/disks/glue1/postgresBackup/dev'
 
date_string = commands.getoutput ("date +'%y%m%d_%H%M'")


outfile = outdir + '/ndg_spatial_' + date_string  + '.sql.gz'
cmd     = '/usr/local/pgsql/bin/pg_dump -h glue -U postgres ndg_spatial |gzip -c > %s' %outfile
print "dumpfile: ", outfile 
print "Executing: ", cmd
status = os.system (cmd)

outfile = outdir + '/ndg_B_metadata_' + date_string  + '.sql.gz'
cmd     = '/usr/local/pgsql/bin/pg_dump -h glue -U postgres ndg_B_metadata | gzip -c > %s' %outfile
print "dumpfile: ", outfile
print "Executing: ", cmd
status = os.system (cmd)

# This version doesn't seem to have the globals only option. do a dumpall instead.
#outfile = outdir + '/ndg_globals' + date_string  + '.sql.gz'
#cmd     = '/usr/local/pgsql/bin/pg_dump -h glue -U postgres --globals-only | gzip -c > %s' %outfile
#print "dumpfile: ", outfile
#print "Executing: ", cmd
#status = os.system (cmd)

outfile = outdir + '/ndg_fullbackup_' + date_string  + '.sql.gz'
cmd     = '/usr/local/pgsql/bin/pg_dumpall -h glue -U postgres  | gzip -c > %s' %outfile
print "dumpfile: ", outfile
print "Executing: ", cmd
status = os.system (cmd)

print "postgres_backup script completed " + commands.getoutput ("date +'%y%m%d_%H%M'")