Search Postgresql Archives

Re: running pg_dump from python

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

 



On Sun, Jun 14, 2009 at 4:06 PM, 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")

    Have you tried running that command on the command line by itself (as the same user that runs the phython)?  If that gives you the same result, then you know for sure that it's a function of the pg_dump options and not the python script.

    Are you looking for the full SQL of the scholarpack database?  What user is this running as?  Remember, in your case, pg_dump is going to try to connect as the OS username running your script.  you may want to include the username option to pg_dump:

     pg_dump -U <username> scholarpack

     Try running that on the commandline first, by itself, as the same user that runs the python script.  If it works, then you know for sure that any problems from here on out are just a function of the python script and not pg_dump itself.

--Scott


[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