Re: running pg_dump from python

Scott Mead wrote:
> On Sun, Jun 14, 2009 at 4:06 PM, Garry Saddington
> <garry(at)schoolteachers(dot)co(dot)uk <mailto: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")
>
>
> 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?

Yes
> What user is this running as?
scholarpack but no OS user scholarpack, but why should it create a file
then not fill the contents?
> 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
Zope is running as user scholarpack and I have tried the above as -U
scholarpack and it works

>
> Try running that on the commandline first, by itself, as the same
> user that runs the python script.

Looks like the script is at fault
regards
Garry