Re: running pg_dump from python

On Jun 15, 2009, at 5:17 AM, Jasen Betts wrote:

> On 2009-06-14, Garry Saddington <garry(at)schoolteachers(dot)co(dot)uk> wrote:
>> I ahve the following python file that I am running as an external
>> method
>> in Zope.
>>
>> def backup():
>> import os
>> os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack >
>> c:/scholarpack/ancillary/scholarpack.sql")
>
> are you sure you're using os.popen correctly?
> you don't appear to be waiting for the pg_dump process to finish.

Right, the popen stuff should be something like:

p = os.popen("c:/scholarpack/postgres/bin/pg_dump scholarpack > c:/
scholarpack/ancillary/scholarpack.sql 2> c:/scholarpack/ancillary/
dump.err")
status = p.close()

Then check status to see if the command was successful or not.

Erik Jones, Database Administrator
Engine Yard
Support, Scalability, Reliability
866.518.9273 x 260
Location: US/Pacific
IRC: mage2k