Search Postgresql Archives

Re: running pg_dump from python

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




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

On 2009-06-14, Garry Saddington <garry@xxxxxxxxxxxxxxxxxxxx> 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






--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux