pgsqldump.py

gistfile1.py

#!/usr/bin/python

import os
from datetime import datetime, time, timedelta, date
import syslog

DB_HOST = 'localhost'
DB_USER = 'DB_USER'
DB_NAME = 'DB_NAME'
BACKUP_PATH = '/backups/'
DAYS_OVER = 10

passFileCmd = 'export PGPASSFILE=/root/.pgpass'
os.popen(passFileCmd)

date = datetime.now()
strDate = date.strftime('%d_%m_%Y')
oldDate = date - timedelta(days = DAYS_OVER)
strOldDate = oldDate.strftime('%d_%m_%Y')

currentBackupName = BACKUP_PATH +  DB_NAME + "_"  + strDate + ".gz"
dumpcmd = "pg_dump -U " + DB_USER + " -w -d " + DB_NAME + " | gzip >> " + currentBackupName
retval = os.popen(dumpcmd).read()

oldFile = BACKUP_PATH + DB_NAME + '_' + strOldDate + '.gz'
if(os.path.exists(oldFile)):
    try:
	os.remove(oldFile)
    except OSError, e:
	syslog.syslog(syslog.LOG_ERR, e)