execute pg_dump via python - Mailing list pgsql-general

From Garry Saddington
Subject execute pg_dump via python
Date
Msg-id 200710251211.59905.garry@schoolteachers.co.uk
Whole thread Raw
Responses Re: execute pg_dump via python  ("Trevor Talbot" <quension@gmail.com>)
Re: execute pg_dump via python  (Andy <nospam@noplace.com>)
List pgsql-general
I am using zope on windows with an external python method to backup my
database. I am struggling to run the following command:

pg_dump.exe database > file

I have tried using os.popen - no luck
and also subprocess.Popen.

eg:
import subprocess

subprocess.Popen(['c:/dir/dir/pg_dump.exe','database','>','c:/dir/dir/output
file'])

The command string works perfectly in a terminal. Does anyone know how I
should be doing this? I get no errors or traceback when I try the method
through Zope.

regards
garry

pgsql-general by date:

Previous
From: tfinneid@student.matnat.uio.no
Date:
Subject: Re: select count() out of memory
Next
From: "Peter Childs"
Date:
Subject: Re: conditional alter table add ?