#!/usr/bin/env python
# -*- coding: utf8 -*-
import sys,os,time
db_user = 'postgres'
db_pwd = 'postgres'
db_port = '5432'
db_name = 'CCIC2'
backup_path = '/home/sunjc/backupdb/'
cmd_path = '/usr/local/pgsql/bin/'
log_path = backup_path 'log'
# 创建日志函数
def writeLogs(filename,contents):
f = file(filename,'aw')
f.write(contents)
f.close()
today = backup_path time.strftime('%Y-%m-%d')
fname = today os.sep time.strftime('%Y-%m-%d') '_' db_name '.backup'
# 创建备份目录
if not os.path.exists(today):
Msg = '-'*30 time.strftime('%Y-%m-%d,%H:%M:%S') '-'*30 'n'
if(os.mkdir(today)) == None:
Msg = '** 成功创建备份目录： ' today 'nn'
writeLogs(log_path,Msg)
else:
Msg = '!! 创建备份目录： ' today '失败，请检查目录是否可写！nn'
writeLogs(log_path,Msg)
sys.exit()
# 备份 CCIC2数据库
cmd_dump = "%spg_dump -i -h localhost -p %s -U %s -F c -b -v -f %s %s" %
(cmd_path,db_port,db_user,fname,db_name)
# 执行备份命令
if os.system(cmd_dump) == 0:
writeLogs(log_path,'数据备份为： ' fname 'n')
else:
writeLogs(log_path,'数据备份失败！n')
