def _backup_postgresql_psycopg2_db(self, db_conf, outfile, tmp_outfile):
passwd = ('export PGPASSWORD=%s;' % db_conf['password']
if db_conf['password'] else '')
outfile = '%s.pgsql.gz' % outfile
ret = os.system('%s pg_dump %s > %s' %
(passwd, build_postgres_args(db_conf), tmp_outfile.name))
return ret, outfile
def _backup_postgresql_psycopg2_db(self, db_conf, outfile):
passwd = ('export PGPASSWORD=%s;' % db_conf['password']
if db_conf['password'] else '')
outfile = '%s.pgsql.gz' % outfile
_check_writable(outfile)
ret = os.system('%s pg_dump %s | gzip -9 > %s' %
(passwd, build_postgres_args(db_conf), outfile))
return ret, outfile
def _backup_postgresql_psycopg2_db(self, db_conf, outfile, tmp_outfile):
passwd = ('export PGPASSWORD=%s;' %
db_conf['password'] if db_conf['password'] else '')
outfile = '%s.pgsql.gz' % outfile
ret = os.system(
'%s pg_dump %s > %s' %
(passwd, build_postgres_args(db_conf), tmp_outfile.name))
return ret, outfile
def _load_postgresql_psycopg2_db(self, db_conf, infile):
passwd = "export PGPASSWORD=%s;" % db_conf["password"] if db_conf["password"] else ""
return os.system("%s psql %s -f %s" % (passwd, build_postgres_args(db_conf), infile))
